Excel Foundation

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).

Pre-requisites

None. This is a beginner level course.