Data and AI Training

Home | Prices | Contact Us | Courses: 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).