Excel Intermediate: Functions and Data Analysis

What you'll learn

Advance your Microsoft Excel skills online and learn powerful data analysis tools with our Excel Intermediate course in Sydney!

This online Excel training course builds on your foundational knowledge and introduces essential business tools like PivotTables, VLOOKUP, conditional formatting, and data validation. You’ll learn how to analyse, organise, and present information more effectively, perfect for professionals who want to boost productivity and master Excel for work..

This online entry-level Microsoft Excel course in Sydney will increase your value in the job market and help you gain valuable insights into whatever data you choose to work with. Using Microsoft Excel, the user can identify trends by assembling data from various sources and can streamline tiresome tasks. Upon completion of the Excel for Beginners, students can progress to our Excel Intermediate: Functions and Data Analysis

Learning outcomes

By the end of this course, you will be able to:

• Use logical and lookup functions such as IF, AND/OR, and VLOOKUP
• Apply conditional formatting and advanced filters
• Manage data using named ranges and data validation
• Audit, debug, and trace complex formulas
• Create PivotTables and visual dashboards

Course content

What will be covered in this online Microsoft Excel course?

• Logical functions (IF, AND/OR) and text formulas
• Absolute and mixed referencing
• Conditional formatting and advanced filtering
• Named ranges and data validation
• Managing duplicates and unique lists
• PivotTables and PivotCharts
• Auditing and troubleshooting formulas
• Productivity tips and shortcut keys

Intended audience

Who is this online Excel Intermediate: Functions and Data Analysis course for?

This course is designed for students who have completed the Excel for Beginners: Formulas and Formatting course or already have equivalent foundational knowledge of Microsoft Excel. It’s ideal for anyone looking to up-skill, strengthen their data analysis abilities, and work more efficiently with spreadsheets in a professional setting.

Online Course

This course is now delivered online via Zoom, offering the same high-quality instruction and interactive learning experience as our in-person classes. A Zoom link and instructions will be provided before the course begins.

Course Materials

What You’ll Need for Your Online Class:

• Software required: Microsoft Office 365 or Office 2016 and later
• Your own laptop or computer capable of running Microsoft Excel.
• HDMI cable and an additional screen for a dual monitor setup (recommended).

Additional Information

This online class is suitable for both Windows and macOS users, as Microsoft Excel functions similarly on both platforms. Make sure your computer meets the system requirements for Microsoft Excel to ensure a smooth experience.