6 Going further


In this module, you will discover elements allowing you to deepen your knowledge of Excel: frequently used advanced formulas (nested SUMIF, IF, MATCH or INDEX), the most used keyboard shortcuts but also tips to make your work on Excel much easier!
This module consists of 4 sub-parts:
- 6.1 Several advanced formulas,
- 6.2 Time-saving shortcuts,
- 6.3 A few useful tips,
- 6.4 Related PivotTables.
This section often refers to the Data analysis toolbox which provides an understanding of the basic principles and tricks of data analysis.