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!

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 functions such as IF, AND, and OR to create conditional formulas.
• Apply lookup functions including XLOOKUP and VLOOKUP to retrieve data efficiently.
• Work with date functions to calculate and manage time-based data.
• Use text functions to clean, modify, and format text within cells.
• Apply mixed referencing (e.g., $A1) to manage cell references in formulas.
• Combine and separate data by joining or splitting cells.
• Automate repetitive data entry tasks using Flash Fill.
• Build and manage data tables for structured analysis.
• Perform advanced sorting and filtering to extract specific data sets.
• Enhance worksheets with conditional formatting to highlight key information.
• Identify and handle duplicate data effectively.
• Evaluate and troubleshoot formulas using auditing tools.
• Increase efficiency and productivity with essential Excel shortcut keys.

Course content

What will be covered in this online Microsoft Excel course?

• Logical functions (if |and |or)
• Lookup functions (Xlookup and Vlookup)
• Date functions
• Text functions
• Mixed referencing ($A1)
• Join cells together and split them up
• Flash fill
• Data tables
• Advanced sorting and filters
• Conditional formats
• Working with duplicates
• How to evaluate a workbook using auditing tools
• Short cut keysjust use

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).
• Please note: The tutor teaches using Windows, however Mac users are welcome to join. Some shortcuts and functions may differ slightly between operating systems.

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.