Uploaded June 2025 | Updated September 2026, 2 weeks ago
A button for Centre Across Selection, Default number formatting, Tables, Slicers and Pivot Tables. Save time with this tip filled tutorial!
My number format:
#,##0_);[Red](#,##0);-??_)
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
📗 Did you know I've 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
A button for Centre Across Selection, Default number formatting, Tables, Slicers and Pivot Tables. Save time with this tip filled tutorial!
My number format:
#,##0_);[Red](#,##0);-??_)
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
📗 Did you know I've 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
