✨New AI Excel Web Scraping
Published: Tue, 11/28/23
E cel's Power Query Web Connector now uses AI to find the data you want on a web page. Having trouble viewing this email? Read this email in your…
My Online Training Hub
A mailing list to regularly send out updates and Excel Newsletters
Emojis in Sheet Tabs + BLACK FRIDAY SALE
Published: Thu, 11/23/23
Emojis in sheet tab names can add clarity, and categorize and prioritize your work. 20% Off All Courses in Our Black Friday Sale.Scroll Down for More…
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,…
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…