INDEX Function – Excel’s Best Function Welcome to the Boss Level
Outline: The INDEX function in Excel is the ultimate in its balance of power and flexibility. It does not get the celebrity worship of functions such as VLOOKUP and XLOOKUP but it is superior. In this presentation, we will start with a quick introduction to the INDEX function and see it in its most common form of being used with the MATCH function for a lookup formula. We will the proceed through many examples to witness the quiet genius of INDEX. The examples will include creating dynamic ranges, rolling charts, moving averages, sorting and ranking values and in combination with …
Curriculum
Overview
Outline:
The INDEX function in Excel is the ultimate in its balance of power and flexibility. It does not get the celebrity worship of functions such as VLOOKUP and XLOOKUP but it is superior.
In this presentation, we will start with a quick introduction to the INDEX function and see it in its most common form of being used with the MATCH function for a lookup formula. We will the proceed through many examples to witness the quiet genius of INDEX. The examples will include creating dynamic ranges, rolling charts, moving averages, sorting and ranking values and in combination with the new XMATCH function.
In modern Excel, with the dynamic array engine powering Excel, INDEX is now greater than ever. There will be examples of how it works with these arrays being used with function such as FILTER and XLOOKUP.
You do not want to miss this one.
Training Instructor:
Alan Murray
You May Like
Corporate Tax Return
Date: December 06, 2024 Time: 9.00 PM Contents of the training: Corporate Tax Rate at a glance Minimum Tax on business income Income...
Logical Reasoning & Strategic Thinking
Training Schedule: Date: November 22, 2024. Time: 7:00 PM Module Overview: The Strategic Problem Solving through Logical Reasoning module equips participants with techniques...
Contract Management
Course Outline: Explore the documentation involved in commercial agreements Definition Role of Procurement professional in contract management Documents involved in commercial agreements Types...
Course Features
- Lecture 0
- Quiz 0
- Duration 2 Hours
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes