This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® Level 1 course and will help start

you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers, is at 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

Please note that this link is unique to you. Transferring this link to another user is an infringement of copyright. If you have subscribed to a course, the cost is per delegate, not per screen.