Excel - Build Muscle with Macros

This class is only available as part of a 12‑month Educate 360 Pro Subscription

Learn more about Educate 360 Pro >

Duration
0.3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

Learn how to use Macros to automate repetitive tasks and gain control of your data. Create and run macros with coding in Visual Basic for Applications (VBA).
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Agenda

  • Create a Macro and access the tools to record a macro.
  • Record a Macro to reuse formatting across sheets and workbooks by recording formatting features.
  • Use Relative References in a macro.
  • Run saved macros from the Macros window or by creating a button on a worksheet or on the Quick Access Toolbar.
  • Perform basic edits in the Visual Basic Editor and add code from a shared macro.
 

Upcoming Class Dates and Times

Jul 6
1:00 PM - 2:00 PM
Jul 21
10:00 AM - 11:00 AM
Aug 5
8:00 AM - 9:00 AM
Aug 21
10:00 AM - 11:00 PM
Sep 2
3:00 PM - 4:00 PM
Sep 18
1:00 PM - 2:00 PM
Oct 2
8:00 AM - 9:00 AM
Oct 19
8:00 AM - 9:00 AM
Nov 3
7:00 AM - 8:00 AM
Nov 18
10:00 AM - 11:00 AM
Dec 4
10:00 AM - 11:00 AM
Dec 21
1:00 PM - 2:00 PM
CourseID: 3601956E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons