To gain a practical “hands-on” understanding of how to efficiently create, manage and run Macros in Excel.
KEY TAKE AWAY: Excel macros can automate and streamline tasks, eliminate repetition and can potentially save you and your team thousands of hours year after year.
Harness this valuable feature in Excel to boost your efficiency, output and job satisfaction.
Working with macros is not intuitive and requires clear explanation and demonstration of key principles to ensure your practical understanding.
This presentation will effectively help you understand and apply this powerful tool.
KEY TAKE AWAY: Excel macros can automate and streamline tasks, eliminate repetition and can potentially save you and your team thousands of hours year after year.
Why you should Attend:
A macro is a term for a series of commands and functions that you store in a Microsoft Visual Basic module and can be run via your keyboard, ribbon or custom buttons whenever you need to perform the task(s) associated with those commands.Harness this valuable feature in Excel to boost your efficiency, output and job satisfaction.
Working with macros is not intuitive and requires clear explanation and demonstration of key principles to ensure your practical understanding.
This presentation will effectively help you understand and apply this powerful tool.
KEY WORDS:
- Macro
- Security
- Macro-Enabled
- Record
- Run
- Relative absolute cell references
- Code
- Assign ribbon
- Keyboard shortcut
- Delete
- Copy
Areas Covered in the Session:
- Understand Excel macro essentials
- Set macro security
- Save a file as macro enabled
- Record a simple macro
- Run a macro
- Apply relative and absolute cell references
- View and edit macro code
- Assign a macro to the ribbon
- Assign a keyboard short cut to a macro
- Delete a macro
- Copy a macro
Speaker
Ray Evans professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
Who Should Attend
- Banking
- Financial Planning
- Business Analysis
- Economics
- Investment Advice
- Bookkeeping
- Education
- Small/Medium Business
- Statistics
- Consulting
- Strategic Planning
- Tourism and Hospitality ,etc