Automating Excel with Macros
PDF Add to WishList
Enhance your existing knowledge of Excel with the power of macros. In this training course, you gain experience creating, modifying, and enhancing macros to automate repetitive Excel-related tasks. You also learn how to troubleshoot code errors in existing macros, log data changes into multiple tables, implement code from the web, and design simple user interfaces to vastly improve your productivity.
You Will Learn How To
- Develop macros to automate repetitive workbook processes
- Translate statements from Visual Basic for Applications into Excel actions
- Debug code in the Visual Basic Editor
- Modify code so that it can refer to dynamic ranges
Important Course Information
Requirements:
- Knowledge of Excel at the level of:
- Course 1361, Microsoft Excel Introduction
Recommended Experience:
- Experience at the level of:
- Course 195, Power Excel: Analyzing Data to Make Business Decision
Software:
- This course is applicable to all versions of Excel, from Excel 97 to Excel 2016
Hands-On Experience
- Creating, modifying and enhancing macros
- Troubleshooting code errors in existing macros
- Logging data changes into multiples tables
- Implementing code from the web, and more ...
Convenient Ways to Attend This Instructor-Led Course
Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
Live, Online
Private Team Training
Live, Online Instructor-Led
Tuition — Standard: $640 Government: $570
Aug 9
(1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Reserve Your Seat
Oct 10
(1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Reserve Your Seat
Nov 28
(1 Day)
9:00 AM - 4:30 PM EST
Online (AnyWare)
Reserve Your Seat
Feb 5
(1 Day)
9:00 AM - 4:30 PM EST
Online (AnyWare)
Reserve Your Seat
Apr 2
(1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.Private Team Training
Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click here »
Tuition
Standard
Government
In Classroom or
Online
Standard
$640
Government
$570
Private Team Training
Course Tuition Includes:
Training Hours
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
Enhance Your Credentials with Professional Certification
Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.
Earn 6 PDUs
PMI, the Registered Education Provider logo, PMP, CAPM, PMI-ACP,
and PMBOK are marks of the Project Management Institute, Inc.
This course is approved by PMI® for 6 professional development units (PDUs). For more on the Project Management Institute and a full list of courses approved for PDUs.
Technical : 6 PDUs