Want to build spreadsheets and formulas like a pro? Learn the functions of Microsoft Excel – the leading data and analysis tool in the workplace.
Can’t find a date/time that works for you?
Booking multiple seats? Federal Government Employee? Contact us directly.
Workshop Overview
Our Working with Microsoft Excel – Intermediate workshop is targeted towards individuals who are familiar with the basics of Excel but wish to deepen or refresh their base of knowledge. It is a Full day session with a live facilitator. This session is intended for those who wish to learn additional functions and tools to organize and analyze their data more thoroughly.
Workshop Information
- 1-day instructor-led sessions or
- Two 3-hour web-based online classroom sessions
- Optional follow up Coaching Session to reinforce learning
- Customized options for shorter in-house training are also available
Outcomes
On completion of this training, you should be able to:
- Create complex formulas and functions beyond the basics
- Work with lists and tables
- Analyze data for better interpretation and reporting
- Visualize data with charts and tables
- Audit worksheets to find errors
Intended Audience
This course is for individuals who are familiar with the basics of Excel and who wish to learn additional functions and tools to more fully organize and analyze their data.
Session Information
- 1-day instructor-led session or two 3-hour web-based live online
- Optional follow up Coaching Session to reinforce learning
- Customised options for shorter in-house training are also available
Level 2 – Units
Section 1: Creating Advanced Formulas
- Apply Range Names
- Use Specialized Functions
Section 2: Analyzing Data with Logical and Lookup Functions
- Use Logical Functions
- Use Lookup Functions
- Use Date Functions
- Conditional formatting with formula
Section 3: Organizing Worksheet Data with Tables
- Create and Modify Tables
- Sort and Filter Data
- Create a custom list (new)
- Create Slicers (new)
Section 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Create a Trendline
Section 5: Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Additional Materials
- Enrollment in our Monthly LearningLink Newsletter
- Lifetime Support
- A Free Follow-up 30-minute Coaching Session
Follow-up Coaching
There is a key difference between learning and knowing. Learning is the process of being taught the material while knowing is about internalizing and retaining it. If at any point after a session you feel the need for more support in knowing the lessons taught to you, a free 30-minute coaching session is available to you on request.