Problems with PivotTable Running Totals and HOW TO FIX THEM
Microsoft Excel Tips and Tricks PivotTable running totals just don’t make sense sometimes. In this video I’ll show you why[…]
Read more
Author: Noel
VLOOKUP in Power Query Using List Functions
Microsoft Excel Tips and Tricks Using List functions in Power Query to do Exact Lookup and Approximate Match Lookup is[…]
Read more
Simplest Excel Data Entry Form (No VBA) #shorts
Microsoft Excel Tips and Tricks In this super #shorts video learn how to quickly create an Excel data entry form[…]
Read more
How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)
Microsoft Excel Tips and Tricks In this video you’ll learn how to calculate days between a start and an end[…]
Read more
UNIQUE of Rectangular Range Using MAKEARRAY in Excel
Microsoft Excel Tips and Tricks Another new LAMBDA helper function in Excel is MAKEARRAY. This video shows a simple example,[…]
Read more