Excel: Display Percent Complete in Task Tracker

This video is based on a request for help that I received from Tim, one of my channel subscribers. He said…”I have a table of tasks which fall under different headings and the final column is complete/not complete. I want to create a dashboard using Pivot...

Excel: Convert Text Dates to Real Dates

Dates in Excel are the bane of my life and probably the bane of your life too, especially when you try, and fail, to sort those dates into order or you want to do a calculation on those dates such as work out everyone’s age and the formula generates an error. More...

Excel and Word: Mail Merge with Images

A client recently asked me for help with creating what they called an Employee Directory. It was basically a Word document that included, for each employee, their name, their email address, in a clickable format and and their photo. If they only had a few employees...

Excel for Mac: Combine Files from SharePoint

In today’s data-driven environment, combining data from various file formats such as XLSX and CSV is a common task for Excel users. In a corporate environment, the data you need to combine is often stored in Cloud platforms like SharePoint or Microsoft Teams, rather...

What is #DIV/0! Error and How Do I Fix It?

“Who has come across #DIV/0! in their spreadsheets?” is a question that I often ask the attendees when I deliver formulas and functions in Excel training. There are usually a few Yes’s entered into the online chat along with a few raised virtual hands....

Stacked Column Charts Explained

What is a Stacked Column chart and when would you use one? Read on… Last week I came across [an article](https://www.bbc.co.uk/sport/football/68713522) on the BBC sports website about soccer finances. It was called “Premier League clubs’ £1bn of losses in...