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

Keeper Security launches BreachWatch

Keeper searches Dark Web for password breaches

Keeper Security has released BreachWatch, a utility which searches the Dark Web for login credentials exposed through a public breach. BreachWatch is available as...
(Image credit/Pixabay/Geralt)

Salesforce makes email marketing smarter with new Einstein AI innovations

Salesforce has announced new Einstein AI innovations for Marketing Cloud. The enhancements will enable brands to increase customer engagement with relevant and timely email...
wallet expenses image credit pixabay/Goumbik

Accelo expenses module is generally available

Accelo has completed the work on its expenses module but has yet to launch the new release. Accelo believes that its module should stop...
Olive oil

Blocksyte + Caroli introduce blockchain traceability for olive oil

Blocksyte, a blockchain supply chain application company focused on the food industry supply chain, and Caroli, a producer of high-quality, extra virgin olive oil...
SafeBreach warns of critical vulnerability in PC-Doctor

SafeBreach warns of critical vulnerability in PC-Doctor

SafeBreach has released details of a vulnerability in PC-Doctor, a support tool used by several PC vendors including Dell. The software allows end users...
How SNIA is using Open Source to speed up storage standards

How SNIA is using Open Source to speed up storage standards

Developing a storage standard has always been a long, arduous and contentious process. It is the same for most standards. However, with the speed that...
Calibra Logo

What to make of Facebook’s Libra?

On June 18th Facebook 'announced Calibra and Libra (though they will not be available until 2020). This is either a momentous event or an...
Service Desk, image credit pixabay/Alexas_Photos

New but familiar player in Service Desk Software – SolarWinds

Following a slew of acquisitions, SolarWinds has launched a Service Desk solution. Solarwinds is a brand familiar to IT leaders with a wide range...
Hyperledger logo

Microsoft, SalesForce and the Ethereum Foundation join Hyperledger

Hyperledger, an open source collaborative effort created to advance blockchain, has announced a diverse line-up of eight new members, including the Ethereum Foundation, Microsoft,...
Jobs in the digital age

Reports highlight future of Jobs in the digital age

Zigurat Innovation & Technology Business School and consultancy Setesca, have published a report "Future of Jobs in the Digital Era." The report highlights the...
(Image credit/Pixabay/Skeeze)

Kaminario launches new Storage as a Service Offerings

Kaminario, a cloud storage software company, announced three new offerings and a unified licensing framework. The announcement is aligned to the company’s vision of...
xRapid

Ripple partners with MoneyGram

Ripple, a provider of blockchain for global payments, entered into what it calls "a strategic partnership with MoneyGram". The latter is one of the...
TCS+SAP Leonardo Logos

TCS teams with SAP to transform surgical kit ecosystem

Tata Consultancy Services (TCS) is partnering with SAP to launch an Intelligent Field Inventory Management (iFIM) solution. Powered by SAP Leonardo, this leverages IoT...
Drugs

FDA program to evaluate blockchain to protect pharmaceutical integrity

The US Food and Drug Administration (FDA) has selected IBM, KPMG, Merck and Walmart for inclusion in a program which will support the U.S....