1

Organising data tables

• Become proficient in best practices: use structured references, identify and delete duplicates, etc.
• Check the validity of input data.
• Learn Power Query to import, transform and consolidate data.

2

Exploiting data with PivotTables

• Create PivotTables. Use grouping possibilities (dates, numbers, etc.).
• Integrate calculations: deviations, percentages, totals, calculated fields, etc.
• Filter dynamically bas on segments and chronologies.
• Present PivotTables: layout, subtotals, formatting.
• Establish a relationship, learn about the data model and Power Pivot.

3

Using calculation functions and tools

• Enhance formulas with relative, absolute and mixed references and named ranges.
• Implement functions: conditional, dates, statistics, searches, logical, text.
• Build nested formulas.
• Use audit tools and simulation commands: target value, scenario, forecasts.
• Learn about dynamic array functions.
• Discover Excel 2021's flagship functions: FILTER, XMATCH and UNIQUE.

4

Checking input and sharing workbooks

• Share a workbook on the cloud; advantages and limitations.
• Protect spreadsheets and workbooks.

5

Enhancing your visual data

• Choose the right chart type for the data to be illustrated.
• Create two-axis, combo, hierarchy and statistics charts (treemap, funnel, waterfall).
• Use pivot charts. Discover map charts.
• Integrate trend curves, sparklines and forecasts.
• Enhance charts with new Office illustrations.

6

Introduction to macros

• Define, save and secure a macro.
• Assign a macro to a button or an icon. Customise the quick access toolbar.
• View the associated VBA code.