Uploaded November 2024 | Updated September 2026, 2 weeks ago
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
00:00 Start
00:26 Intro
01:39 Simple Features
02:55 Referencing Columns
04:20 Slicers
04:46 Totals
05:48 BEST Features including Auto-Expand
06:36 Better Formulas
09:28 Pivot Source
11:00 Drop Down List Source
12:51 Power Query Source
14:00 Final tips
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
00:00 Start
00:26 Intro
01:39 Simple Features
02:55 Referencing Columns
04:20 Slicers
04:46 Totals
05:48 BEST Features including Auto-Expand
06:36 Better Formulas
09:28 Pivot Source
11:00 Drop Down List Source
12:51 Power Query Source
14:00 Final tips


;-??_)
🫶🏻 Join the channel to get access to perks:
https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
https://accessanalytic.thinkific.com/
📗 Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
00:00 Introduction
01:10 Create your Excel startup folder
01:33 Customize cell styles like Center Across
02:13 Modify number format with comma style
02:50 Create custom table and slicer styles
03:55 Save your setup as Book.xltx
04:40 Enable auto-loading with Excel startup path
05:56 Use Quick Access Toolbar for custom launch
06:27 Set default pivot table options Excel Gem: Set your default start up file](https://i.ytimg.com/vi/PlitF5GgQ2o/mqdefault.jpg)







