In this lesson, you will learn the core ideas behind Advanced formulas. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind XLOOKUP and INDEX-MATCH. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind Pivot tables. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind Conditional formatting. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind Data validation. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind Charts. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind What-if analysis. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.
In this lesson, you will learn the core ideas behind Excel automation. Start with the concepts, follow the examples, and then practise what you have learned with small exercises.
Understand the concept, recognize when to use it, and apply it in a practical example.