Modern Excel Formulas

Course Overview

Course details

Name: Modern Excel Formulas

Summary: Discover the power of Excel with formulas that go beyond traditional cell references.

Instructor: Mark Proctor

Course Length: 75 minutes

Number of Quizzes: 0

Includes Certificate of Completion: No

Note:

This is a publicly available course; therefore, it does not include the full functionality of other courses.

Who this course is for

The course is for:

• Excel users who want an introduction into dynamic arrays in Excel.
• Anyone who wants to apply modern Excel formula techniques to their work.
• Users who want to understand how Excel’s calculation engine really works.
• Learners ready to build smarter spreadsheets.

This course is not for:

• Users looking for legacy formula techniques.
• Anyone wanting a surface‑level introduction instead of conceptual depth.

Prerequisites and assumed knowledge

To get the most from this course, you should:

• Be comfortable with basic Excel formulas and cell references.
• Understand how to enter formulas, and how to navigate a workbook.

You do not need:

• Programming knowledge.
• Mathematical background beyond basic logic.
• Prior experience with dynamic arrays.

Learning objectives

By completing this course, you will be able to:

• Understand the difference between ranges and arrays, and how Excel converts between them.
• Apply array techniques to perform multiple calculations from a single cell.
• Use Boolean logic as the foundation of dynamic conditions.
• Introduce variables into formulas using LET to make them clearer and more maintainable.
• Approach formula building with conceptual understanding rather than memorisation.

Course content