Microsoft Excel Advanced Level 2

Excel Advanced Level 2 training Melbourne

Overview

Microsoft Excel training course in Melbourne and across Australia.  Face-to-face Excel training or Live online Excel training courses available.

If you've ever felt like you're doing things the long way and that there must be a quicker and more streamlined way of getting data into Excel to build reports, then this is the course for you!

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 Spilled 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

Excel Advanced Level 2 Course Outline

File size: 861 kb

Excel Advanced Level 2 Exercise Files

File size: 377 kb

Inclusions

  • Live instructor led training
  • Comprehensive training manual
  • Training certificate

Course prerequisites

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

What's covered

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

PRIVATE SESSION

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

from $198 per person
Course Length: 1 day

PUBLIC SESSION

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

$375 per person

Public session Available dates:

Mar 13
1 day
9:00 am - 4:30 pm

Learn about Excel's more advanced features like Spilled Arrays, Lookups, Power Query, Power Pivots and Forecasting tools.

Our Microsoft Excel Advanced Level 2 training course can be delivered face-to-face in Melbourne or live online across Australia.

Get a quote for a group

Enquire

Enrol

Private Session

Link partner: max77 gopek178 ondel4d sirkuit4d spade88 slot188 qqmobil area188 sky77 bro138 slot5000 luxury333 batman138 bos88 roma77 indobet zeus138jaya.org ligaplay88 toto togel slot88 warungtoto pokerseri autowin88 vegas77 vegasslot77 mantra88 sensa gaming