| Excel Module 4 - Advanced Formulas and Functions |
| This course is designed for experienced users of Excel who want to develop their skills in writing formulas and using advanced Excel functions. Delegates should be confident Excel users and should be able to write basic formulas and functions. |
 |
| Excel Module 5 - Advanced Data Management |
| This course is designed for experienced users of Excel who would like to utilise the Advanced Data Management features of Excel such as conditional linking, connecting to external data sources, sharing workbooks and what if analysis |
|
| VBA in Excel - Part 1 |
| The course aims to help users write their own code to manipulate data on worksheets, code user forms and automatically run code when events occur. For experienced users of Excel although previous programming experience would be an advantage. |
|
| VBA in Excel - Part 2 |
| This course is designed as a follow-on from the VBA in Excel Part 1 and is designed for users who are already writing VBA code. The course looks at writing search routines, manipulating data, connecting to other applications and advanced form design |
|
|
|
