Return to schedule
SHARE

Mastering Excel with VBA

New Call-to-action





Explore Excel from a different dimension through Visual Basic for Applications (VBA) and impress stakeholders with rapid, robust and powerful spreadsheet and financial model solutions. VBA will help you unlock the potential for unlimited functionality in Excel, develop powerful business analysis, save you time through the automation of repetitive tasks and enhance the experience of all users.

Mastering Excel with VBA gives you full access to all the secrets of VBA and will take your Excel skills to new heights.

Key learning

  • Impress stakeholders with rapid, robust and powerful business analysis
  • Automate repetitive tasks for you and your colleagues to save hours of work
  • Use VBA to enhance the user experience of spreadsheet or financial model tasks

What you will take away from this course

  • Unlock the potential of VBA for unlimited functionality
  • Familiarise and get comfortable in the macro environment within Excel
  • Learn how to effectively build VBA macros from original code rather than recording
  • Develop techniques for debugging and reviewing VBA code

Is this programme for you?

Yes, this course is for you if you want to get the skills and confidence to write your own Excel macros using VBA code and expand your analytical skill set beyond standard Excel functionality. Previous course participants include accountants, CPA’s, CFA’s, consultants, managers, analysts and financial model developers.

Course outline

Understand the VBA environment and learn core programming skills

  • Learn where the essential tools are in the Visual Basic Editor (VBE) and explore the use of each
  • Discuss the “object-oriented” programming style in VBA
  • Discover how VBA and Excel interact with one another

Master the building blocks of VBA coding

  • Create and declare variables required within a macro
  • Explore and use various inbuilt objects and syntaxes within VBA
  • Walk-through of recording, reading, and editing your own macro
  • Make your coding cleaner, more efficient, and run faster
  • Learn and understand the various loops within Excel

Automate processes for increased efficiency using VBA

  • Automate the conversion and cleansing of large batches of imported data
  • Learn how to change the form of the data so that it is Excel compliant
  • See how data structure can also be re-arranged via automated processes

Focused Case-Study Exercise: Speedy arrangement of demographic data

Key learning: Save time by automating time consuming processes.

Write a macro that will take a large block of demographic data from a multinational PC vendor into a manageable Excel compliant form. Discuss the ultimate goal of the data to understand how it should be arranged and learn VBA tips and tricks to quickly cleanse and arrange numerical, text and date form data.

Powerful communication and presentation using VBA

  • Accommodate and control user inputs for tailored processes
  • Learn how to test and make processes run smoother through clean code
  • Provide appropriate communicative updates to guide users

Focused Case-Study Exercise: Installing budget information with controls

Key learning: Enhance the user experience of your spreadsheet or model.

Tailor a procedure for entering detailed business unit information for a budgeting process. Learn how to create a step by step procedure, with guidance via messages and prompts to enhance the experience and also importantly control the limits and structure of data received.

Exact analysis using VBA

  • Create powerful numerical optimisation solutions
  • Develop techniques to automate analytical optimisation over multiple scenarios
  • Learn powerful analysis for a range of other situations using same skills

Focused Case-Study Exercise: Assess optimal units of production for a textiles company

Key learning: Run robust and precise data analytics fast.

Build a macro to determine the optimal number of t-shirts a textiles company should produce given known micro and macro constraints and conditions. Extend your skills and assess optimal production levels for multiple alternative scenarios concurrently by combining the optimisation macro and ‘data tables’.

schedule

No dates currently scheduled

have a question?

Please enter your first name.
Please enter your last name.
Please enter your valid email.
Please enter your valid contact number.
Please enter your company
Please select your country
Please enter your enquiry