Data Analytics Foundation 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 Analytics Foundation 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 I
practitioner

Awarded upon completion

course description_

Excel is the most widely used piece of software for creating actionable insight. Accordingly, Data Analytics Foundation with Excel provides a comprehensive overview of the basic functions of Excel and is designed to provide absolute beginners with the practical knowledge of how to use Excel to maximise efficiency when working with data!

Participants will leave with a strong foundational knowledge of how to perform simple operations in Excel at their workplace.

agenda

Topic 1: Introduction to Excel
Topic 2: Data Auditing & Filtering
Topic 3: Functions & Formulas
- Text & Numerical
- Basic Aggregations
- Logic & Date / Time 
Topic 4: Relative References
ENQUIRE