Course Description

This focused half-day course delivers the most essential intermediate Excel skills in a time-efficient format. You'll learn key advanced formulas, data organisation techniques, and chart creation methods that provide immediate productivity benefits. Designed for busy professionals who need to enhance their Excel capabilities quickly, this streamlined course focuses on the most practical and frequently used intermediate Excel features.

Target Student

Ideal for Excel users who have mastered the basics and need to quickly expand their skills to handle more complex data tasks. This course is perfect for business professionals with limited training time who need to analyse data more effectively, create meaningful visualisations, and improve their Excel efficiency. If you're comfortable with basic Excel operations but need to take your skills to the next level in a time-efficient manner, this condensed essentials course is designed for you.

Prerequisites

Before starting this course, students are recommended to take the following course or have equivalent knowledge: Excel 365 Level 1 or similar foundational Excel skills.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• use advanced formulas
• organize worksheet and table data using various techniques
• create and modify charts

Course Content:

Lesson 1: Calculating Data with Advanced Formulas

• Work with Range Names
• Calculate across worksheets and workbooks
• Analyze Data with Logical and Lookup Functions
• IFS and Switch Functions

Lesson 2: Presenting Data Using Charts

• Understanding Charts and Chart types
• Create a Chart
• Modify and Format Charts
• Add and remove Chart data
• Add a Trendline to a Chart
• Analyse Data using Sparklines

Lesson 3: Organizing Worksheet Data

• Apply basic sorting to a Data Range
• Advanced Sorting
• Summarise Data with Subtotals

Lesson 4: Analysing Selected Data

• Applying Basic Filters
• Advanced Filters
• Use Outlines to organize data