Counting work days without Bank holidays and personal days in Excel.
Carrying on from my previous tip on how to count days between two dates that are just week days. We need to investigate adding in personal days and bank holidays. If...
How to count only week days in Excel
My students are great at finding me new tips to write. This week I had one who wanted to count the number of days between two dates but without the weekends....
Finding the cell that contains just a space in Excel
I have many clients who have the same problem with importing data from other applications into Excel. All seems perfectly well until they start to analyse the data only to find...
Using Animation in PowerPoint Presentations
Hands up those of you who go to presentations and take notes on the design of the presentation. What works and what doesn’t? I guess most of you have not raised...
Linking spreadsheets in Excel 19
A while ago I wrote a tip on how to consolidate two or more spreadsheets together. It occurred to me that maybe some of you were not aware of the simple...
Change and keep column settings in Explorer 10
You would be amazed how many times I get asked this question. “How do I keep the settings of particular columns in Explorer for any future folders I create as a...
Determine what size the window of your app will be the next time you...
We all use more than one application at any time. Usually they open in full screen. This is not always what we want. Many of my students these days are lucky...
How to make a cell change colour of the background whilst typing in new...
In my training course the other day a student asked me how they could make Excel change the background of a cell when they typed in a new word. The simplest...
Using dates that automatically update in Excel
In a previous tip I showed you that you can input dates three different ways into a spreadsheet. One of them was the formula that allowed the result change every day,...
Do you need a date to automatically, or not, update in Excel?
There are a few ways to input dates into a spreadsheet. One, you can type the date you require in the format you like. Two, you can type a formula that...
LATEST NEWS
OmniSci delivers a CPU driven version of its analytics platform
OmniSci has announced a CPU driven version of the OmniSci Enterprise Edition. It also announced a collaboration with Intel to improve the performance of...
Hussey Coding launches UK Magento project marketplace
Hussey Coding has launched a new open marketplace for UK Magento talent. Developer Connection aims to provide an effective, low cost service for UK...
VATGlobal helps customers to vlearn on VAT
VATGlobal is aiming to simplify the VAT for business with the launch of vlearn. The product is a portal that gives access to subscribers...
Data skills shortage preventing companies delivering personalisation
More than one-in-four UK business leaders believe a lack of data skills within their organisation (27%) is impacting their ability to deliver engaging, personalised...
Mark Hurd, Oracle CEO dies
In a briefly worded and poignant statement Larry Ellison revealed that that Mark Hurd the CEO of Oracle and former CEO of HP died...
NTT Ltd sets out data centre plans
At a recent media briefing in London, Jason Goodall, CEO, NTT Ltd outlined his goals and targets for the newly formed NTT Ltd. One...
Why AI + big data = Unified Data Analytics
At the Spark+AI Summit, Europe, Enterprise Times sat with Ali Ghodsi, CEO and co-founder, Databricks to talk AI and big data. Ghodsi started as...
Paramount Software Solutions: blockchain from Farm to Plate
Paramount Software Solutions (Paramount) has launched its first blockchain technology-based provenance tracking - for 'Farm to Plate'. According to Paramount Farm to Plate is...
Banco Santander goes for double Madrid blockchain coup
Banco Santander has revealed two more initiatives using blockchain. The first is a continuation of its blockchain initiatives in wholesale finance. The second is...
ReadyReturns to provide “Prime-like” service for product returns
ReadyReturns, a provider of product returns and logistics solutions for retailers and their customers, has added a “Prime-Like” service offering. The new advanced component...
Does the boss need to evolve?
When Heroclitus wrote: “There is nothing permanent except change” he was not solely referring to the advances of technology. An affirmation of this is...
Digital Transformation needs people, technology and data
Research carried out by Alteryx and published during its EMEA Alteryx Inspire event in London, has demonstrated the importance of people, technology and data....
Tezos Foundation to partner with Globacap for capital markets automation
Tezos Foundation has entered into a strategic partnership with Globacap to accelerate bringing capital markets into the digital age. Tezos is a Swiss non-profit...
What is Delta Lake and why should you be interested?
At Spark+AI Summit Europe 2019, Databricks announced it was giving its Delta Lake technology to the Linux Foundation. It's a significant move for a...
