Print Friendly, PDF & Email

COURSE OVERVIEW

Using Macros and VBA in Excel can help you dramatically improve the usability and efficiency of your spreadsheets. While formulas and functions are great tools, macros takes things to a whole new level particularly for repetitive tasks and regular reports.

Learn how you can transform your excel spreadsheets by attending our course called Macros and VBA for Excel: Unleash the Power in your PC.

The course includes the following key topics:

TOPICS

  • Automating tasks that you perform frequently such as

– Formatting
– Reporting
– Data extraction from multiple sheets

  • Creating buttons and customising toolbars
  • Using the Excel Macro recorder
  • Understanding the limitations of the macro recorder
  • Editing, Debugging and Running Macros
  • Understanding VBA
  • Understanding the Visual Basic editor
  • Create a macro by using VBA
  • Learn about Macro Security
  • Utilise Multiple Worksheets with ease
  • Create User Defined Functions
  • VBA Programming Concepts including Projects, Modules, Objects and Methods
  • Using debugging tools on recorded cod

And much more!

WHO SHOULD ATTEND

  • Finance Personnel and managers
  • Data administrators, professionals and managers
  • Project managers and Engineers Analysts
  • Anyone working extensively with Microsoft Excel
  • Attendees should have a reasonable working knowledge of MS Excel

OUTCOMES

  • Learn how to automate tasks in Excel
  • Understand the difference between macro recording and VBA and when to use which
  • Understand how to do simple VBA programming
  • Dramatically improve efficiencies in the office relating to Excel
  • Apply your knowledge of Macros to other MS Office Products such as Word and PowerPoint

TRAINING CHANNELS:

Choose your preferred training type/method of delivery below.

IN-HOUSE TRAINING

We come to you!

Enquire

ON DEMAND TRAINING

Flexible Training: No minimum delegates. Your Date. Your Duration. Face to Face or Online.

Enquire