Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#INDEX function

Showing: 9 courses
ExcelIsFun

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

0 rewiews
Comprehensive tutorial on Excel lookup functions with 20 practical examples, covering VLOOKUP, HLOOKUP, INDEX, MATCH, and LOOKUP for data retrieval and analysis.
Add to list
23 Lesons
1 hour 19 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
12 Lesons
55 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
23 Lesons
1 hour 14 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
21 Lesons
1 hour
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.
Add to list
15 Lesons
59 minutes
On-Demand
Free-Video
ExcelIsFun

INDEX & MATCH Lookup Functions - Beginning to Advanced

0 rewiews
Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.
Add to list
18 Lesons
1 hour 10 minutes
On-Demand
Free-Video

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

0 rewiews
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.
Add to list
13 Lesons
2 hours 30 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
36 Lesons
1 hour 19 minutes
On-Demand
Free-Video
Learnit Training

Excel Power User Beginner Tutorial

0 rewiews
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.
Add to list
22 Lesons
1 hour 44 minutes
On-Demand
Free-Video