Why INDEX & MATCH Beat VLOOKUP in Excel
This MS Excel tutorial introduces the INDEX and MATCH functions, demonstrating their use with employee data including names, age, gender,…
Excel Functions
Read More
Creating a Dynamic Search Engine in MS Excel without Coding or Addins
In this MS Excel tutorial, the instructor introduces the newly added group by function to create a live search engine…
MS Excel: Mastering MS Excel – Chapter 01 – Home Tab
Welcome to the Mastering MS Excel course! In Chapter 1, we’ll be tackling eighty-seven tasks to help you master the…
Using Formulas like a Boss, By Using Actual Names instead of Cell References
Are you tired of using meaningless cell references in your formulas? Do you want to use proper names in your…
Simplifying Complex Nested Conditional Formulas using Easy and Understandable Method
In this tutorial, we’ll show you how to write a large, complex, nested conditional formula in Microsoft Excel, but in…