|
Microsoft Excel level 1
Main subjects:
Create simple formulas -
Mathematical structures -
Edit formulas -
Referencing techniques -
Sort and Filter data - Creating simple graphs -
Printing techniques - Using
Excel shortcuts -
Building confidence
Note: This course has been designed for those
new to Excel and regular Excel users with no formal training.
Microsoft Excel level 2
Main subjects:
Conditional Formatting techniques -
Managing data -
Manipulating data -
Complex Filtering -
Subtotal techniques -
Using Pivot Tables -
Range names -
IF functions -
VLOOKUP functions - More complex graphs - More shortcuts -
Building confidence
Note: The main theme is to manage and analyse
data; use more complex business formulas and build on level 1
topics.
Microsoft Excel level 3
Main subjects:
Protection techniques -
Validation of data -
Auditing data -
Analyse data -
Create an interactive form -
Formulas to manipulate data -
What If analysis with Goal Seek, Solver, Scenario - Simple
Macro's for the user -
Import and Export data
Note: This course will build on techniques
developed during level 2 training and will give a broader
understanding of Excel functionality useful in a business
environment.
Microsoft Excel VBA level 1
Main subjects:
Recording, running Macros -
Assigning Macro's -
Edit Macro's in VBA -
Objects, Properties -
Methods, Events -
Procedures and Classes - Workbook and worksheets -
Custom & Built in Forms -
Handling errors in VBA
Note: The two day Excel VBA course is aimed at
those wanting a thorough understanding of the Excel VBA
programming environment.
Creating and Editing Macro's.
Microsoft Excel VBA level 2
Main subjects:
Error trapping and case statement - Variables - Data from Word -
Controls dialogue boxes and forms - Toolbars and Display -
Calendar control - Customizing the environment - Using VBA
references - Run time applications and add-ins - Access VBA -
Build a function library - Class modules.
Note:
The two day Excel VBA advanced course is
aimed at those wanting a more in-depth understanding of Excel
VBA.
|
