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

Four (Image Source Pixabay/Wobogre)

Accelo adds Retainer module

Accelo has released a fourth module for its ServOps system. This one enables organisations to manage retainers. The module is targeted specifically at professional...
summer landscape: Image credit pixabay/jpeter

Krow launches free PSA software

Krow has announced the launch of a free PSA (Professional Services Automation software). Aimed at startups and small businesses, it provides only basic functionality....

IBM Sterling Supply Chain Suite aims at US$50B market

IBM has introduced a new integrated supply chain suite, embedding Watson AI and IBM Blockchain into the IBM Sterling Supply Chain Suite. With IBM...
(image credit/Pixabay/David Mark)

Hitachi Consulting pilots healthcare digital transformation

The Northern Care Alliance NHS Group and Hitachi Consulting have announced a partnership to deliver an integrated digital transformation of care processes. Known as...
Hyundai

Hdac unveils new blockchain development plans

Blockchain company Hdac Technology (Hdac), founded by Hyundai BS&C CEO Dae Sun Chung, announced its new PoS (Proof-of-Stake) blockchain development plan at Korea Blockchain...
(Image credit/Pixabay/TheDigitalArtist)

Research shows UK divided on the security of AI virtual assistants

British consumers are deeply divided in their opinion of using virtual assistants via a smart device. A lack of trust and security fears being...
Jelurida

Jelurida contributes to ITU’s DLT standardisation efforts

Jelurida has reported about the International Telecommunication Union (ITU-T) Focus Group on Applications of Distributed Ledger Technology (FG DLT). Beginning in January 2019, a...
(Image credit/Pixabay/Geralt)

NexTech creates new 3D Ads with Google

NexTech AR Solutions has built ad creatives that have passed Google's 3D validation tool. The company is now working with Google to launch a...
funding (Source Freeimages.com/Tracy Olson

Contentstack stacks up some cash

Contentstack has announced a Series A funding round of $31.5 million led by Insight Partners. Existing backers Illuminate Ventures and GingerBread Capital also participated....
(Image credit/Pixabay/Geralt)

BigCommerce partners with DEITY to support mobile commerce

BigCommerce has announced that its new partner and microservice-oriented architecture platform DEITY has launched DEITY Falcon for BigCommerce. DEITY Falcon for BigCommerce is a Progressive...

KPMG study finds digital tokens are transforming consumer interactions

A tokenisation, loyalty and blockchain survey by KPMG has revealed that consumers - across all age groups - are increasingly willing to make...
fall autumn Image by Valentin Sabau from Pixabay

Krow Software announces PSA Fall 19

Krow Software has announced Fall 19, the latest release of its PSA solution on the Salesforce platform. The update includes a new integration to...
(Image credit/Pixabay/RawPixel)

Petra Industries launches B2B eCommerce platform

Petra Industries, a consumer technology distributor, has launched an innovative new B2B eCommerce platform. The announcement is part of the largest website overhaul in...
quantum computer

Praxxis CEO: blockchain needs quantum-resistant technology

Praxxis CEO and founder, David Chaum has challenged the blockchain industry to focus on quantum-resistant blockchains and digital currencies. Chaum, who created the International...