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

Avast accused of selling user data (Image Credit: Pete Linforth from Pixabay )

Avast subsidiary harvested browsing data for sale

Antivirus vendor Avast has been accused of selling users personal data. The claim comes from an investigation carried out by news website VICE. The...
UAE

UAE could save US$3B with blockchain implementation

The UAE (United Arab Emirates) could save over US$3B (AEDirham 11B) by implementing advanced blockchain technologies. This is the claim of a joint white...
Jolocom

Jolocom and Bundesdruckerei e-government PoC

To demonstrate the potential for decentralising digital identity solutions in the context of IT infrastructure, researchers at Bundesdruckerei have tested a blockchain-based self-sovereign identity...
Image credit/Pixabay/Patricia Alexandre

Retailers look to hybrid cloud as they search for flexibility

Nutanix, an enterprise cloud provider, has announced the retail industry findings of its second Enterprise Cloud Index Report. The report measures retailers’ plans for...
Dreamforce 2019

Going beyond CRM, talking technology, methodology and strategy

Enterprise sat down with Patrick Morrisey GM Revenue Optimization Business Unit and Nigel Cullington, VP Product Marketing at Upland Altify at Dreamforce. Cullington reveals...
Phoenix Rises Image by Leandro De Carvalho from Pixabay

Changepoint rises with bright future

Changepoint announced new branding last year and it has now revealed what it has been working on for the last eighteen months. In a...
FutureMakers Atlanta, Image credit Twitter @Corabeghin

Sage Foundation engages student on AI

Sage Foundation has launched its FutureMakers initiative in the US for the first time. It partnered with 3DE, a non-profit created by Junior Achievement...

EEA partners with Whiteblock to offer collaborative blockchain

The EEA (Enterprise Ethereum Alliance) is partnering with Whiteblock to provide a testing environment for the EEA global membership base (of which Whiteblock is...
IBM - Consumer

IBM report: ‘shoppers will pay premium prices for sustainable, traceable brands’

IBM has released a study on global consumer trends which 'reveals' that the importance of brand purpose surpasses cost and convenience for today's shoppers....
Business Woman Image by Tumisu from Pixabay

The unsolved problem of poor utilisation

KeyedIn has highlighted recent research showing how poor utilisation rates are. The research, carried out by the Resource Management Institute (RMI), was co-sponsored by...
Kadena Hybrid Blockchain

Kadena launches its hybrid blockchain

Kadena has launched its public blockchain which includes full transactions and the ability to write smart contracts. The latest functionality of the network completes...
WAV files carry malware (Image Credit: Steve Harvey on Unsplash)

WAV files risk to Windows 7 and beyond

WAV files have been blamed for infecting Windows 7 machines with cryptomining malware at a medical tech (MedTech) vendor. It infected over 50% of...
Ternio

Ternio slashes minimum balance requirement on BlockCard

Ternio, the creator of BlockCard, has reduced the minimum balance requirement for all its BlockCard holders - by 90% (from US$100 to US$10). Ternio...
Food Trust - olives

Food Trust for quality and origin of Terra Delyssa Extra Virgin Olive Oil

CHO, a Tunisian olive oil producer, will use IBM's Food Trust blockchain to create a provenance record that traces, via eight quality assurance checkpoints,...