Address
Level 8/25 Restwell Street, Bankstown NSW 2200, Australia
Business Hours
Monday to Friday: 10AM - 6PM
Weekend: CLOSED
Microsoft Excel – Intermediate
Take your Excel skills to the next level. This intermediate course builds on the basics with tools for data control, logical functions, lookups, sorting and date and time calculations. You’ll learn practical techniques to make spreadsheets easier to read, automate decisions and manage complex datasets with confidence. It’s ideal for professionals, analysts and students ready to move beyond the fundamentals.
Duration
1 hour 10 minutes
Modules
1 Modules
Course type
Microsoft
Course Overview
This intermediate-level course builds on foundational Excel skills and introduces advanced tools for data control, logical functions, lookups, sorting, and date-time calculations. Learners will explore practical techniques to improve spreadsheet readability, automate decisions, and manage complex datasets. Ideal for professionals, analysts, and students ready to level up their Excel expertise.
Before You Begin
- Basic Excel knowledge required
- Familiarity with formulas and functions helpful
- Access to Microsoft Excel 365 or Excel 2021
Key outcomes
- Improve Spreadsheet Readability Use styles, validation, and navigation tools.
- Apply Logical Formulas Automate decisions with IF and IFS functions.
- Perform Advanced Lookups Use flexible lookup functions for dynamic data.
- Sort and Filter Data Organize data with custom lists and formulas.
- Work with Dates and Times Calculate workdays, durations, and custom formats.
Tools you’ll use
Excel 365 / Excel 2021
Skills you’ll gain
- Cell Styling
- Data Validation
- Navigation Buttons
- Logical Functions
- Conditional Formulas
- Error Handling
- Lookup Functions
- Sorting Techniques
- Advanced Filtering
- Date Calculations
What You’ll Learn
1 module
1Lesson 1: Microsoft Excel (Intermediate)
Module 1: Introduction Module 2: Improving Data Interaction Module 3: Smart Formulas and Functions Module 4: Lookup and Reference Tools Module 5: Sorting and Filtering Data Module 6: Working with Dates
Certification & Credentials
Certificate track
1 hour 10 minutes
Target Audience
Intended roles
- Business Productivity Specialist
- Healthcare Administrator
- Nursing Informatics Specialist
- Real Estate Sales Consultant
Frequently asked questions
Is this course for intermediate users?
Yes, it builds on basic Excel knowledge and introduces advanced tools.
Do I need Excel 365?
You can use either Excel 365 or Excel 2021 for this course.
Will I learn lookup functions?
Absolutely! VLOOKUP, XLOOKUP, INDEX/MATCH and more are covered.
Can I use this for work?
Yes, it’s ideal for professionals handling data and reports.
Who should take this course?
Analysts, students, and professionals ready to advance their Excel skills.
| Duration | 1 hour 10 minutes |
|---|---|
| Modules | 1 Modules |
| Course type | Microsoft |
| Category | Microsoft |
| Intended roles | Business Productivity Specialist, Healthcare Administrator, Nursing Informatics Specialist, Real Estate Sales Consultant |
| Prerequisites | Basic Excel knowledge required, Familiarity with formulas and functions helpful, Access to Microsoft Excel 365 or Excel 2021 |
Be the first to review “Microsoft Excel – Intermediate”
Reviews
There are no reviews yet.