Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools

Automating MS Excel with
Macros and VBA Programming

LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

Macros and VBA Programming

This training contains the essential of VBA knowledge.  It prepares the user to explore more advanced techniques in VBA. There will be several exercises to apply the new skills learned every chapter.

Participants will be able to automate reports to improve efficiency, lessen errors, and lessen the impact to productivity when a skilled person resigns.

Part 1. Macro Recording
  • Creating Macros
  • Exploring Macro Security
  • Recording and Running a Macro
  • Using Relative Reference
  • Assigning a Macro to Buttons
  • Using Macro Recording to Create VBA Codes


Part 2. Introduction to VBA
  • Exploring the VBA Interface (Overview)
  • VBA Terminologies
  • Exploring the Properties Window
  • Exploring the Code Window


Part 3. Programming Basics
  • Essential VBA Codes
  • Different Ways of Calling Cells
  • Creating Basic Modules
  • Objects, Properties, and Actions
  • Modifying Objects with Properties (e.g. OFFSET)
  • Common Mistakes when Coding
  • Dealing with Rows, Columns, and Sheets
  • Coding Common Tasks in Excel


Part 4. Logical and Loop Control Structures
  • Applying Decision Structures
    • If, Then, Else Statement
    • If, Then, ElseIf Statement
  • Solving Repetitive Tasks with Loop Structures
    • For, Next Loop
    • For Each, Next Loop
    • Do Until, Loop
  • Applying Control Structures in Excel Programs


Part 5. More VBA Functions
  • Using IF to Create Functions
  • User-Defined Functions
  • Using MS Excel Functions in VBA


Part 6. Creating Userforms and Userform Events
  • Adding UserForms
  • Adding Form Elements
  • Coding Common Tasks Involving Forms (e.g. Search, Add Data, etc.)


Part 7. Designating Actions When Errors are Encountered


Part 8. Creative Automation Exercises in VBA


Related Courses

Advanced MS Excel

MS PowerBI for Beginners

​
Excel for Data Analytics
Download Outline
Find Public Class
Send Email

Home

Courses

Public Classes

Contact

Copyright © 2022