Excel for Mac Tutorials

A collection of written and video based tutorials that focus on Excel for Mac

Over recent years, the functionality gap between Excel for Windows and Excel for Mac has significantly narrowed, making the vast majority of my tutorials applicable to both platforms. In fact, about 90% of the content I create is relevant to users regardless of whether they’re on Windows or Mac.

However, there are still some differences between the two versions that can impact how certain tasks are performed or features are accessed. This section is tailored to cater to the Excel for Mac user community, offering tutorials that address these unique aspects.

Excel 2013: How to Record a Macro

Macros are used to save you time by automating tasks. The Macro Recorder is a great way to create simple macros and a great way to start to learn VBA

Customising The Ribbon in Excel (Windows)

In this tutorial I show how to edit The Ribbon in Excel for Windows – adding your own buttons, removing ones that you personally don’t find useful and rearranging the layout to make you as productive as possible.

Customising The Ribbon in Excel (Mac)

In this tutorial I show how to edit The Ribbon in Excel 2011 for Mac- adding your own buttons, removing ones that you personally don’t find useful and rearranging the layout to make you as productive as possible.

How To Add Up Without A Formula (Excel for Mac)

You’re presenting your weekly sales data in your weekly sales meeting when a colleagues asks “what was the total revenue”? You begin to panic as you’re not that confident creating formulas in Excel and you don’t want to show yourself up in the meeting. This tutorial demonstrates a simple solution

Pivot Tables in Excel 2011 (Mac)

This short video is taken from a recording of a webinar that I delivered in 2012 where I demonstrated how to create and use Pivot Tables in Excel 2011 for Mac