|
|
|
|
COURSE TITLE:
Microsoft Excel VBA Training UK
LEVEL:
Introduction : Intermediate : Advanced
COURSE LENGTH:
1 day
COURSE PRICES:
*All prices quoted exclude VAT
COURSE OVERVIEW:
Microsoft Excel VBA enables you to create more detailed and sophisticated automation functionality in Excel.
Microsoft Excel VBA explores various Excel Add-Ins and unusual worksheet functions. You will understand how and where best to use these features. Excel VBA provides you with the opportunity to combine these features in very effective ways to increase practicality and efficiency in the work environment. Excel VBA is for power-users who require knowledge of more advanced and sophisticated functions to extract or calculate data in alternative ways.
Microsoft Excel VBA - to cover all topics on this course would require 2 days of training.
Use the list below to choose the topics you wish to cover on a one-day course. |
| |
|
The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today. |
Training Modules
Running a macro
Recording a macro
Examining module design
Assigning macros
Specifying the location of recorded macros
Assigning shortcut keys to macros
Assigning macros to menus
Assigning a macro to a button on a sheet
Assigning a macro to a button on a toolbar
Creating decision-making code
The If...Then decision structure
The If...Then...Else decision structure
The Select Case decision structure
Using loop structures
Using a For...Next statement
Using a Do...Loop statement
Using a For Each...Next statement
User-defined functions and variables
Creating user-defined functions
Using variables
Interactive macros
Creating a custom message box
Creating a custom input box
Previewing custom dialog boxes
Debugging and testing code
Overview of debugging
Stepping through the code
Using Watch Expressions
Macro management
Personal Macro Workbook
Assigning Sub procedures to run automatically
Programming basics
Coding
Variables
Procedures
Error handling
Naming conventions
Statistical Functions
Frequency
Large
Intercept
Slope
GCD
Mode
Median
Quartile
StDev
AveDev
|
Training Modules
Add-Ins:
Locating & Installing
Using the Analysis Toolpak
Histogram
Regression Analysis
Moving Average
Rank & Percentile
What-If Analysis Tools:
Solver
Build models to calculate optimal value for a formula in one cell
Adjust values in specific changing cells to produce results specified from the target cell formula
Apply constraints to restrict the values Solver can use in the model
Array Formulae
Understanding Arrays
Pro's & Con's for using Arrays
Counting Unique Numeric Values
Using Arrays instead of SumIf or CountIf
Text Functions
Clean
Trim
Left
Right
Mid
Find
Len
Concatenate
Upper
Lower
Proper
Indirect
Database & Lookup Functions
Dsum
Daverage
Dmax
Dmin
Dcount
Dget
Match
Index
Pivot Table Report
GetPivotData Function
Consolidating Data for Reports
Date & Time Functions
NetWorkDays
EDate
EOMonth
|
|
|
BACK TO TOP |
|
|
|
"I would just like to say how pleased we were with the way in which ABC Dee Training handled our training requirements....." Vicky Farrow, Kent Fire & Rescue
"My experience with this company has been a positive one and
I would happily recommend ABC Dee Training to others."
Anna Faithfull, London Film
|
| |
