Create Event
Search results for:
No result found! Try with different keywords!
Advertisement
16 Hours Only Microsoft Excel VBA Training Course in Newark

16 Hours Only Microsoft Excel VBA Training Course in Newark

Tue Jan 26, 2021

16 Hours Only Microsoft Excel VBA Training Course in Newark

Time Tue Jan 26 2021 at 10:30 am to 12:30 pm

(add to calendar)

IT Training Center, Tech Training Solutions, Newark, United States

USD 450
Find Tickets on eventbrite.com
Advertisement

16 Hours Only Microsoft Excel VBA Training Course in Newark, 26 January | Event in Newark | AllEvents.in 16 Hours Only Microsoft Excel VBA Training Course in Newark
16 Hours Only Microsoft Excel VBA Training is a Instructor-led, guided training being delivered: January 26, 2021 - February 18, 2021.

About this Event

This event has been UPDATED since it was first published. View the UPDATED & Detailed Microsoft Excel VBA Training course for beginners Information here.

16 Hours Microsoft Excel VBA training is a 4 weeks long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per week, 2 hours per session.

  • The medium of instruction is English.
  • All Published Ticket Prices are in US Dollars.


16 Hours Only Microsoft Excel VBA Training Course Schedule
  • January 26, 2021 - February 18, 2021 US Pacific time
  • 16 Hours | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time
  • 7:30 AM - 9:30 AM US Pacific time each of those days
  • Please click here to add your city name and check your local date and time for the first session to be held on January 26, 2021 at 7.30 AM US Pacific Time.


Features and Benefits
  • 4 weeks, 8 sessions, 16 hours of total Instructor-led and guided training
  • Training material, instructor handouts and access to useful resources on the cloud provided
  • Practical Hands-on Lab exercises provided
  • Actual code and scripts provided
  • Real-life Scenarios


What you will learn?

VBA (Visual Basic for Applications) is a programming interface for Excel. With VBA you will be able to automate tasks and even control other Microsoft Office applications such as MS Access and MS PowerPoint.



Who should attend

Students who want to learn how to automate repetitive, manual, redundant tasks,develop self-running, models and spreadsheets. Students should have working knowledge of Excel.



Course Outline

1. Learn about Macros

  • How to record a Simple Macro
  • How to record a Macro
  • How to run a Macro

2. Understanding VB Editor

  • Use the Menu Bar
  • Use the Standard Toolbar
  • Use the Project Explorer
  • Use the Properties Window
  • Understand the Code Window
  • Understand Code Window Options
  • Edit Code

3. Getting Help

  • Use .CHM or .HLP Files
  • Close the Visual Basic Editor

3. Working with Objects

  • Understand the Object Browser
  • Understand Objects
  • Understand the Objects Hierarchy
  • Reference Objects

4. Understanding Collections

  • Use the Editing Features
  • Use the Immediate Window
  • Use the Auto List
  • Use Auto Quick Info

5. Working with Variables

  • Understand Variables
  • Declare Variables
  • Understand Data Types
  • Store Values in Variables
  • Store Objects in Variables

6. Creating Procedures and Functions

  • Understanding Procedures
  • How to use the Macro Recorder to Create Sub Procedures
  • How to call Procedures from Procedures
  • How to use Intrinsic Functions
  • How to use Message Boxes
  • How to use Input Boxes

7. Creating Functions

  • Pass Arguments to a Function
  • Work with Conditional Statements
  • Understand Conditional Statements
  • Work with Decision Structures
  • Work with Loop Structures

8. Working with Forms and Controls

  • Understand UserForms
  • Use the Toolbox
  • Work with UserForm Properties
  • Events and Methods
  • Use the Properties Window
  • Understand Controls
  • Work with the Label Control
  • Work with the Text Box Control
  • Work with the Command Button Control
  • Work with the Combo Box Control
  • Work with the Frame Control
  • Work with the Option Button Controls

9. Adding Functionality to Forms

  • Work with Control Appearance
  • Set the Tab Order
  • Populate a Control
  • Add Code to Controls
  • Launch Forms from Procedures

10. Using Pivot Tables

  • Understand Pivot Tables
  • Create Pivot Tables
  • Pivot Table Arguments
  • Add Fields to Pivot Tables

11. Controlling Forms

  • Control Pivot Tables from a Form
  • Control a Form from a Custom Toolbar

12. Understanding Debugging

  • Understand Errors
  • Debug Code
  • Debug Tools
  • Use the Locals Window
  • Use the Watch Window
  • Use Breakpoints






Also check out other Workshops in Newark.

Tickets

Tickets for 16 Hours Only Microsoft Excel VBA Training Course in Newark can be booked here.

Get Tickets

Ticket Information Ticket Price
Early Bird USD 450
General Admission USD 550
Search by related topics in Newark
Event Photos
Hosted by
Nearby Hotels IT Training Center, Tech Training Solutions, Newark, United States
Event details from Report a problem ?

Event Information

Date & Time

Tue Jan 26 2021 at 10:30 am to 12:30 pm
Add to Calendar

Location

IT Training Center, Tech Training Solutions, Newark, United States

Advertisement
Advertisement
Make Your Events Easy to Discover

Create an online presence of your events and make them easy to discover & share with the relevant audience.

Create Events