Combine First and Last Name in Excel (Using Formulas, Flash Fill, Power Query)
Microsoft Excel Tips and Tricks In this video, I will show you how to combine the first name and the[…]
Read more
Category: Excel
Excel Quick Takes Ten Excel Topics in 3 Minutes
Microsoft Excel Tips and Tricks Ten really short Excel topics jammed into one 188-second video. Credit MrExcel.com
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
Using the Powerful and Function in Excel
Microsoft Excel Tips and Tricks Learn how to use the powerful AND function in Excel to perform logical tests on[…]
Read more
How to Fix Excel Formulas that are Not Calculating or Updating
Microsoft Excel Tips and Tricks In this video, we look at the calculation options in Excel. When the setting gets[…]
Read more