Excel: advanced

About this course

The course develops advanced Excel techniques for data analysis. Participants work with logical, statistical, financial and mathematical functions, including COUNTIF, SUMIF, VLOOKUP, HLOOKUP, DATE, TIME, PMT, PV, FV and database functions. Topics also include named ranges, data tables, worksheet linking, conditional formatting, validation, auditing, sorting and filtering. Further work covers pivot tables, scenario analysis and macro recording. Step-by-step instruction and demonstrations are used to explain the techniques and their application to larger, more complex worksheets.

What you'll learn

• Construct calculations using advanced Excel functions and values from different worksheets or workbooks.
• Apply sorting, filtering, conditional formatting and data validation to complex datasets.
• Analyse data with pivot tables and data tables.
• Create best-case and worst-case scenarios using Scenario Manager.
• Record macros to automate spreadsheet tasks.

Is this course right for you?

This course is intended for learners with intermediate Excel knowledge or experience, particularly those involved in data analysis. Participants should be comfortable with formula structures, number formatting and mathematical calculations, and able to follow spoken and written instructions.

• Advanced level work builds on intermediate Excel skills.
• The course is relevant to data analysis using Excel.

Before you go

• Course notes will be provided through Google Classroom.
• The course might require use of a personal account or creation of an account for third-party software.
• Learners attending the full course will receive an electronic City Lit certificate of attendance.