Excel VBA Workshop

5k learners

Microsoft Excel is an essential, ubiquitous tool that's used everywhere from mom-and-pop stores to Fortune 500 heavyweights. Professionals across industries use Excel on a daily basis as an integral part of their job role.

 

  • Hands-on Workshop

  • 6-hour bootcamp training

USD 300
Show Batches

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

Although we use Excel every day, day after day, how many of us can honestly say that they know more than just the basics of this tremendously powerful software? Do you really know how that pretty-looking sales dashboard has been created?

This is just what we aim to solve through this Excel workshop VBA. Excel VBA is a powerful tool that enables the automation of tasks in Excel. And given the current economic scenario, we believe that sharpening your Excel skills in addition to your core work skills could mean the difference between having a job or having to look for one. This is especially true for people in Mid-level management positions…

Course Outline

Create a Macro with the Macro Recorder
Edit a Macro
Debug a Macro
Different ways of running a Macro
The Project Explorer
Properties
Object Viewer
Properties
Methods
Objects
Subroutines
Immediate Window
Watch Window
Create User-defined Functions
Automate SUM Functions
Simple Message Boxes
Message boxes that return values
Buttons and icons
Input Boxes
Declaring Variables
Using Variables
Watching Variables
Conditional Statements
Decision Structures
Select Case
For next loops
Do While
Do Until
Understanding error handling
Understanding VBA's error trapping options
Trapping errors with the on error statement
Understanding the error object
Writing an error-handling routine
Working with inline error handling
Defining errors
Working with debugging tools
Determining breakpoints
How to step through code
Working with break mode during run mode
Identifying the value of expressions
Placing controls
Aligning Controls
Properties
View all
View less

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Trainers

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements

PMI
IASSC
axelos
itil
PRINCE2
Microsoft
Workshop by location
DISCLAIMER

Disclaimer

PMI®, PMBOK®, PMP® and PMI-ACP® are registered marks of the Project Management Institute, Inc.

The Swirl logo™ is a trade mark of AXELOS Limited.

ITIL® is a registered trade mark of AXELOS Limited. Used under license of AXELOS Limited. All rights reserved.

PRINCE2® is a registered trade mark of AXELOS Limited. Used under license of AXELOS Limited. All rights reserved.

IASSC® is a registered trade mark of International Association for Six Sigma Certification.

Certified ScrumMaster® (CSM) is a registered trade mark of SCRUM ALLIANCE®

CISSP® is a registered mark of The International Information Systems Security Certification Consortium (ISC)2.

CCNA® is a trademark of Cisco.

Microsoft and MS Project are the registered trademarks of the Microsoft Corporation.

SAP Trademark(s) is/are the trademark(s) or registered trademark(s) of SAP SE in Germany.
|
United States