Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 06th May'25 to 16th May'25
Macros in Excel – Automated Productivity & Time Savings
- 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 shortcut to a macro
- Delete a macro
- Copy a macro
Overview of the webinar
Excel macros can automate and streamline tasks, eliminate repetition, and can potentially save you and your team thousands of hours year after year.
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 a clear explanation and demonstration of key principles to ensure your practical understanding.
This presentation will effectively help you understand and apply this powerful tool.
NOTE: To maximize knowledge retention, this webinar includes a professional step-by-step Learner Guide, exercise files, demonstrations, and practice exercises.
Who should attend?
- A diverse range of professions including accounting, banking, financial planning, business analysis, economics, investment advice, bookkeeping, education, small/medium business, statistics, consulting, strategic planning, tourism, and hospitality, etc;
- Private, public and academic sector staff, managers & executives, or anyone seeking to maximize their investment in MS Office to confidently use each relevant MS Office application to:
- Accurately manage and present data, financial statements, charts, and business-critical information;
- Effectively use and manage email, appointments, and meetings;
- Produce engaging presentations for sales, marketing, staff updates and training, etc;
- Create professional, fully referenced, clear, and concise documents, reports, and publications;
- Plan, manage, track and finalize projects efficiently;
- Design, update and manage database tables, forms, queries, and reports.
Why should you attend?
- A diverse range of professions including accounting, banking, financial planning, business analysis, economics, investment advice, bookkeeping, education, small/medium business, statistics, consulting, strategic planning, tourism and hospitality, etc;
- Private, public and academic sector staff, managers & executives, or anyone seeking to maximize their investment in MS Office to confidently use each relevant MS Office application.
Faculty - Mr.Ray Evans
Ray’s 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 an 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.
Having trained over 30,000 students, business owners and executives since 1990 and authored a wide range of training and procedural documentation, complex reports and engaging internet content, Ray has demonstrated strong ability in key communication styles and knowledge transfer.