Excel for Mac Tutorials
A collection of written and video based tutorials that focus on Excel for MacOver 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 for Mac: Jazz Up Your Spreadsheets with Emojis
Make your spreadsheets and charts more engaging with emojis
Excel for Mac: Combine Data From Multiple Files in a Folder
Power Query in Excel for Windows has Get Data from Folder. Power Query in Excel for Mac doesn’t. Here’s the workaround
Excel for Mac: Import a PDF
An update to Excel Online that now means Mac users can import PDF’s into Excel
Excel for Mac: Create Pivot Tables from Multiple Tables
In this video I’ll show you how to replicate Data Model functionality in Excel for Mac
How I Got Excel for Mac and ChatGPT to Talk
Have you ever wanted to generate AI-driven answers directly within Excel on your Mac?
Excel for Mac: Create an Olympic Medals Table
Data import and data manipulation techniques that stretch beyond building an Olympic medal table
Excel for Mac: Create Custom Lists for Sorting
When it comes to creating custom lists, Excel for Windows and Excel for Mac have the option in different places.
Excel for Mac: Combine Files from SharePoint
Excel for Mac users face challenges with direct SharePoint data integration, unlike their Windows counterparts’ seamless access
Excel for Mac: Dynamic Emojis
Insert emojis into cells and watch as they update based on changing values