Dynamic Reports That Are Easier Than Pivot Tables!! + Black Friday Sale
Published: Tue, 11/21/23
If you find PivotTables a bit daunting, then this is a great alternative. Having trouble viewing this email? Read this email in your browser. Hi,…
My Online Training Hub
A mailing list to regularly send out updates and Excel Newsletters
Power BI Desktop Cheat Sheet + BLACK FRIDAY SALE
Published: Thu, 11/16/23
Create incredible interactive reports and dashboards with Power BI. Hi, Everything in Power BI Desktop Get started creating incredible interactive…
Excel Newsletter – The AGGREGATE Function, 19 Functions in 1, It's Excel's Swiss Army Knife
Published: Tue, 11/14/23
Learn to Use AGGREGATE and Master 19 Functions in One Go Having trouble viewing this email? Read this email in your browser. Hi, E cel's AGGREGATE…
7 Ways to Find & Remove Duplicates - Cheat Sheet
Published: Thu, 11/09/23
Duplicate data often leads to compromised data integrity. Learn 7 ways to prevent this. Hi, 7 Ways to Find & Remove DuplicatesCheat Sheet Duplicate…
Excel Newsletter – Calculating Essential Statistics Every Business Needs
Published: Tue, 11/07/23
E cel descriptive statistics 3 ways – the fast way, the dynamic way and the advanced way. Having trouble viewing this email? Read this email in your…
Excel Newsletter – Excel Slicer Custom Sorting Hacks - Masterclass!
Published: Tue, 10/31/23
Improve the useability of your reports with these tricks to custom sort E cel Slicer Having trouble viewing this email? Read this email in your…
Learn Python for Excel - Get Ahead of The Game
Published: Fri, 10/27/23
Hi, Python in E cel In case you missed it, Python is now available in E cel. Currently it is limited to people using Microsoft 365 Office Insider on…
Excel Newsletter – Hidden Formatting Tricks for Slicers
Published: Tue, 10/24/23
Find settings to make slicers much smaller, look like tabs & prevent users resizing them. Having trouble viewing this email? Read this email in your…
Excel Power Query Cheat Sheet
Published: Thu, 10/19/23
Automate the BORING tasks and 10 Productivity with Power Query Hi, E cel Power Query Cheat Sheet Automate the BORING tasks and 10 Productivity with…
Excel Newsletter – Teaching Thor Excel Logic!
Published: Tue, 10/17/23
99% of E cel users don’t know the basics of how E cel handles logic. Do you? Having trouble viewing this email? Read this email in your browser. Hi, E…