Microsoft Excel - Recording Macros
What you'll learn
- 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.
Requirements
- Advanced knowledge of Excel
Description
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.
Who this course is for:
- 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 content
- Preview00:46
- Preview02:02
- Preview01:51
- Preview04:14
- Preview02:17
- 03:41Abolute and relative macros
- 03:11Step into an existing macro
- 03:32Copying a Macro from one workbook to anothe
- 01:02Deleting a macro from this workbook
- 04:23Record a macro to the Personal Macro Workbook
- 03:30Deleting a macro from the personal macro workbook
- 03:48Assigning a macro to a button on the sheet
- 04:09Assigning a macro to an icon on a ribbon
- 05:08Creating your own tab and ribbon
Instructor
![eLearnExcel](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 319 Reviews
- 2,132 Students
- 6 Courses
Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.
Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.