Microsoft Excel

Advanced

Download PDF
Back to Courses

Course Details

Course Name

Microsoft Excel Advanced

Course Code

AFBMEA

Assumed Knowledge

Microsoft Excel Intermediate

Course Aims

This course will teach participants how to use Microsoft Excel’s advanced features and functions to perform complex data analysis, visualisation, modelling, and transformation. The course consists of six modules that cover topics such as advanced functions, chart types, interactive controls, chart templates, pivot tables, data tables, forecast, solver, text to columns, flash fill, and power query.

What You Will Learn

This course will teach you how to use advanced Excel features to analyse and visualise data in various ways. You will learn how to use functions, charts, pivot tables, data modelling, and data cleaning tools to manipulate, extract, summarise, and transform data for different purposes.

Skills

  • How to use advanced functions such as INDEX, MATCH, OFFSET, INDIRECT, and AGGREGATE to perform complex data analysis and lookup tasks
  • How to create and customise advanced chart types, interactive controls, and chart templates to visualise data in various ways and enhance reports and dashboards
  • How to use data tables, forecast, and solver add-in to perform what-if analysis, scenario analysis, and optimisation problems
  • How to use text to columns, flash fill, and power query to clean, transform, and import data from different sources and formats

Who This Is For

The target audience for a Microsoft Excel Advanced training course would be people who have completed the intermediate level or have equivalent skills, and want to master the most sophisticated and powerful features and functions of Excel, automate their tasks with macros and VBA, perform complex data analysis and visualisation, or integrate Excel with other applications and web services.

Course Content

Review of Excel Intermediate

  • Review of Excel Intermediate

Advanced Data Analysis with Functions

  • Topic A

    INDEX & MATCH Functions

  • Topic B

    OFFSET & INDIRECT Functions

  • Topic C

    AGGREGATE Function

Advanced Data Visualisation

  • Topic A

    Advanced Chart Types

  • Topic B

    Interactive Controls

  • Topic C

    Chart Templates

Advanced Pivot Table Techniques

  • Topic A

    Calculated Fields & Items

  • Topic B

    Power Pivot

  • Topic C

    DAX Formulas

Advanced Data Modelling

  • Topic A

    Data Tables

  • Topic B

    Forecast

  • Topic C

    Solver Add-In

Advanced Data Cleaning & Transformation

  • Topic A

    Text to Columns

  • Topic B

    Flash Fill

  • Topic C

    Power Query

Advanced Macros & VBA

  • Topic A

    VBA

  • Topic B

    Custom Macros

  • Topic C

    User Forms

Advanced Data Visualisation with Power Map

  • Topic A

    Power Map

  • Topic B

    3D Maps

Advanced Data Analysis with Power BI

  • Topic A

    What is Power BI?

  • Topic B

    Connecting to Data

  • Topic C

    Power BI Dashboards

Collaborating & Sharing Workbooks

  • Topic A

    Workbook Protection

  • Topic B

    Sharing Workbooks

  • Topic C

    Excel Online

  • Topic D

    @ Tasks in Excel

Course Progression

At Appetite for Business, we understand the significance of Microsoft Office in a modern workplace and the benefits of understanding the full range of tools and features it has to offer outside of the basics. That’s why we are excited to introduce our Microsoft Excel training courses, designed to empower employees with the essential knowledge and skills needed to produce amazing reports, data sets and more. We believe in continuous growth and learning, which is why we’re committed to offering ongoing training opportunities.

After this course, you will understand the power of Microsoft Excel and can embark with us on a journey of continuous development, ensuring that you stay at the forefront of workplace innovation. Join us to unlock the full potential of Microsoft Excel and advance your career in the digital era by taking one of the following courses.

Excel Introduction

0.5 Day

Excel Essentials

1 Day

Excel Intermediate

1 Day

Excel Advanced

1 Day

Excel Masterclass

3 Days

Formulas & Functions

1 Day

Why Companies Love Working with Appetite for Business

Join 100 + companies using our services to meet their growth needs.