Description
Overview
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 highly valued 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.
Why should you attend ?
- Work smarter, faster and more effectively
- Boost profit, efficiency, and productivity
- Improve job satisfaction, team performance, and professionalism
- Gain strong competitive advantage at peer and business level
- Achieve more in less time with higher quality results.
- Strengthen your resume and case for increased salary
- Understand the latest and most relevant MS Office functions available
Areas Covered in the Session
- Overview
- Macro essentials before you start
- Enable and explore the Developer tab
- Understand Code group commands on the Developer Ribbon
- Macro settings
- Set macro security
- Demonstration of Debug and “Step into” process
- Watch a macro run on code – line by line
- Save a file as macro enabled
- Record and run a relative macro
- Explore and edit macro code
- Assign a keyboard shortcut key to a macro
- Delete / copy macros
- Macros with absolute cell references
- Personal macro workbook for global macros
- Create a new ribbon tab and group for macro “run” buttuns
- Assign a macro to run from the ribbon
- Keyboard shortcuts – Excel, general & web browser
- NOTE: Topic sequence may be subject to slight variation
Who will benefit
- Private
- Public and Academic Sector Staff
- Managers & Executives or
- Anyone seeking to maximize their investment in Microsoft Office Applications.
- Account Executive
- Accountant
- Auditor
- Bookkeeper
- Business Owner
- Chief Executive
- Controller
- CPA
- Cybersecurity staff
- Database Administrator (DBA)
- Educator
- Trainer
- Engineer
- Financial Analyst
- Human Resource Personnel
- IT Professional
- Manager
- Marketer
- New recruit
- Project Manager
- Social Media Specialist
- Staff at all levels
- Supervisor
Instructor Profile
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.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
