holiday - image credit: pixabay.com / Ana J

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...
holiday - image credit: pixabay/Stephanie Laubscher

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....
Space : image credit - unsplash.com/NASA

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...
Finding Nemo: Image Credit - pexels.com / Tom Fisk

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 ; Image credit -Unsplash.com/bryson-hammer

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...
Columns - image credit / unsplash.com/Héctor J.Rivas

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...
size matters : image credit - Pixabay.com/NjoyHarmony

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...
Chameleon : image credit - unsplash.com/erwan_hesry

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...
Big_Ben: Image credit - unsplash.com/michael Jin

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,...
Dates : Image Credit Unsplash.com

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

Computer History Museum

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...
(Image credit/Pixabay/RawPixel)

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...
Vat Image by mohamed Hassan from Pixabay

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...
(Image credit/Pixabay/RawPixel)

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 with Evan Goldberg at Suiteworld 19 (c) Oracle

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 datacentre plans 

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 needs big data and vice versa

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...
Farm to Plate

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 bike

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...
(Image credit/Pixabay/EllJay)

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...
Barometer - Image by Aga Maszota from Pixabay

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...
Dean Stocker, CEO and Chairman on stage at Alteryx Inspire (c) 2019 S Brooks

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....
Globacap

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?

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...