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.

Course Length

1 day (short version) or 2 days (preferred, full version)

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

A few comments from attendees of previous courses

“Great course with a great teacher who was exceptionally clear and patient. A good course for the basics in Excel.”

“I was not scared to ask a silly question! Overall very good course and I learned a new skill. Thank you.”

“Informative & well structured. I found the training to be interactive & moved at a pace which allowed the group to keep up and remain engaged. The course presenter was incredibly patient and welcomed the group to ask questions throughout to ensure the learning was understood & tasks were able to be successfully completed.”

“Mark was very good at delivering the course and he also engaged everyone attending.”

“It was a great time with Mark and I am looking forward to the intermediate and other levels.”