Skip to content
learn@aiera

Work · advanced

Spreadsheets Advanced: Modern Formulas, Modelling and Automation

Build reliable, powerful spreadsheets: dynamic array formulas, financial and what-if models, collaboration and automation, and the habits of trustworthy models.

4 lessonsAbout 52 minFree
Start course

Not started

Finish every lesson, then sign in and pass the final assessment to earn a free certificate

Module 1: Professional spreadsheets

  1. Dynamic Arrays and Modern Formulas13 min · Up next
  2. Financial and What-If Models14 min · Not started
  3. Collaboration, Protection and Automation13 min · Not started
  4. Reliable Models and Knowing the Limits12 min · Not started

Questions about Spreadsheets Advanced: Modern Formulas, Modelling and Automation

What will I learn in Spreadsheets Advanced: Modern Formulas, Modelling and Automation?

Build reliable, powerful spreadsheets: dynamic array formulas, financial and what-if models, collaboration and automation, and the habits of trustworthy models. The course has 4 lessons, organised in one module: Module 1: Professional spreadsheets.

How long does Spreadsheets Advanced: Modern Formulas, Modelling and Automation take?

About 52 minutes in total, across 4 lessons. You can learn at your own pace and stop and continue any time.

Do I need experience to take Spreadsheets Advanced: Modern Formulas, Modelling and Automation?

You should be comfortable with the beginner and intermediate material first. If not, start with those courses.

Is Spreadsheets Advanced: Modern Formulas, Modelling and Automation free?

Yes. The whole course is free and you do not need an account to learn. A free account is only needed for the final assessment and the certificate.

Do I get a certificate for Spreadsheets Advanced: Modern Formulas, Modelling and Automation?

Yes, a free certificate of completion. Finish every lesson, sign in, and pass the 15-question final assessment with 80% or more. It is not an accredited qualification.