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: learn
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
Excel Lambda Now Supports Optional Arguments and ISOMITTED
Microsoft Excel Tips and Tricks You can build Lambda functions in Excel that support optional arguments. A new ISOMITTED function[…]
Read more