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

Pyramid Image by PixxlTeufel from Pixabay

Can Pyramid Analytics soar with new funding?

Pyramid Analytics has announced a $25 million growth equity funding round led by Jerusalem Venture Partners (JVP). The funding comes five years after its...
Cartesi

Cartesi launches Layer-2 Linux infrastructure for developing blockchain DApps

Cartesi has provided what it says is the first ever dApp infrastructure which runs an operating system (OS) on top of blockchains. It launched...
WSO2 add passwordless authentication (Image Credit: Gerd Altmann from Pixabay)

WSO2 adds passwordless authentication

WSO2 has added Passwordless Authentication with FIDO2 in the latest version of its WSO2 Identity Server 5.10.0. What this means is that WSO2 is...
Asana Do not disturb (c0 2020 Asana

Asana launches Do not Disturb for home workers

Asana has announced the a new Do Not Disturb feature for its work management tool. The feature is targeted at workers who are now...
(Image credit/Pixabay/Gerd Altmann)

James Hambro & Partners selects InvestCloud for digital transformation

Independent wealth management group James Hambro & Partners (JH&P) has selected global FinTech firm InvestCloud to support its digital transformation. The company expects the...
BloqCloud

Open Application Network partners with Bloq for blockchain infrastructure

Bloq has announced it will provide infrastructure continuity for the Open Application Network (OAN). It is picking up from where one of OAN's existing...
Ginp banking malware tricks users with Coronavirus Finder (Image Credit: Tumisu from Pixabay)

Ginp banking malware tricks users with Coronavirus Finder

The Ginp banking trojan has new functionality according to security company Kaspersky. It is taking advantage of people's concerns over COVID-19 with a "Coronavirus...
workflow, Image credit Pixabay/Geralt

Accelo improves visibility of task progress

Accelo continues to develop its product and has released several updates to support users. Most of the new feature improvements and bug fixes are not...
SAP Ariba

SAP Ariba extends supply chain capabilities

There were two key announcements during the virtual SAP Ariba Live ‘event’ last week. Goldman Sachs is to offer global payments on the Ariba...
COVID-19 Image by Gerd Altmann from Pixabay

Professional Services still buoyant on 2020 revenues

BigTime Software has published the results of a survey into the impact of COVID-19 on North American professional services business. The results were drawn...
SAP Ariba

SAP Ariba Live goes virtual and Discovery becomes free

SAP Ariba Live, scheduled for Las Vegas in mid-March, went virtual as COVID-19 continued its depredations of the global event and travel industry. Rather...
RPA and AI need the human touch (Image Credit: Gerd Altmann from Pixabay )

RPA and AI are most effective when a human is involved

Just before Covid-19 caused the mass cancellation of conferences, Enterprise Times visited Appian to meet with Matt Calkins, CEO and other senior members of...

VirusBlockchain – for community and workplace monitoring

The Public Health Blockchain Consortium (PHBConsortium.org) has announced the release of a monitoring blockchain (VirusBlockChain) for the systematic, continued and anonymous verification of communities...
NutriBullet blames RiskIQ for delayed breach response (Image Credit: Petra D. from Pixabay )

NutriBullet blames RiskIQ for delayed breach response

NutriBullet was hit by a malware attack in February that continued for over a month. Two days ago, RiskIQ published a blog showing that...