Recording Macros

Automate tasks


Overview

What does the course cover?

This course focuses on how to record and re-use Macros in Excel without programming skills. You’ll learn to work in Excel’s Developer Tab and learn where macros are stored. You look at the differences between absolute and relative macros and how to move macros between workbooks.

Aims

Why take this course?

This course will help you learn how to work with and manipulate Macros recorded in Excel. It will introduce you to the VBA Development environment to make basic alterations to recorded Macros. The course also provides examples of useful recorded Macros.

Audience

Who should attend?

If you are an extensive user of Excel, have completed Excel Level 3 – Advanced, and use the programme daily for completing repetitive tasks, then this course is ideal for you. Completing this course will save you many hours at work through the automation of tasks.


Course preview

Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.


Live demo’s

Downloadable files

Real-world templates

Course detail and sample lessons

Recording Macros in Excel

Lesson 1: Introduction
View Demo
Lesson 2: Opening the Developer Tab
View Demo
Lesson 3: Running an existing macro
Demo Not Available
Lesson 4: Record a macro to this workbook
Demo Not Available
Lesson 5: Saving a workbook that holds a macro
Demo Not Available
Lesson 6: Abolute and relative macros
Demo Not Available
Lesson 7: Step into an existing macro
Demo Not Available
Lesson 8: Copying a Macro from one workbook to another
Demo Not Available
Lesson 9: Deleting a macro from this workbook
Demo Not Available
Lesson 10: Record a macro to the Personal Macro Workbook
Demo Not Available
Lesson 11: Deleting a macro from the personal macro workbook
Demo Not Available
Lesson 12: Assigning a macro to a button on the sheet
Demo Not Available
Lesson 13: Assigning a macro to an icon on a ribbon
Demo Not Available
Lesson 14: Creating your own tab and ribbon
Demo Not Available


Skills you’ll learn

What you’ll be able to do after the course

  • Work within the Excel developer environment
  • Run and record existing macros
  • Create a custom tabs within the ribbon
  • Move macros between different workbooks
  • Debug a macro using step/walk tools
  • Understand security settings for macros
  • Understand the different between absolute / relative macros

How you can apply these skills

What you’ll be able to use these skills for

  • To speed up repetitive tasks
  • Learn how existing macros work
  • Customise the Excel environment
  • Create menus and easy navigation within Excel
  • Copy macros between workbooks
  • Create a custom menu in Excel
  • Learn from existing pre-recorded macros

Certification

When you pass you will receive an internationally recognised accreditation certificate like this:

Excel_Apprentice_Certificate


What’s next?

Upon completion if you would like to learn more about Macros and programming Excel – our Excel VBA course will build on these foundations. In addition our course on Excel Structure and Design and Excel Safety and Security will also be of interest.


Careers that require these skills at this level?

Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.


Want to start learning today?

Joining is simple, easy and risk free with our 7 day money back guarantee.