MS Excel Toronto Meetup - Excel for Mac: The Need to Know Gotchas and Workarounds - Mike Thomas
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
_______________________________________________________
Session recorded live on March 22, 2023
So you've bought or are considering buying a Mac or maybe you've landed that dream job and found out the company is Mac-only. How can you continue to use your favorite spreadsheet application without those hair-tearing moments? This session, aimed at switchers from the Windows world, shows you the differences, gotchas, and workarounds between Excel on Windows and Excel on the Mac (including Power Query Editor!)
---------------------
About the Speaker: Mike Thomas
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
--------------
Find more about Mike's work and connect with him:
LinkedIn: / thomasmik
Website: https://theexceltrainer.co.uk
YouTube: https://theexceltrainer.co.uk/youtube
---------------------
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:05:40 - Celia Introduces Mike Thomas
00:07:15 – Mike introduces himself and his presentation
00:10:05 – What is missing from Excel for Mac
00:12:30 – Using Parallels on Mac to use Excel for Windows on a Mac
00:16:20 – Excel for Mac overview of menus, options and ribbon
00:19:40 – Dates, symbols/emojis, colours, colour picker and custom colours
00:31:30 – Pivot Tables: grouping dates, pivot table cache
00:41:25 – Unique Count in pivot tables using helper column,
00:47:20 – Using numeric filters in Pivot Tables (limitations and workaround)
00:50:40 – Charts: formatting charts, setting design elements in charts
00:54:40 – VBA on the Mac, ActiveX, form controls, userforms, file path syntax differences
01:02:30 – PDF: insert data from picture vs copy and paste (limitation and workaround)
01:08:00 – Power Query: connectors, query editor, interface
01:15:30 – Questions and Wrap up