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

Melbourne Image credit pixabay doctor-a

Kimble targets Australia with new team

Kimble Applications has announced the opening of a new office in Australia and the appointment of Steve Litsos as General Manager for the region....
Mihoko Matsubara talks about Cyber Security strategy at NTT 

Mihoko Matsubara talks about Cyber Security strategy at NTT

A cyber security strategy has to encompass the entire company. For many businesses, it is a fragmented set of policies, procedures and approaches that...
(Image credit/Pixabay/ASSY)

Givex launches POS system in partnership with Brazil’s Ofner

Givex, a solution provider for gift card, voucher and loyalty services and Ofner, a traditional coffee chain in Brazil, announced a partnership in the...
Pega World 19 PW19 (c) 2019 S Brooks

Why is empathic explainable AI so important ?

Peter van der Putten is the Director of Decisioning Systems at Pega Systems. Enterprise Times spoke to him during the PegaWorld conference where the...
(Image credit/LinkedIn/Geralt)

Deutsche Telekom and Software AG to create global Internet of Things platform

Deutsche Telekom and Software AG have announced a partnership to deliver Internet of Things (IoT) services on a global scale. Deutsche Telekom’s enterprise customer...
Matthew Gyde takes over at NTT Security

Matthew Gyde takes over at NTT Security

NTT Security has announced Matthew Gyde is its new Representative Director, President and Chief Executive Officer (CEO). Gyde's previous job was as Group Executive...
Facebook gets derisory $5 billion fine

Facebook gets derisory $5 billion fine

The US Federal Trade Commission (FTC) has voted to fine Facebook US$5 billion. News of the fine came from the Wall Street Journal who...
BlackBerry goes threat hunting with CylanceGUARD

BlackBerry goes threat hunting with CylanceGUARD

BlackBerry has announced CylanceGUARD, the second new product from the security company it acquired earlier this year. CylanceGUARD is a Managed Detection and Response...
(Image credit/Pixabay/AbsolutVision)

New LastPass study finds 92% of businesses experience identity challenges

LastPass by LogMeIn today announced the results of a new study conducted by Vanson Bourne into the state of identity and access management (IAM). The report...
Amazon Alexa to dispense NHS advice

Amazon Alexa to dispense NHS advice

NHS England has signed a deal with Amazon to provide health information via its Alexa voice assistant. The deal is aimed at two groups....
(Image credit/Pixabay/StockSnap)

Worldpay partners with University of Cincinnati to help close skills gap

Worldpay Inc and the University of Cincinnati (UC) are on a mission to help fill a widespread skills gap, while creating career opportunities for...
Banks vulnerable to cyber attack

Banks vulnerable to cyber attack

Are the world's top 100 banks secure from cyber criminals and hackers? Based on the recent ImmuniWeb's State of Application Security at World's 100...
(Image credit/Pixabay)

Poor shipping experience turns off online shoppers says report

BigCommerce, has released a new report, Shipping, Delivered: Best Practices & Expectations for 2019. The study examined survey responses of 3,000 digital consumers and...
Marriott next in the ICO firing line

Marriott next in the ICO firing line

Having announced its intention to fine British Airways £183.39 million, the UK Information Commissioners Office has now turned its sights on Marriott International. It...