Address
Level 8/25 Restwell Street, Bankstown NSW 2200, Australia
Business Hours
Monday to Friday: 10AM - 6PM
Weekend: CLOSED
Microsoft Excel – Advance
Take your Excel skills to an expert level. This advanced course shows data professionals, analysts and power users how to work smarter in Excel 365 with dynamic arrays, advanced lookup functions, statistical tools and specialised rounding techniques. You’ll learn to automate tasks and build precise, flexible spreadsheets using the latest Excel features.
Duration
1 hour 10 minutes
Modules
1 Modules
Course type
Microsoft
Course Overview
This advanced-level course empowers learners to master dynamic arrays, advanced lookup functions, statistical tools, and specialized rounding techniques in Excel 365. Designed for data professionals, analysts, and power users, this course focuses on automation, precision, and flexibility in spreadsheet operations using the latest Excel features.
Before You Begin
- Intermediate Excel knowledge required
- Familiarity with formulas and functions
- Access to Microsoft Excel 365
Key outcomes
- Use Dynamic Arrays Automate data spills and extract unique values.
- Sort and Randomize Data Apply SORTBY, SEQUENCE, and RANDARRAY.
- Perform Complex Lookups Use XLOOKUP, XMATCH, INDEX/MATCH, and OFFSET.
- Apply Logical Tools Use CHOOSE, SWITCH, and two-way lookups.
- Analyze and Rank Data Use statistical functions and ranking tools.
- Round and Aggregate Values Apply rounding logic and AGGREGATE function.
Tools you’ll use
Excel 365
Skills you’ll gain
- Dynamic Arrays
- Unique Extraction
- Advanced Sorting
- Complex Lookups
- Two-Way Lookup
- Logical Functions
- Statistical Tools
- Data Ranking
- Rounding Values
- Aggregation Functions
What You’ll Learn
1 module
1Lesson 1: Microsoft Excel (Advance)
Module 1: Introduction Module 2: Advanced Excel Functions Module 3: Advanced Lookup Functions Module 4: Statistical Functions in Excel Module 5: Excel Rounding Functions
Certification & Credentials
Certificate track
1 hour 10 minutes
Target Audience
Intended roles
- Business Productivity Specialist
- Finance Analyst
- Pharmaceutical Operations Specialist
- Supply Chain Analyst
Frequently asked questions
Is this course for advanced users?
Yes, it’s designed for users with intermediate Excel experience.
Do I need Excel 365?
Yes, many features like dynamic arrays are exclusive to Excel 365.
Will I learn advanced lookups?
Absolutely! XLOOKUP, XMATCH, and INDEX/MATCH are covered.
Can I use this for data analysis?
Yes, it’s ideal for analysts and professionals working with large datasets.
Who should take this course?
Data professionals, analysts, and Excel power users.
| Duration | 1 hour 10 minutes |
|---|---|
| Modules | 1 Modules |
| Course type | Microsoft |
| Category | Microsoft |
| Intended roles | Business Productivity Specialist, Finance Analyst, Pharmaceutical Operations Specialist, Supply Chain Analyst |
| Prerequisites | Intermediate Excel knowledge required, Familiarity with formulas and functions, Access to Microsoft Excel 365 |
Be the first to review “Microsoft Excel – Advance”
Reviews
There are no reviews yet.