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.

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.

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.

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.

Data Managment

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

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.

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.

Detailed Course Outline

Using Names

• Naming cells
• Naming ranges
• Using Names in formulas and functions

Using Tables

• 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

Advanced Functions

• Function Structure
• IF function
• AND / OR functions
• Nested functions
• VLOOKUP function
• XLOOKUP function (Office 365)
• IS functions

Data Management

• Advanced Sorting & Filtering
• SUBTOTAL function
• Subtotals Feature

PivotTables

• 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

PivotCharts

• Creating a PivotChart
• Reorganising Chart Fields
• Filtering Chart Fields
• Using Slicers on Charts

Basic Macros

• 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

Instructor - led Training

Menual & Files

Unlimited Free Support

Microsoft Excel Advanced Level 1

Related Courses

• 

  Fundamentals

  Excel

  Microsoft Excel Fundamentals Course

  1 day
  Details

  $375
• 

  Advanced Level 2

  Excel

  Microsoft Excel Advanced Level 2

  1 day
  Details

  $395
• 

  Advanced

  Excel

  Microsoft Excel VBA Training Courses

  2 days
  Details
• 

  Intermediate

  Excel

  Microsoft Excel Intermediate Training

  1 day
  Details

  $375

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.

Enquire Now - Get a Quote

Public Sessions

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

$395

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.

Enrol in a Public Session

Available Public Sessions	Public sessions are unavailable at the moment. Please contact us to arrange one. Clear

SKU: N/A Category: Excel

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.

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.

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.

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.

Data Managment

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

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.

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.

Detailed Course Outline

Using Names

• Naming cells
• Naming ranges
• Using Names in formulas and functions

Using Tables

• 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

Advanced Functions

• Function Structure
• IF function
• AND / OR functions
• Nested functions
• VLOOKUP function
• XLOOKUP function (Office 365)
• IS functions

Data Management

• Advanced Sorting & Filtering
• SUBTOTAL function
• Subtotals Feature

PivotTables

• 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

PivotCharts

• Creating a PivotChart
• Reorganising Chart Fields
• Filtering Chart Fields
• Using Slicers on Charts

Basic Macros

• 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

Instructor - led Training

Menual & Files

Unlimited Free Support

Microsoft Excel Advanced Level 1

Related Courses

• 

  Fundamentals

  Excel

  Microsoft Excel Fundamentals Course

  1 day
  Details

  $375
• 

  Intermediate

  Excel

  Microsoft Excel Intermediate Training

  1 day
  Details

  $375
• 

  Advanced Level 2

  Excel

  Microsoft Excel Advanced Level 2

  1 day
  Details

  $395
• 

  Advanced

  Excel

  Microsoft Excel VBA Training Courses

  2 days
  Details

Reviews

 
 
 
 
 
 
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Ruth Broadbent 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Great training! Super easy to follow and learnt so much. Highly recommend
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Jayden Lewis 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Very informative and relevant training. Offered all the basics in overview then asked for task specific examples of trainees existing problems or needs
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Chirag Thakkar 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Love the course content and great facilitator.
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Veronica Robinson 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Really enjoyed this course. Easy to follow and Anton took his time to make sure we all were on the same page. Highly recommended
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Charles Bibby 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Anton took both the intermediate and advanced excel courses and was an excellent teacher and highly knowledgeable. Would highly recommend taking these courses if you get the chance.
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Ellen L 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Anton was a great trainer in both the intermediate and advanced excel training. The sessions were informative and interesting and I've learnt a lot.
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Vivi Lloyd 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Really great training that was well explained and easy to understand!
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Ruby Phillips 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Super insightful training!
  
 
  
 
 
 
 Posted on Google  
 
  
 
 
 Haley Demir 
 
 
 
 Trustindex verifies that the original source of the review is Google. 
Highly recommend!! Anton is amazing, knowledgeable and patient. I’ve completed several courses at Blank Page and every course has been brilliant.