Macros In Excel - Automated Productivity & Time Savings

Ray Evans
Instructor:
Ray Evans 
Duration: 90 Minutes
Webinar ID: 72184

More Trainings by this Expert

Price Details
Recorded Webinar
$199 One Attendee
$399 Corporate Recorded

Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Overview:

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.

Why should you 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

Who Will Benefit:
  • Banking
  • Financial Planning
  • Business Analysis
  • Economics
  • Investment Advice
  • Bookkeeping
  • Education
  • Small/Medium Business
  • Statistics
  • Consulting
  • Strategic Planning
  • Tourism and Hospitality ,etc


Speaker 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.

Having trained over 120,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.


You Recently Viewed

Subscribe to our Newsletter