Advanced Excel Macros and VBA Programming
To elevate delegates programming skills to a professional level.
Microsoft Excel 2010 MACROS/VBA Coding
This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.
Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.
This course is quite heavy formula based introducing Ifs, vlookups and linking data between sheets, also you will look at working with large amounts of data helping to sort, filer and hide data.
Work effectively with Excel learning shortcuts, quick and clever ways to enter data saving time. Understand and create basic formulas and charts.
Book hourly slots throughout the day, half a day or full day workshops to look at any specific areas in Excel you feel you need guidance with, the most popular sessions are for Pivot Tables, Vlookups and Macros.
Intermediate Excel Macros and VBA Programming
To explore further the object techniques available in the VBA programming language, focussing on best practices and efficiency of coding.