Microsoft Excel

Masterclass

Download PDF
Back to Courses

Course Details

Course Name

Microsoft Excel Masterclass

Duration

4 Days

Course Code

AFBMEEM

Assumed Knowledge

None

Course Aims

The aim of this course is to provide you with the skills and knowledge to use Microsoft Excel as a powerful tool for data entry, analysis, visualisation, modelling, and transformation. You will learn how to use various features and functions of Excel to manipulate, transform, and visualise data in different ways. You will also learn how to work with external data sources, automate tasks, troubleshoot errors, and integrate Excel with other applications and web services. By the end of this course, you will be able to use Excel for various purposes, such as data entry, data analysis, reporting, decision making, and data science.

What You Will Learn

This comprehensive course covers Excel’s essential and advanced features to enhance your data management and analysis skills. You’ll master custom formats, data validation, nested and logical functions, advanced sorting, and more. Learn to create dynamic charts and pivot tables for data visualization, and use external data, Goal Seek, Solver, and Analysis Toolpak for in-depth analysis. Discover how to clean and import data using text to columns, flash fill, and power query. Automate tasks with macros, office scripts, and VBA, and develop interactive data models and dashboards with power pivot, DAX formulas, power map, and power BI.

Skills

  • Proficiency in data management and analysis, utilizing Excel’s formulas, functions, pivot tables, and charts for efficient data entry, reporting, and decision-making.
  • Advanced data visualization and manipulation techniques, including dynamic charts, pivot tables, and the use of external data sources with tools like Goal Seek and Solver.
  • Skills in automation and integration.

Who This Is For

This course is designed for a diverse audience, including professionals across various industries seeking to elevate their data management and analytical capabilities, individuals desiring a thorough mastery of Excel for complex data tasks, and Excel users interested in automating processes and crafting interactive data presentations.

Course Content

Getting Started with Excel

  • Topic A

    Introduction to Excel

  • Topic B

    The Excel Interface

  • Topic C

    Navigating Worksheets

Basic Data Entry & Formatting

  • Topic A

    Entering & Managing Data

  • Topic B

    Formatting Cells

  • Topic C

    Number Formats

Basic Formulas & Functions

  • Topic A

    Using Formula

  • Topic B

    Using Functions

  • Topic C

    Keyboard Shortcuts

Working with Worksheets & Workbooks

  • Topic A

    Managing Worksheets

  • Topic B

    Managing Workbooks

  • Topic C

    Viewing Options

Basic Data Analysis

  • Topic A

    Sorting Data

  • Topic B

    Filtering Data

  • Topic C

    Subtotaling Data

Charts & Graphs

  • Topic A

    Creating Charts

  • Topic B

    Customising Charts

  • Topic C

    Formatting & Styling Charts

Printing & Page Setup

  • Topic A

    Print Options

  • Topic B

    Page Setup

  • Topic C

    Print Preview

Basic Data Analysis Tools

  • Topic A

    Conditional Formatting

  • Topic B

    Data Validation

  • Topic C

    Removing Duplicates

  • Topic D

    Basic Data Transformation

Introduction to Tables & Filtering

  • Topic A

    Creating Tables

  • Topic B

    Table Features

  • Topic C

    Table Collaboration

Introduction to Pivot Tables

  • Topic A

    What are Pivot Tables?

  • Topic B

    Creating Pivot Tables

  • Topic C

    Customising Pivot Tables

Advanced Data Entry & Formatting

  • Topic A

    Creating Pivot Charts

  • Topic B

    Filtering Pivot Charts

  • Topic C

    Formatting Pivot Charts

Advanced Functions

  • Topic A

    The IF Function

  • Topic B

    The VLOOKUP Function

  • Topic C

    The COUNTIF and SUMIF Functions

Advanced Data Analysis

  • Topic A

    Analysing Data with AI

  • Topic B

    Copilot in Excel

Data Tables & Scenario Manager

  • Topic A

    Analysing Data with AI

  • Topic B

    Copilot in Excel

Advanced Charting Techniques

  • Topic A

    Copying Plans

  • Topic B

    Exporting Plans

  • Topic C

    Copying Links to Plans

  • Topic D

    Adding Plans to Outlook

  • Topic E

    General & Group Settings

Data Tables & Scenario Manager

  • Topic A

    Data Tables

  • Topic B

    Scenario Manager

  • Topic C

    Subtotaling Data

Advanced Charting Techniques

  • Topic A

    Dynamic Charts

  • Topic B

    Advanced Chart Formatting

  • Topic C

    Sparklines

Pivot Tables & Pivot Charts

  • Topic A

    Pivot Table Options

  • Topic B

    Grouping Data in Pivot Tables

  • Topic C

    Slicers & Timelines

Working with External Data

  • Topic A

    Importing Data

  • Topic B

    Connecting to External Data

  • Topic C

    Data Connection Properties

Advanced Data Analysis Tools

  • Topic A

    Goal Seek

  • Topic B

    Solver

  • Topic C

    Analysis Toolpak

Advanced Functions

  • Topic A

    INDEX & MATCH

  • Topic B

    TEXT Functions

  • Topic C

    DATE & TIME Functions

  • Topic D

    Formula Auditing

Excel Automation Introduction

  • Topic A

    What are Macros

  • Topic B

    Recording Macros

  • Topic C

    Office Scripts

Named Ranges

  • Topic A

    What are Named Ranges?

  • Topic B

    Creating Named Ranges

  • Topic C

    Using Named Ranges

  • Topic D

    Data Validation with Named Ranges

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

4 Days

Formulas & Functions

1 Day

Why Companies Love Working with Appetite for Business

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