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 would benefit?
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 video lessons, downloadable exercise files and real-world templates for you to use.
Course Details
Recording Macros
- Lesson 1: Macros Intro
- Lesson 2: Opening The Developer Tab
- Lesson 3: Running An Existing Macro
- Lesson 4: Record A Macro To This Workbook
- Lesson 5: Saving A Workbook That Holds A Macro
- Lesson 6: Absolute And Relative Macros
- Lesson 7: Edit An Existing Macro
- Lesson 8: Copying A Macro From One Workbook To Another
- Lesson 9: Deleting A Macro From This Workbook
- Lesson 10: Record A Macro To The Personal Macro Workbook
- Lesson 11: Deleting A Macro From The Personal Macro Workbook
- Lesson 12: Assigning A Macro To A Button On The Sheet
- Lesson 13: Assigning A Macro To An Icon On The Quick Access Toolbar
- Lesson 14: Creating Your Own Tab And Ribbon
- Lesson 15: Macro Security
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 recognized accreditation certificate like this:
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.
