Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data
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.
Course Length
1 day
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.
Pre-requisites
None. This is a beginner level course.
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.
- Introduction to Excel tables: how to create them and why they are very useful.
- Presenting data in tables. Conditional formatting (data bars, icons, sparklines).