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
Tag: learning
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
Auto Refresh PivotTables & Queries – without VBA!
Microsoft Excel Tips and Tricks Auto Refresh PivotTables isn’t on by default, and the process differs depending on whether your[…]
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