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...

Excel: VSTACK: Exclude Blank Rows

Excel’s VSTACK function is used to quickly combine multiple lists into a single list. The source lists can all be on the same worksheet or they can come from separate sheets. They can be Tables or they can be simple ranges. The screenshot above is taken from an Excel...

Excel: Share & Backup Macros

A client recently sent me an Excel file and asked me to add some macros and a VBA-based data entry form to it. On the surface that was a simple every-day request. However, the file was a live, working file. It lived in SharePoint and several users opened it each day...