Microsoft Excel 2016 VBA Training Course
Microsoft Excel 2016 VBA Training
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the level that you’re interested in
Microsoft Excel 2016 VBA
This course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using macros and VBA.
You must be proficient with Excel and understand key concepts of spreadsheets, or equivalent to our advanced course level.
This is a 2 day MS Excel VBA Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Our Microsoft Excel VBA course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
This course is £ 725 per day + VAT for up to 8 people.
Excel 2016 VBA Course Outline
THE CONCEPT, RECORD AND RUN MACROS & THE VB ENVIRONMENT
The Project Window
Navigating between Excel and the VB Editor Editing Code + Methods of Executing
Using the Visual Basic Editor
Structure of a sub routine
Navigate a Module
Edit a module
Use of Function Keys
Run subroutines together
Menu, Visual Basic Toolbar, Keyboard Shortcut, Custom Toolbar Button, Custom
Menu Item, Forms Toolbar executing Visual Basic Language Rules
Theory of Object
Properties and Methods
Object Model Hierarchy
Inheritance Control Structures
IF, Nested IF
AND OR NOT
Distribution, Watch Pane
Step through Functions using the immediate Window
For Next Loops
For Each Next Loops Interactive Macros
Using a Msgbox
Use a Conditional Message Box
Use the Inputbox
CREATE INTERACTIVE FORMS
Build Form Controls
Build User forms
Use of the Properties Window
Built in Dialog Boxes
Create Custom Menus
Create Custom Toolbars
What are Event Procedures?
On Open event
Before Close event
On Activate event
On Deactivate event
On Key event
On Time Event Security
Protect/lock code for view/edit
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.