Excel Training 101
Neat stuff on Microsoft Excel, PowerPoint and maybe some random stuff
Pages
(Move to ...)
Home
Book Resources
PM Resources
Training
▼
Tuesday, June 10, 2025
Control Multiple Pivot Tables with One Slicer in Excel
›
https://youtu.be/b7hGDNyMWgw Trying to filter multiple pivot tables in Excel at the same time—without losing your sanity? You’re not the onl...
Monday, June 9, 2025
How to Delete Specific Characters in Power Query
›
https://youtu.be/W5q7D_sMoyo Learn how to clean text data in Power Query using Text.Select and Text.Remove—no coding required. In this step-...
Sunday, June 8, 2025
Excel + M365 Copilot: First Impressions You NEED to See
›
https://youtu.be/LOHjjC3Mnak Curious about how Microsoft 365 Copilot works in Excel? Here's what really happens when AI meets spreadshee...
Thursday, May 22, 2025
Stop Using INDEX MATCH! Try This Two-Way XLOOKUP Trick Instead
›
https://youtu.be/TkncclDZliM Want to do two-way lookups in Excel without getting tangled in helper columns or INDEX MATCH gymnastics? In th...
Tuesday, May 20, 2025
Use This Excel Percent Trick to Save Time (PERCENTOF Guide)
›
https://youtu.be/5lpkoOtOCdk Tired of calculating percentages in Excel like it's still 2004? In this quick tutorial, you'll master t...
Sunday, May 18, 2025
How to Use NETWORKDAYS.INTL with Custom Holidays in Excel (Even the Weir...
›
https://youtu.be/XAY6PU64KNE Struggling to get Excel’s workday calculations right? If your NETWORKDAYS formula feels like it's gaslighti...
Sunday, April 27, 2025
Excel Trick: Show Different Colors for Positive & Negative Values
›
https://youtu.be/eevGeQZHkSY Want to instantly make your Excel charts more powerful and easier to read? Most Excel charts default to one col...
‹
›
Home
View web version