-
The Magic of Power Query & Hidden Pivot Table Trick. Don't Miss it
-
Set an Expiration Date to your Excel File
-
Create a List of Sheet Names using Power Query... With 2 ways Navigation
-
Create a Personal Budget - With lots of Excel Tips and Tricks
-
Unstacking Records with 4 Stunning Methods: Power Query vs. Dynamic Arrays vs. Functions vs. VBA
-
Your “One Stop Shop!” for Date Functions in Excel (+Bonus & Free Gift)
-
Create a Searchable Drop Down List in Excel
-
Pivot Table with Progress Chart and Dashboard
-
Exchange Rates are now LIVE ... Currency Converter with Power Query, Stocks Data Type & Macro
-
OFFSET function to change Source Data for a Dynamic Chart
-
Calculate The Quarter of the year from Any Date - 5 Different Methods (Don't miss it)
-
Top 3 Filter Hacks in Excel - Very useful
-
Sumproduct Text and Numbers
-
Fixing US Dates Problem - Three Methods
-
Insert Picture Comments in Bulk with One Click
-
Comparison Dashboard - Super Easy and Very Useful
-
Boost Your Excel Productivity - Cool Tips and Shortcuts
-
A VLOOKUP Secret Revealed - See How to Impress Your audience
-
Flip Your List In Excel- Buy One Get Eight Free
-
VLookup Fired...XLookup Hired - The New Giant Is Here
-
A Stunning Chart Title Drop List...Impress Your Clients... Don't Miss it
-
Add Dynamic Leading Zero in Excel… 12 Ways from Basic to Power User
For the full list of tutorials...