Overview

Elevate your Excel expertise with our Advanced Level 2 training course! This specialised course delves into the transformative capabilities of Power Query, enabling you to effortlessly streamline data imports and transform raw data into actionable insights.

You’ll also discover the power of new spilled array functions, which simplify complex calculations and provide dynamic results with unmatched efficiency.

Designed for professionals aiming to supercharge their data handling and analytical skills, this course equips you with advanced tools and techniques to optimise workflows and uncover deeper insights from your data

By the end of the course participants will:

have a good overview of Excel’s more Advanced Formulas and Functions for complex calculations.
use Lookup functions to find and return information from databases
use Arrays to build complex multi-reference formulas and functions
use Excel’s forecasting tools to perform What-If-Analysis.
use PivotTables and PivotCharts in order to create comprehensive reports from databases.
use Power Query to import and clean data use Power Pivot to manage large databases and lookup tables

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 Level 2 Course Outline

861 KB

Excel Advanced Level 2 Exercise Files

377 KB

2 items

All Download

Detailed Course Outline

Lookup Functions

LOOKUP, VLOOKUP, HLOOKUP
XLOOKUP (Office 365 – 2019 onwards)
INDEX & MATCH
COLUMN(S) & ROW(S)
CHOOSE

Arrays

- Array Formulas
- Array Functions
- Implicit Intersections
- Dynamic Arrays and Spilled Ranges (Office 365 – 2019 onwards)
  - FILTER function
  - SORT function
  - SORTBY function
  - UNIQUE function
  - SEQUENCE function

Forecasting

Scenarios
Goal Seek
Data Tables
Solver
Forecast Sheet

Advanced PivotTables

Data Consolidation with PivotTables
Custom PivotCharts
Dashboards
Using Slicers

Power Query

Import Data
Clean Imported Data
Split, Create and Delete Columns
Query Applied Steps
Merge and Append Data
Update or Modify linked files

Power Pivot

Activate Power Pivot
Understand Power Pivot
Import data into Power Pivot

Data Model

DAX Functions
Create Relationships between Data
Create a PivotTable from the Data Model

Course prerequisites

You need to be quite familiar with Excel, especially Functions, Tables and PivotTables

Inclusions

Instructor - led Training

Menual & Files

Unlimited Free Support

Microsoft Excel Advanced Level 2

Course Details

Duration 1 day

Level Advanced Level 2

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

You’ll also discover the power of new spilled array functions, which simplify complex calculations and provide dynamic results with unmatched efficiency.

By the end of the course participants will:

have a good overview of Excel’s more Advanced Formulas and Functions for complex calculations.
use Lookup functions to find and return information from databases
use Arrays to build complex multi-reference formulas and functions
use Excel’s forecasting tools to perform What-If-Analysis.
use PivotTables and PivotCharts in order to create comprehensive reports from databases.
use Power Query to import and clean data use Power Pivot to manage large databases and lookup tables

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.

SKU: N/A Category: Excel

Detailed Course Outline

Lookup Functions

LOOKUP, VLOOKUP, HLOOKUP
XLOOKUP (Office 365 – 2019 onwards)
INDEX & MATCH
COLUMN(S) & ROW(S)
CHOOSE

Arrays

- Array Formulas
- Array Functions
- Implicit Intersections
- Dynamic Arrays and Spilled Ranges (Office 365 – 2019 onwards)
  - FILTER function
  - SORT function
  - SORTBY function
  - UNIQUE function
  - SEQUENCE function

Forecasting

Scenarios
Goal Seek
Data Tables
Solver
Forecast Sheet

Advanced PivotTables

Data Consolidation with PivotTables
Custom PivotCharts
Dashboards
Using Slicers

Power Query

Import Data
Clean Imported Data
Split, Create and Delete Columns
Query Applied Steps
Merge and Append Data
Update or Modify linked files

Power Pivot

Activate Power Pivot
Understand Power Pivot
Import data into Power Pivot

Data Model

DAX Functions
Create Relationships between Data
Create a PivotTable from the Data Model

Course prerequisites

You need to be quite familiar with Excel, especially Functions, Tables and PivotTables

Inclusions

Instructor - led Training

Menual & Files

Unlimited Free Support

Microsoft Excel Advanced Level 2

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.

Microsoft Excel Advanced Level 2

Overview

Course Materials

Detailed Course Outline

Lookup Functions

Arrays

Forecasting

Advanced PivotTables

Power Query

Power Pivot

Data Model

Course prerequisites

Inclusions

Course Details

Private Sessions

Public Sessions

Detailed Course Outline

Lookup Functions

Arrays

Forecasting

Advanced PivotTables

Power Query

Power Pivot

Data Model

Course prerequisites

Inclusions

Reviews

Get Started With blank page Now

About Us

Connect us

Important

Services

Microsoft Excel Advanced Level 2

Overview

Course Materials

Detailed Course Outline

Course prerequisites

Inclusions

Related Courses

Course Details

Private Sessions

Public Sessions

Detailed Course Outline

Course prerequisites

Inclusions

Related Courses

Reviews

Get Started With blank page Now