Sign in Start learning
Home › Courses › Automation with Excel
Advanced 6 hours of video 39 lessons Exercise files included Certificate of completion

Automation with Excel

Macros, VBA fundamentals and Office Scripts — automating the repetitive work that eats your week.

Buy this course — €30 All 9 courses for €65

About this course

Some work genuinely repeats: the same report, the same formatting, the same export, every week. Automation turns that into a button. This course starts with the recorder, moves into readable VBA, and covers Office Scripts for the modern web-based workflow — including an honest section on when automation is the wrong answer.

What you will be able to do

  • ✓Record a macro, then read and repair the code it produced
  • ✓Write VBA with variables, loops and conditionals that a colleague can follow
  • ✓Work with ranges, worksheets and workbooks reliably in code
  • ✓Handle errors so a macro fails safely instead of corrupting data
  • ✓Build simple user forms and input validation
  • ✓Automate report assembly, formatting and export to PDF
  • ✓Use Office Scripts and Power Automate for cloud-based workflows
  • ✓Judge when Power Query or a formula is a better answer than code

Course content

8 modules · 39 lessons · approximately 6 hours of video

Module 1 — The recorder and its limits

Recording, running and reading a macro. Why recorded code is verbose and fragile, and how to fix it.

Module 2 — VBA fundamentals

The editor, modules, variables and types, loops, conditionals, and writing code that reads like a sentence.

Module 3 — The Excel object model

Workbooks, worksheets, ranges and cells. Selecting less, referencing more.

Module 4 — Robust macros

Error handling, screen updating, defensive checks, and undo-safety before touching real data.

Module 5 — Interaction

Message boxes, input boxes, simple user forms and buttons for the people who will actually run it.

Module 6 — Report automation

Assembling a monthly report, applying formatting, exporting to PDF and emailing the output.

Module 7 — Modern automation

Office Scripts, Power Automate flows, and when a cloud workflow beats a desktop macro.

Module 8 — Knowing when not to automate

Maintenance cost, key-person risk, and the tasks better solved with Power Query or a rethink.

Requirements

  • A computer with Microsoft Excel installed. Microsoft 365 is recommended; where a feature is version-dependent, the lesson states this and shows the alternative approach.
  • No software is provided with this course. Learners must hold their own licence for any Microsoft product used.
  • Roughly 6 hours of study time, which you can spread over as long as you like — access does not expire.

Other courses

Beginner 6 h

Microsoft Excel Essentials

Build a solid, reliable foundation in Excel: structure, formulas, formatting and the habits that prevent broken spreadsheets.

View course →
Intermediate 8 h

Advanced Excel

Dynamic arrays, advanced lookups, financial and statistical functions, and models that are built to be audited.

View course →
Intermediate 6 h

Power Query

Stop cleaning the same file every month. Build repeatable transformations that refresh with one click.

View course →