Excel 2016: Macros in Depth

Introduction

• Welcome
• Using the exercise files

1. Getting Started

• Identifying applicable situations for using macros
• Recognizing the need for single-action and multi-action macros
• Understanding security
• Short examples of the recording method
• Overview of other techniques

2. Running a Macro

• Running a macro from the Developer or View tab
• Running a macro from the Quick Access Toolbar
• Running a macro from a keystroke shortcut
• Running a macro from an object or picture

3. Using VBA

• The VBA window and VBA components
• Creating the Personal Macro Workbook
• Closing and updating the Personal Macro Workbook

4. Recording a Macro in Stages

• Recording a simple macro
• Expanding a macro with the If statement

5. Creating Nonrecordable VBA Code

• Absolute or relative references
• For…Next statements to repeat actions
• Do While and Do Until statements to repeat actions
• Creating interactive macros

6. Macro Project: Converting a Mailing List into a Database List

• Planning a macro
• Recording partial code
• Using loop structures in context
• Testing a macro in Step mode with a split screen
• Pulling the data together
• Joining two macros
• Streamlining macros

Conclusion

• Goodbye