Excel for Mac: Dynamic Emojis

Building Excel based dashboards is a hot topic right now and despite the fact that the Mac version of Excel has fewer features than it’s Windows counterpart, you can still build some pretty awesome dashboards with it. One feature of Excel for Mac that can be...

Excel: Import Content from XML

Do you know what an XML file is? Do you care what an XML file is? Do you know why you might want to export the contents of an XML file to Excel? All is explained in this week’s YouTube video As a podcast host I recently needed to extract some information from...

MoreQuery – a Free Addin for Excel for Mac

Are you an Excel for Mac Power Query user? Are you frustrated with missing Get Data functionality (compared to Excel for Windows)? If so, check out this add-in! Microsoft have done a great job with adding Power Query to Excel on the Mac. However, compared to Power...

Excel for Mac – Import from Web

A common requirement for many Excel users is to be able to import data into Excel from a web page and keep that data up to date if the source data changes. Financial data, sports data, country-related data. Those are just a few examples of the sort of data that you...

Excel for Mac: Colour Matching

One of the things I love about being an Excel user on the Mac is that I have access to the macOS built in colour picker. Using it, I can copy a colour from anywhere on the screen – an image, a shape, even the Excel or macOS interface, and apply it to a cell...

Create a Cylinder Chart in Excel for Mac

Bored of bar charts? Tired of column charts? Try a cylinder chart instead! A cylinder chart is a variation of the popular bar and column chart. Instead of displaying data as rectangular shaped columns, it displays it as cylindrical shaped columns or bars. Watch on...