Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Recording Macros in Excel|
This section includes the exercise files for Excel Macros. Please download these before you start the course.
Opening the Developer TabPreview
Running an existing macroPreview
Record a macro to this workbookPreview
Saving a workbook that holds a macroPreview
Abolute and relative macros
Step into an existing macro
Copying a Macro from one workbook to anothe
Deleting a macro from this workbook
Record a macro to the Personal Macro Workbook
Deleting a macro from the personal macro workbook
Assigning a macro to a button on the sheet
Assigning a macro to an icon on a ribbon
Creating your own tab and ribbon
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.