My Online Training Hub

A mailing list to regularly send out updates and Excel Newsletters

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…

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…

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…

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…

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…

Finding Excel Errors [Clever Hack]

Published: Thu, 10/12/23

Hi, Find E cel Errors Hack Use the Find tool to generate a list of errors in your file. Use the built in hyperlinks to jump to the error and fi them.

Published: Tue, 10/10/23

Hi, This week we have an E cel video like you’ve never seen before. It’s fun and entertaining and along the way you’ll learn some E cel tips and…

Excel Pivot Tables Cheat Sheet

Published: Thu, 10/05/23

E cel Pivot Tables are one of the most powerful tools at our disposal Hi, E cel Pivot Tables Cheat Sheet E cel Pivot Tables are one of the most…

<< First < Previous Next >