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
Tag: training
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
Excel Navigation Pane Debuts
Microsoft Excel Tips and Tricks A new navigation pane debuts in Excel. It is a feature for people with low[…]
Read more
Excel Frequency of Combination of Two Columns
Microsoft Excel Tips and Tricks Salama from YouTube has two columns of numbers. The area in column A is from[…]
Read more