Excel Course 2: Advanced Formula & Conditions

$80.00 CAD

Language: English
Certification: Yes
Mobile Friendly: Yes
Digital Badge: Yes
Course Length: 1 hour and 30 minutes

Requirements

This course requires email to be filled

Additional Course Information

Internal Training

SKU: 13824

Course by: OpenCircle Contractors Association

This intermediate Excel course builds on the foundational skills covered in Introduction to Spreadsheets. Learners will work with a preformatted spreadsheet and advance their skills by creating complex formulas using both relative and absolute cell references. The course introduces conditional functions such as IF, enabling users to generate dynamic results based on specific conditions. Participants will also explore conditional formatting techniques to visually highlight key data points and improve spreadsheet clarity. By the end of the course, learners will be equipped to design responsive, data-driven spreadsheets that adapt to changes automatically.

Syllabus

This intermediate Excel course builds on the foundational skills covered in Introduction to Spreadsheets. Learners will work with a preformatted spreadsheet and advance their skills by creating complex formulas using both relative and absolute cell references. The course introduces conditional functions such as IF, enabling users to generate dynamic results based on specific conditions. Participants will also explore conditional formatting techniques to visually highlight key data points and improve spreadsheet clarity. By the end of the course, learners will be equipped to design responsive, data-driven spreadsheets that adapt to changes automatically.

Note: Our course modules work best on the latest version of Google Chrome. If your course is not loading, update your browser and/or check your internet connectivity as a first step.