Live Online - Microsoft Excel Recording Macros & Templates, This is an Online Training course delivered via the web using industry leading software, Thursday, 11. June 2020

You’re already working with Excel, but you want to save time and headaches by automating repetitive tasks. Why not join us for an Online, ½ day, interactive training session. We will get you working with macros and show you tips and shortcuts often overlooked by those who are self-taught.
The good news is that you don’t have to be a programmer to get started with Excel Macros. Using the macro recorder will help you on your way, and you will be amazed at how useful it can be. Once you are feeling more comfortable with macros we will set up some templates to standardise your layout and formatting. You can even incorporate your macros into these templates.
This is an advanced level course.
What you get

Class size kept to a maximum of 10 participants.
Average class is 4-6 people.
Qualified, experienced and approachable facilitators.
Training materials and take away practice files.
Lifetime post course support.

Need to Learn more about Live Online Training.
 
Microsoft Excel Recording Macros and Templates Course Content





Recording Macros

Preparing Excel for Recording
Recording Macros
Storing Macros
Adding Comments
Testing Macros

Absolute vs Relative Macros

Absolute and Relative Recording
Testing types of Recording
Viewing and Editing Macros











Buttons and Triggers

Adding Buttons to Worksheets
Adding Buttons to the Quick Access Toolbar

Macros for PivotTables

Creating Macros for PivotTable Work

Building Templates

Building a Template
Storing Templates
Editing Templates


If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.
See here for terms and conditions.





Live Online - Microsoft Excel Recording Macros & Templates

Find more events around you
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now