Course compare | Rootlet

Compare with 1 courses

Excel Macros and VBA: Automate Repetitive Spreadsheet Work

Excel Macros and VBA: Automate Repetitive Spreadsheet Work

Turn the spreadsheet jobs you repeat every week into macros: record them, write VBA, loop through rows and files, build reports and combine workbooks. 51 written lessons plus 10 practice downloads.

£39.99

Learn more

Has discount
Expiry period	Lifetime
Made in	English
Last updated at	Tue Oct 2026
Level	Intermediate
Total lectures	61
Total quizzes	0
Total duration	11:36:00 Hours
Total enrolment	0
Number of reviews	0
Avg rating
Short description	Turn the spreadsheet jobs you repeat every week into macros: record them, write VBA, loop through rows and files, build reports and combine workbooks. 51 written lessons plus 10 practice downloads.
Outcomes	Decide which spreadsheet jobs are worth automating, and set up Excel to record, store and run macros safely Record macros, store them in a workbook or the Personal Macro Workbook, and tidy the recorded code Find your way round the VBA editor, and run code line by line to see what it does Write VBA with variables, data types, objects, Range and Cells, If and Select Case, and loops Find the last row of any data, check every row, and copy, sort, filter and delete without selecting Build a formatted weekly report with a summary table, highlighting and a PDF, from one macro Combine every file in a folder into one sheet, and check the result against each file's own figures Ask users for input with message boxes and a UserForm, react to events, and run macros from buttons Debug, handle errors, write your own worksheet functions and document macros so someone else can run them Automate a full month-end from a folder of branch returns to a checked summary and PDF
Requirements	You should be comfortable with everyday Excel: sheets, ranges, sorting, filtering and simple formulas (Rootlet's Excel for Beginners course covers these) The Excel desktop app for Windows: Excel in Microsoft 365 or Excel 2024. Excel 2021 runs everything too, but Microsoft stopped supporting it on 13 October 2026. Macros can't be created or run in Excel for the web No coding experience is needed; every line of VBA is explained If you use Excel at work, check that your organisation allows macros