excel level I

Course Description

Prerequisites: None

Excel is a computer program 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.

Excel is the most widely used piece of software for creating actionable insight. Accordingly, Excel Lab: From Excel Beginner to Guru (A101) provides a comprehensive overview of the core functions of Excel and is designed to take absolute beginners to 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.

Course Agenda

Session 1: Introduction & Data Auditing

Session 2: Formulas

Session 3: Relative References

Session 4: Lookups - VLookup

Session 5: Grouping & Summarising - Pivot Tables, Aggregate Functions

Session 6: Charts