This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® Level 1 course. You will learn to create advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information, and present that information to decision makers is the foundation of a successful organisation that is able to compete at a high level.

Lesson 1: Working with Functions

• Work with Ranges
• Use Specialised Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Lesson 2: Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Lesson 3: Analysing Data

• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Lesson 4: Visualising Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

• Create a PivotTable
• Analyse PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicer