Excel Training, Excel VBA Training, Excel Software Design

Introduction to Microsoft Excel VBA Macros
Combined Audience

Introduction to Microsoft Excel VBA Macro Training
Onsite Only

Our Introduction to Microsoft Excel VBA training shows you the basics of how to use Excel VBA to develop useful Microsoft Excel tools.

Our 1-day "hands-on" Excel VBA workshop shows you how to create Excel VBA macros that reduce your repetitive Excel tasks from hours to seconds. Our workshop shows you how to use the VBA language to command common Excel tasks like formatting, copying, pasting, inserting, deleting, sorting, data entry, and data filtering (AutoFilter, Advanced Filter). It also provides a basic review of programming including how to use variables, loops and logic in your code. It also discusses VBA procedure types, how to debug your code, how to perform calculations in your code and the strategy of using logic in programming.

Key Introduction to Microsoft Excel VBA Macros Training Skills You'll Learn

Key Introduction to Microsoft Excel VBA Macros Training Skills You'll Learn
  • What is Excel VBA?
  • How to use the Visual Basic Editor and its debugging tools
  • A complete review of Excel VBA including variables, loops, logic and procedures
  • The principles of how to control any part of Microsoft Excel using VBA
  • How to use VBA to automate time consuming Excel tasks like formatting, inserting, deleting, copying and pasting, sorting, filtering, naming...
  • How to use Excel VBA to perform calculations
  • How to use Microsoft Excel VBA to perform basic data processing tasks on the worksheet
  • How to use the Visual Basic Macro Recorder and interpret its recordings
  • How to link Microsoft

Who Should Take This Introduction to Microsoft Excel VBA Macros Training

Who Should Take This Introduction to Microsoft Excel VBA Macros Training

Select this workshop if you or your group have:

  • Never programmed or just used the macro recorder
  • Not programmed in over a year
  • Programmed but have not used objects before
  • Used Microsoft Excel and know its operational capabilities and its tools
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM

 Introduction to Microsoft Excel VBA Macros Training Workshop Outline

Important: We focus our training on what our customers need. When class begins, we analyze those needs and shift our workshop training outline appropriately. We will stress topics or add topics that our customers want. No two workshops are ever the same with EMAGENIT.


Visual Basic Editor Review

Free Repeats Policy
  • A complete review of the Excel VBA Editor and its windows
  • What is a project, module and a procedure and how are they used in Excel VBA
  • How to use the VBA Editor's debugging tools to correct your computer code

Full Excel VBA Language and Programming Review

  • A complete VBA language review including how to use variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
  • How to write a program in Excel VBA, how to translate your ideas into a program that combines Excel with VBA
  • What are an object, property and method and how do you use them in Excel VBA
  • How to control Microsoft Excel with VBA. In other words how to figure out and actually use the command.command.command VBA syntax
  • What is logic and how to translate your task into logic in your VBA computer code. A complete review of using logic like IF and Select Case in your programs

How to Use Excel VBA to Control Cells, Ranges and Changing Data Size with VBA

  • How to identify and use cells and ranges in your Excel VBA code
  • How to use Excel VBA to copy and paste worksheet data
  • How to use Excel VBA to gather worksheet information, perform calculations and output to a worksheet
  • How to use VBA to control cell and range names
  • How to use VBA to control cell number formats, fonts, alignments, borders and colors
  • How to use Excel VBA to automatically format a resizing table of data on your worksheet
  • How to manipulate a worksheet like deleting, inserting and moving columns, rows and cells

How to Perform Calculations in Excel VBA

  • How to write a calculation in your VBA code
  • How to run VBA functions and worksheet functions in your code
  • The key VBA functions and worksheet functions you should know for your Excel tasks
  • How to analyze dates and times using VBA functions and worksheet functions
  • How to use Excel VBA to automatically map range and cell references

How to Use Excel VBA to Control Workbooks, Worksheets and Key Excel Data Tools

  • How to use beginning VBA to create, open, save and close workbooks
  • How to use Excel VBA to add, move and rename worksheets
  • How to control Excel's filters like Autofilter, Advanced filter and Remove Duplicates using VBA
  • How to use beginning Excel VBA to control the Sort feature, Text-to-Columns feature and grouping features

How to Use VBA Loops and Logic to Process Your Excel Data

  • How to organize your data in properly designed tables on your worksheet
  • How to use VBA loops and logic to process your data on a single worksheet
  • How to display your program results on a different worksheet
  • How to use Excel VBA loops and logic to fill out a table from worksheet data

Additional Information and Signup

Additional Introduction to Microsoft Excel VBA Macros Training Information

  • Duration: 3-days
  • Our workshops cover Excel versions 2007-2016 including Excel for Mac and discuss differences when necessary.

Included in Our Introduction to Microsoft Excel VBA Macros Training

  • Free Repeats
  • 1800+ page manual filled with key Excel strategies, examples and tips
  • Hands-on training
  • Personal questions answered

Training Formats

Onsite Only

Introduction to Microsoft Excel VBA Macros Question Form

Instructions: Please fill in your contact information.

Name:
Company:
Company Web:
Country:
Phone #:
Ext:
e-mail:
Contact me directly by phone

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information (Optional)


Send me on-site workshop information Send me self-study manual information
Send me public seminar workshop information Send me live online webinar information

Privacy Policy



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved