MS Excel Toronto - Building Interactive Dashboards in Microsoft 365 Excel - Michael Olafusi
Session recorded live on April 17
The MS Excel Toronto Meetup group was founded in May 2019 and has had monthly sessions since then. Sessions are currently offered for free online, with a different topic presented by an Excel Expert each month. Members are from all over the world, totalling more than 4,000.
ATTEND THE MS EXCEL TORONTO MEETUP GROUP SESSIONS LIVE 👇
Register for free as a member of the group: https://www.meetup.com/MSExcelToronto
ACCESS THE EXERCISE FILES shared by the presenter are available to the group members on the Meetup website 👇
Access on the browser (not the mobile app) go to the main menu and select More - Message Boards.
The MS Excel Toronto Meetup group sessions are organized and run by
Celia Alves - / celiajordaoalves
Gráinne Dugan - / grainneduggan1
-----------------------
Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscrib...
Learn how to automate your Excel reports:
https://snapreportschamp.com/course
-------------------------------------
About this session:
M365 Excel is a game changer with dynamic array functions, LAMBDA functions, constantly improved Power Query and more dashboard enabling tools than any other version of Excel. In this session, Michael picked interesting parts from his recently published book and demonstrated how easy it now is to build fully robust dashboards in Excel.
Michael Olafusi's book:
Building Interactive Dashboards in Microsoft 365 Excel: Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards
https://packt.link/iUhoH
---------------------
About the Speaker: Michael Olafusi
Michael Olafusi is the founder of MHS Analytics Inc., Canada and UrBizEdge Limited, Nigeria. He consults full-time for different clients across the globe on Power BI, Excel, Financial Modeling and data engineering projects. He enjoys traveling and cycling.
--------------
Find more about Michael Olafusi work and connect with him:
LinkedIn: www.linkedin.com/in/olafusimichael
Website: www.mhsanalytics.com
Meetup: www.meetup.com/microsoft-excel-and-data-analysis-learning-community
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:08:25 - Celia Introduces Michael Olafusi
00:13:20 - Michael Olafusi introduces himself and his presentation and his new book
00:20:40 - What is the difference between a report and a dashboard?
00:27:35 - Common uses for dashboards
00:28:45 - The importance of connecting directly to primary data sources, csv, web, cloud, SQL
00:49:40 - Image from web to data in Excel using picture from clipboard
00:51:40 - Power Query: the ultimate data transformation tool
00:53:25 – Some charts are not available when using pivot table as source – reasons and other options
01:00:00 – XLOOKUP with spelling mistakes, (cross-tabulation formula)
01:04:00 - Power Query to clean data, merging tables, common text and date transformations
01:17:30 - Dashboard data model set up & MS AdventureWorks
01:34:00 - Wrap up