Mastering Macros in Microsoft Excel 2017

Topics

• Steps Used to Record a Short Macro
  • Assigning a Keystroke Shortcut
  • Naming the Macro
  • Avoiding Pitfalls While Recording
  • Storing the Macro
• Rationale for Using a Macro - Why?
  • Sort/Print/Re-Sort/Print Sequence
  • Frequent Use of Lengthy Command Sequence
  • Length Data Manipulation Need
• Visual Basic
  • Comments and Commands
  • Quick View
  • Viewing Code as You Record a Macro
  • Editing Code
• How to Run (Play Back, Execute…) a Macro
  • Button in the Quick Access Toolbar
  • Keystroke Shortcut; Command
  • Worksheet Picture or Clipart

Who should Attend

• CEO`s / CFO`s / CTO`s
• Business owners
• Anybody with large amounts of data
• Managers of all levels
• Accountants
• Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive
• Controllers
• CPAs
• IT Professionals
• Financial Consultants
• Human Resource Personnel
• Auditors
• Marketers
• Bookkeepers