Excel Macros and VBA

Tom Fragale

Tom Fragale is a computer professional with over 30 years of professional experience. He has extensive experience in consulting and providing custom software solutions. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on ma........

Overview

Don't be afraid of macros - learn how to create and use them. When you find yourself repeating actions in Excel - whether it's a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, and print multiple worksheets once a week, the possibility exists that you can automate t........

Why should you attend?

In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.

Areas Covered in the Session:

Rationale for Using a Macro ? Why?
Frequent Use of Lengthy Command Sequence
Sort/Print/Re-Sort/Print Sequence
Length Data Manipulation Need
Steps Used to Record a Short Macro
Naming the Macro
Assigning a Keystroke Shortcut
Storing the Macro
Avoiding Pitfalls While Recording
How to Run (Play Back, Execute?) a Macro
Keystroke Shortcut; Command
Button in the Quick Access Toolbar
Worksheet Picture or Clipart
Visual Basic
Quick View
Comments and Commands
Editing Code
Viewing Code as You Record a Macro
Using the Step Method to Test a Macro Slowly
Using IF Logic in a Macro to Create Different Actions Based on Changing Conditions

Who can Benefit:

Business owners
CEO's / CFO's / CTO's
Managers of all levels
Administrators
Sales people
Trainers
Bankers
Anybody who uses Excel on a regular basis, and want to be more efficient and productive

Webinar Id: ISSETF004

Training Options

Duration: 75 mins

View Anytime

Ratings:

View Reviews