INDEX function Courses and Certifications

Microsoft Excel - Excel from Beginner to Advanced

452148 ratings at Udemy

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365/2024

• Udemy
• 21 hours 10 minutes
• On-Demand
• Paid Course

Microsoft Excel - MS Excel Formulas & Functions in just 3hrs

1625 ratings at Udemy

All important Microsoft Excel formulas and functions covered within 3 hours | Must-know MS Excel formulas and functions

• Udemy
• 3 hours 52 minutes
• On-Demand
• Paid Course

Microsoft Excel Advanced Functions with INDEX and MATCH

1210 ratings at Udemy

Develop Dynamic Excel Worksheets by Mastering Excel's INDEX and MATCH functions (Excel 2007, 2010, 2013, 2016)

• Udemy
• 3 hours 39 minutes
• On-Demand
• Paid Course

Learn INDEX, MATCH, OFFSET & WHAT IF ANALYSIS in MS Excel

388 ratings at Udemy

Index, Match, Offset and What IF Analysis (Goal Seek, Data Table & Scenario Manager) with Examples

• Udemy
• 1-2 hours
• On-Demand
• Free Online Course

Advanced Excel Course for Job and Real World

315 ratings at Udemy

Master advanced Excel skills for professional use, including functions, formulas, VLOOKUP, macros, and VBA. Create dynamic tools, dashboards, and robust spreadsheets for data analysis and reporting.

• Udemy
• 4 hours 22 minutes
• On-Demand
• Paid Course

ExcelIsFun

All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

Comprehensive guide to Excel lookup formulas, covering XLOOKUP, FILTER, XMATCH, INDEX, and more. Includes examples in Excel, Power Query, and DAX for exact and approximate matches.

• YouTube
• 1 hour 19 minutes
• On-Demand
• Free Video

Drop Down Lists in Excel - Dependent, Unique Lists and Other Data Validation Lists

Master dynamic drop-down lists in Excel for efficient data validation, including dependent lists, unique item extraction, and custom validation techniques. Enhance spreadsheet functionality and user experience.

• YouTube
• 2 hours 30 minutes
• On-Demand
• Free Video

ExcelIsFun

Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

Comprehensive tutorial on Excel lookup functions with 20 practical examples, covering VLOOKUP, HLOOKUP, INDEX, MATCH, and LOOKUP for data retrieval and analysis.

• YouTube
• 1 hour 19 minutes
• On-Demand
• Free Video

ExcelIsFun

Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas

Learn advanced Excel techniques for extracting unique lists, sorting data, and creating efficient array formulas to solve complex data analysis problems and enhance spreadsheet functionality.

• YouTube
• 55 minutes
• On-Demand
• Free Video

ExcelIsFun

Ctrl - Shift - Enter- Excel Array Formulas - Formulas to Extract Records With Criteria

Master advanced Excel array formulas for efficient data extraction, including AND/OR criteria, INDEX, SMALL, and AGGREGATE functions. Optimize spreadsheet performance with practical examples and timing comparisons.

• YouTube
• 1 hour 14 minutes
• On-Demand
• Free Video

ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

Master Excel's dynamic ranges using INDEX and OFFSET functions. Learn to create flexible formulas, charts, and data validation lists that automatically adjust as data changes, enhancing efficiency and accuracy in data analysis.

• YouTube
• 1 hour
• On-Demand
• Free Video

ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.

• YouTube
• 59 minutes
• On-Demand
• Free Video

ExcelIsFun

INDEX & MATCH Lookup Functions - Beginning to Advanced

Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.

• YouTube
• 1 hour 10 minutes
• On-Demand
• Free Video

Learnit Training

Excel Power User Beginner Tutorial

Master advanced Excel functions like VLOOKUP, INDEX-MATCH, and OFFSET. Learn data mining, dynamic ranges, and conditional formatting to solve complex problems efficiently and become a true Excel power user.

• YouTube
• 1 hour 44 minutes
• On-Demand
• Free Video

Design and Create Custom Dashboards in Excel

Enhance your Excel charting skills and discover the tools and skills to create advanced and automated dashboards.

• FutureLearn
• 6 weeks, 2 hours a week
• On-Demand
• Free Online Course (Audit)