Excel Index Match Made Simple – Lookup like a Pro
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup[…]
Read more
Tag: Excel
📊 How to Build Excel Interactive Dashboards
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to create dynamic and interactive Excel dashboards. With a[…]
Read more
🔎 How to Create Searchable Drop Down List in Excel
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to build a searchable drop down list in Microsoft[…]
Read more
How to Ignore Formula / Not Calculate If Cell is Blank in Excel
Microsoft Excel Tips and Tricks In this video I demonstrate how to ignore a formula or stop calculating if a[…]
Read more
Add or Substract DAYS or WORKING DAYS or MONTHS or YEARS to or from a Date
Microsoft Excel Tips and Tricks Add or Substract DAYS or WORKING DAYS or MONTHS or YEARS to or from a[…]
Read more