Social Media

FacebookTwitterLinkedIn

Feedback

Here is what some of our previous delegates have said!

"Very helpful, kept it at the pace I found it easiest to work through. Brilliant "

White Line Break

"I Should have done this years ago - John made it really easy to understand. I had one to one coaching and now - Dashboards here I come!!!"

White Line Break

"John was really great. Made everyone feel at ease."

White Line Break

"Really enjoyed the course and learned loads. Can't wait to get back to work and try it out."

White Line Break

Macros in Excel – Explained

Next Webinar May. 14th 12:00 FULL! Sorry

Text me 07939 083648 for the next availability.

Who is it for ?

Have you ever wondered how to setup a macro in Excel?. This one hour session will guide you through the steps and have you setting up your own macros in no time. Particularly useful if you want to speed up your Excel work.

What is it about?

Starting with the basics John will guide you through recording a first macro. You will discover how to view and edit code in the VBA window. Then you will learn how to create buttons to run your new macros. Then download the practice file and run-through your new found skills.

Places strictly limited

Overview

Getting going with Macros
• The Developer Tab.
• Starting and stopping the recorder
• •Use the macro recorder to create a variety of macros
Beyond the Basics
• Viewing the code in the code window
• Working with Absolute References
• Relative referencing
• Some useful examples

Running your macros
• Creating Buttons on the Sheet to run your macros
• Running your macros from Icons on the Quick Access Toolbar

Tackling a project
• Where to Start
• Adding Remarks to your code
• Joining your code in the code window.
• Debugging your code
Forms controls
• Forms versus Active X Controls
• Adding Forms controls to a spreadsheet
• Format Controls
What’s Next
• Tips for Success
• Download the Workbook
• Download the Practice file
• Q & A

Book Now!