clock icon

MON - FRI
9.00AM - 17.00PM

call icon

04 TRAINING
0487 24 64 64

Microsoft Excel Advanced Level 1

Overview

Take your Excel skills to the next level with our Excel Advanced training course! This course is perfect for those looking to dive deeper into the power and versatility of Excel.

You’ll explore advanced referencing techniques, including named ranges and structured tables, that streamline your workflow and make your data more dynamic.

We’ll guide you through the process of analyzing data with sophisticated functions and powerful PivotTables, helping you uncover meaningful insights with ease.

Whether you’re managing complex datasets or optimizing reports, this course equips you with the tools and expertise to excel at a truly advanced level.

Microsoft Excel training course in Melbourne and across Australia.  We can come to you for Face-to-face Excel training or you can join us online for Live online Excel training courses.

Course Materials

Excel Advanced Course Outline
574 KB
Excel Advanced Exercise Files
289 KB
2 items
All Download

What you'll Learn:

Using Names

A single cell or a range of cells can be named to simplify references in formulas and functions.

You’ll learn how to create Names, use Names in formulas and functions and Manage Names.

Names-1

Using Tables

The fancy formatting options for tables are just the beginning, what makes tables excellent to work with, it the way they interact with Formulas, Functions, PivotTables, Data Validation and a host of other features.

Tables

Advanced Functions

Understanding Excel’s Functions is an import aspect of using Excel to it’s full potential. The advanced functions covered in this course aims to help you understand function structure and requirements which can be applied to any function.

Functions

Advanced Conditional Formatting

Conditional formats are a valuable method for error checking of data entries and highlighting discrepancies between numbers.

For example, when a cell entry exceeds a specified value or is outside a particular range, the user can be alerted by seeing the value displayed in a different colour.

Conditional-Formatting

Data Managment

Learn about Advanced techniques for Sorting, Filtering and Summarising Data with the SUBTOTAL function.

Data-Filter

PivotTables and PivotCharts

A PivotTable is an interactive table that quickly summarises, or cross-tabulates, large amounts of data from lists or tables. Field headers can be dragged to various regions within the PivotTable structure with complete flexibility to create a report.

Once a PivotTable is populated with data it can be rearranged, charted, formatted, filtered, calculated, summarised and broken up into individual pages.

PivotTable-and-Charts

Macros (VBA for Excel)

When the same actions or tasks are repeatedly performed in documents, it might be time to create a macro. A macro is a recording of each command and action performed to complete a task. Then, whenever a task needs to be carried out in a document, the macro could be run instead.

Macros-e1634689536428

Detailed Course Outline

  • Naming cells
  • Naming ranges
  • Using Names in formulas and functions
  • Creating Tables
  • Table Components and Features
  • Table Formatting
  • Formulas and Functions in Tables
  • Naming Tables and using Table names in Formulas and Functions
  • Using Slicers
  • Function Structure
  • IF function
  • AND / OR functions
  • Nested functions
  • VLOOKUP function
  • XLOOKUP function (Office 365)
  • IS functions
  • Advanced Sorting & Filtering
  • SUBTOTAL function
  • Subtotals Feature
  • Constructing PivotTables
  • Data fields
  • Filtering
  • Hiding and showing field details
  • Creating data groups
  • Displaying Source Data
  • PivotTable Options
  • Formatting PivotTables
  • Comparative Calculations
  • Calculated fields
  • Data Consolidation with PivotTables
  • Creating a PivotChart
  • Reorganising Chart Fields
  • Filtering Chart Fields
  • Using Slicers on Charts
  • Recording Macros
  • Running Macros
  • Assigning Macros to Worksheet Objects
  • Customising the Ribbon

Course prerequisites

Previous experience using Microsoft Excel at an Intermediate level is an essential prerequisite for this course.

Inclusions

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

Microsoft Excel Advanced Level 1

Course Details

Duration 1 day
Level Advanced

Private Sessions

Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.

Public Sessions

Join a public course session conducted LIVE ONLINE via Microsoft Teams.

$395

SKU: N/A Category:

What you'll Learn:

Using Names

A single cell or a range of cells can be named to simplify references in formulas and functions.

You’ll learn how to create Names, use Names in formulas and functions and Manage Names.

Names-1

Using Tables

The fancy formatting options for tables are just the beginning, what makes tables excellent to work with, it the way they interact with Formulas, Functions, PivotTables, Data Validation and a host of other features.

Tables

Advanced Functions

Understanding Excel’s Functions is an import aspect of using Excel to it’s full potential. The advanced functions covered in this course aims to help you understand function structure and requirements which can be applied to any function.

Functions

Advanced Conditional Formatting

Conditional formats are a valuable method for error checking of data entries and highlighting discrepancies between numbers.

For example, when a cell entry exceeds a specified value or is outside a particular range, the user can be alerted by seeing the value displayed in a different colour.

Conditional-Formatting

Data Managment

Learn about Advanced techniques for Sorting, Filtering and Summarising Data with the SUBTOTAL function.

Data-Filter

PivotTables and PivotCharts

A PivotTable is an interactive table that quickly summarises, or cross-tabulates, large amounts of data from lists or tables. Field headers can be dragged to various regions within the PivotTable structure with complete flexibility to create a report.

Once a PivotTable is populated with data it can be rearranged, charted, formatted, filtered, calculated, summarised and broken up into individual pages.

PivotTable-and-Charts

Macros (VBA for Excel)

When the same actions or tasks are repeatedly performed in documents, it might be time to create a macro. A macro is a recording of each command and action performed to complete a task. Then, whenever a task needs to be carried out in a document, the macro could be run instead.

Macros-e1634689536428

Detailed Course Outline

  • Naming cells
  • Naming ranges
  • Using Names in formulas and functions
  • Creating Tables
  • Table Components and Features
  • Table Formatting
  • Formulas and Functions in Tables
  • Naming Tables and using Table names in Formulas and Functions
  • Using Slicers
  • Function Structure
  • IF function
  • AND / OR functions
  • Nested functions
  • VLOOKUP function
  • XLOOKUP function (Office 365)
  • IS functions
  • Advanced Sorting & Filtering
  • SUBTOTAL function
  • Subtotals Feature
  • Constructing PivotTables
  • Data fields
  • Filtering
  • Hiding and showing field details
  • Creating data groups
  • Displaying Source Data
  • PivotTable Options
  • Formatting PivotTables
  • Comparative Calculations
  • Calculated fields
  • Data Consolidation with PivotTables
  • Creating a PivotChart
  • Reorganising Chart Fields
  • Filtering Chart Fields
  • Using Slicers on Charts
  • Recording Macros
  • Running Macros
  • Assigning Macros to Worksheet Objects
  • Customising the Ribbon

Course prerequisites

Previous experience using Microsoft Excel at an Intermediate level is an essential prerequisite for this course.

Inclusions

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

Microsoft Excel Advanced Level 1

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel Advanced Level 1”

Your email address will not be published. Required fields are marked *

Scroll to top