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

(image credit/Pixabay/Gerd Altmann)

Business failing to implement digital transformation projects says Mulesoft report

MuleSoft has announced the findings of the 2020 Connectivity Benchmark Report on the state of IT and digital transformation. The survey revealed 59% of...
(Image credit/Pixabay/ElasticComputeFarm)

Co-op UK and Digital Goodie expand partnership with deployment of headless commerce

Digital Goodie has expanded its partnership for the launch of Co-op's dedicated online grocery shop and home delivery service. Digital Goodie is the creator...
Pega sees IT and business uit infighting harming the CX (Image Credit: Pega sees IT and business uit infighting harming the CX)

Pega says IT vs Business is hurting the customer experience

Pega Research has released its latest report titled: The four false narratives of customer experience (registration required). It highlights how the internal battle between...
Telos Foundation

The Telos Foundation makes two moves – the BRI and Unbiased

The Telos Foundation is joining the Blockchain Research Institute (BRI) in an effort to further its mission to broaden blockchain adoption. Almost simultaneously it...
Hedera

Hedera Consensus Service (HCS) launched by Hedera Hashgraph

The Hedera Consensus Service (HCS) is open to developers on the Hedera mainnet. HCS has been in development at Hedera since mid-2019. it seeks...
(Image credit/Pixabay/mohamed Hassan)

5G IoT revenue to reach $8 Billion by 2025

A new study from Juniper Research found total operator-billed revenue from 5G IoT connections will reach $8 billion by 2024. This rises from $525...
Keeper gives LogRhythm access to password logs (Image Credit: Gerd Altmann from Pixabay )

LogRhythm signs up Keeper for password logs

LogRhythm has signed Keeper Security as a Technology Alliance Partner. The partnership means that LogRhythm will add Keeper's password event data into its SIEM...
Obviously AI (c) 2020

Predictions which are Obviously AI

Artificial Intelligence is often the domain of data scientists and organisations are finding it difficult to locate them. Now there seems to be an...
Unsigned firmware leaves users at risk (Image Credit: Sergio Stockfleth from Pixabay)

Unsigned firmware a bonanza for hackers

Enterprise security company Eclypsium is warning of the dangers from unsigned firmware inside devices from desktops to laptops. The details are contained in a...
Israeli soldiers fall for Hamas dating scam(Image Credit: Kat Nelson on Unsplash)

Hamas Android malware targets Israeli military

Israeli soldiers using Android devices have fallen victim to a malware attack by terror group Hamas. The Israeli army claims that it had now...
Facebook stuns Vienna court (Image Credit: C. Cossa)

Facebook makes outrageous statements in Vienna court

Last week Facebook, or to be more precise Cecilia Alvarez, EMEA Privacy Policy Director at Facebook, was answering questions under oath in the Vienna...
Handcash

HandCash introduces HandCash Connect – a Bitcoin development kit

Spanish BitCoin wallet provider, HandCash, has packaged the basic components it believes every BitCoin application developer needs - in just one toolkit. HandCash Connect's...
Cheshire Cat Image by tookapic from Pixabay

Can Qlik bring smile to Cheshire healthcare teams

In April 2020 four NHS Clinical Commissioning Groups will merge. As the units come together the work to leverage their combined data has already...
NTT joins Charter of Trust (Image Credit: Anemone123 from Pixabay )

NTT joins the Charter of Trust

NTT announced at the Munich Security Conference that it has joined the Charter of Trust (CoT). Created in 2018 by Siemens, the CoT is...