Automation: Macros & VBA
What you will be able to do
- Record and run macros safely
- Read and write VBA code
- Use loops, conditions and error handling
- Automate a month-end task
19 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Macros
- Developer tab and macro securityReal Excel
- Recording a macroReal Excel
- Relative vs absolute recordingReal Excel
- Saving as .xlsm and running macrosReal Excel
Module 2: VBA basics
- The VBA editorReal Excel
- Reading and editing a recorded macroReal Excel
- Range, Cells and OffsetReal Excel
- Variables and data typesReal Excel
- Worksheets and workbooks in codeReal Excel
- IF statementsReal Excel
- For and For Each loopsReal Excel
- Do loops and finding the last rowReal Excel
- MsgBox and InputBoxReal Excel
Module 3: Making it reliable
- DebuggingReal Excel
- Error handlingReal Excel
- Writing your own functionReal Excel
- Speed and safetyReal Excel
- Automating a month-end taskReal Excel
Project: split and save department reports
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free