Data-driven Decision Making with Excel

Core Skills
Excel is a computer application that stores and analyses data. With the use of spreadsheets, Excel allows users to load data and perform a wide range of calculations on that information.

Data-driven Decision Making with Excel

Core Skills
Excel is a computer application that stores and analyses data. With the use of spreadsheets, Excel allows users to load data and perform a wide range of calculations on that information.

prerequisites

No prior knowledge 
necessary

All levels welcome

duration

Full day or
two half-days

Virtual or in-person

certification

afterskills Excel II
practitioner

Awarded upon completion

course description_

Excel is the most widely used piece of software for creating actionable insight. Accordingly, Data-driven Decision Making with Excel provides a comprehensive overview of the core functions of Excel and is designed to build proficiency in the shortest amount of time possible.

Participants will leave with a strong knowledge of how to analyse, structure and solve real-world business problems using Excel.

agenda

Topic 1: Lookups (Vlookup)
Topic 2: Index Match
Topic 3: Grouping & Summarising Data
- Pivot Tables
- Aggregate Functions
Topic 4: Named Ranges
Topic 5: Tables
ENQUIRE