Microsoft Office & 365 Apps
Excel - Build Muscle with Macros
A one-hour live class on recording and running Excel macros to repeat formatting and tasks across sheets and workbooks.
1 hourIntermediate1 modules
About this course
A one-hour live class on recording and running Excel macros to repeat formatting and tasks across sheets and workbooks.
Curriculum
1 modules
- Create a Macro and access the tools to record a macro.
- Record a Macro to reuse formatting across sheets and workbooks by recording formatting features.
- Use Relative References in a macro.
- Run saved macros from the Macros window or by creating a button on a worksheet or on the Quick Access Toolbar.
- Perform basic edits in the Visual Basic Editor and add code from a shared macro.
Who it's for
Excel users ready to automate.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.