Course Description:

Learning Path Includes: – Excel vlookup: Basics of vlookup and hlookup explained with examples – How to use Excel Index Match (the right way) – Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria) – Excel 3 Ways to Lookup within Boundaries: sumifs, sumproducts & index – Excel indirect Function: Lookup Values in Different Sheets / Excel Tabs – Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header – Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with index & sumproduct – Excel Formula Lookup Multiple Results: Return headers based on matrix values – TextJoin Formula in Excel: Solve Complex Lookup Problems with TextJoin – Lookup values across multiple worksheets: vlookup / index match in Excel – Return Multiple Match Results in Excel (2 methods) – Vlookup explained – 2 Practical Excel Lookup Examples – Excel rank without Skipping Numbers (Top 3 Report with Duplicates) – Lookup all values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) – Discover What xlookup Can Do For you (r.i.p. Excel vlookup) – Left Lookup in Excel with xlookup (Made Easy) – How to Use the new & improved Excel xlookup (with 5 Examples) – Excel dget Function Solves 2 of Your vlookup Problems – Find Multiple Match Results in Excel (Easier Solution For all Excel versions) Course Length: 3:08:03 hours

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.