Excel VBA for Creative Problem Solving (ICAS)

Overview

Save lots of valuable time by automating crucial business tasks on spreadsheets.

This course covers all of the essential skills to confidently code in VBA with exercises that introduce broad problems inspired by situations that you might encounter in the real world. This is also a great springboard for anyone who wishes to learn some coding that creates real impact with your work.

This course uses Microsoft Excel for the live exercises

• Create macros to automate a variety of procedures in Excel
• Implement conditions and constraints to control how the routine works
• Automate Excel's Goal Seek and Solver tools and use numerical techniques to create targeting and optimisation problems
• Create subroutines to interface with the user
• Define your own user-defined functions as bespoke new routines
• Easily solve issues with messy and unwieldy datasets
• Find creative ways of importing numerical data into a central report

Who is this for?

No prior knowledge in programming or exposure to VBA is necessary.This course is for anyone looking to speed up processing in Excel and learn valuable skills in spreadsheet automation to help save them time in the long-term.This course will also be of interest to:Finance professionals

• Accountants
• Junior Accountants
• Auditors

Analysts / Power Users

• Data Analysts
• Application specialists

What will you learn?

• Learn the basic programming structures in VBA
• Automate many essential tasks to help save valuable time
• Discover how to seamlessly import numerical data from multiple sources
• Write your own functions in VBA to create bespoke tools and actions
• Identify the best ways to solve common problems in Excel, helping you towards more effective working
• Confidently start automating your spreadsheets which solve real world problems

Please read the following guidance carefully, which applies only if you are attending this course online:

• In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
• It does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
  • Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors or
  • Use 2 computers, or
  • Use a tablet for the online classroom and a computer for the Excel
• Please note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.