Zomalex | Data and AI Training
Excel Foundation Course
Who should attend
This is a foundation course in Excel suitable for beginners and for people who have been using Excel for a while but want to refresh their understanding of the basics of Excel.
Learning Objectives
You will learn how to edit and view an Excel worksheet: navigate the sheets, learning common functions and how to write basic formulas.
Course Content
- Getting Started. Excel User Interface and Layout: Entering Data. Data validation
- Formulas. Relative and fixed cell references. Named ranges.
- Functions. Whirlwind tour of some of the most useful Excel functions e.g., SUM, IF, VLOOKUP, XLOOKUP
- Introduction to Excel tables: how to create them and why they are very useful.
- Introduction to pivot tables
- Presenting data in tables. Conditional formatting (data bars, icons, sparklines).
Course Length
1 day (short version) or 2 days (preferred, full version)
Pre-requisites
None. This is a beginner level course.
Snapshots from the course exercises
One of the Excel labs