Advanced Excel · Intermediate level

Intermediate level · Module 5 of 6 · 13 guided hours

Automating Excel

Automate repetitive Excel tasks with recorded macros, basic VBA and Office Scripts, safely.

Learning objectives

  • Record and run macros
  • Read and edit simple VBA code
  • Use Office Scripts and apply macro security

Topics

  • recording macros
  • relative recording
  • VBA editor and modules
  • variables, loops and ranges in VBA
  • Office Scripts for Excel on the web
  • macro security

Lessons

  1. Lesson 1 Recording Macros

    Record repetitive steps as macros and run them with a button or shortcut.

    macro recorderrelative referencesmacro-enabled workbookassigning to a button

  2. Lesson 2 Basic VBA

    Read and improve recorded code, and write simple procedures with variables and loops.

    VBA editorSub procedurevariablesFor Each loop

  3. Lesson 3 Office Scripts and Macro Security

    Understand modern automation with Office Scripts and keep macros safe.

    Office Scriptsautomation in the cloudTrust Centermalicious macros

Practical activity

Automate the monthly export of each branch's report as a separate PDF, first by recording and then by editing the VBA.

Expected outcomes

  • Time saved on repetitive tasks
  • Safe automation habits

Assessment

Practical: automate a provided task; marked on correctness, readability and safety.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.