© Blue Pecan Computer Training
Excel
Training
|
|
Excel Advanced Training -
Excel Advanced Training in Portsmouth & Southampton
Course Outline
Introduction to Excel Macros
|
|
Recorded vs written Macros
|
|
|
Creating command macros to automate procedures
|
|
|
Creating custom functions
|
Recording a Macro
|
|
Good practise guidelines for macro creation
|
|
|
Naming conventions
|
|
|
Security options in Excel and the security implications of using Macros
|
|
|
Where to store Macros
|
|
|
Relative vs absolute recording mode
|
|
|
Making simple edits to a recorded macro using VBA
|
Running an Excel Macro
|
|
Assigning shortcut keys to a macro
|
|
|
Running a macro from a button on a worksheet
|
|
|
Creating custom toolbars and toolbar buttons to run your macros
|
|
|
Creating custom menus and menu items to run your macros
|
|
|
Running a macros automatically on a workbook opening/closing
|
Introduction to VBA
|
|
Find your way around the Visual Basic Editor
|
|
|
Creating code for procedures
|
|
|
Using and editing code generated by the macro recorder
|
|
|
Copying code between macros to add functionality to a macro
|
|
|
Joining together macros by calling them from separate procedure
|
|
|
Creating custom functions in VBA
|
|
|
Using custom functions in a workbook
|
|
|
Creating VBA userforms
|
|
|
Making your macros interactive with Message Boxes and Input Boxes
|
|
|
Creating conditional macros with IF structures
|
|
|
Looping code
|