This course will explore how to automate Excel tasks with macros. We will cover
recording, running, and editing both basic and relative reference macros. Information on
assigning a keyboard shortcut to a macro and managing macro security is also included.
Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic
Editor, declaring variables, iterating over a range, prompting for user input, and using
conditional (If…Then…Else) statements.
Related Products
-
Advanced Skills for the Practical Trainer
$139.99To begin, you will explore the trainer’s role and what skills and competencies trainers should have. Then you will learn about the learning process and different learning styles, and apply that knowledge to designing programs and motivating learners. You will also learn ways to manage the stress of training, plan a workshop, and lead a training session. Then, you will learn techniques for dealing with difficult participants, evaluating learning, and conducting on-the-job follow-up. Alternative training methods, such as eLearning, co-facilitation, and team teaching will also be covered. -
Building Better Teams
$139.99In this course, you will learn what forms teams can take. You’ll also evaluate your team player type, learn ways to build an effective team, and identify things that you can do to become a good team player.
