This session is a springboard for new users to get to grips with Excel, but also provides positive tips and tricks for experienced users. It is a hands-on review of essential Excel techniques with focus on best practice and time-saving strategies, laying the groundwork for many of the subsequent modelling techniques a user is likely to encounter.
Excel Macros and Automation
This session begins by introducing the concept of macros, an essential aid to the automation to repetitive spreadsheet tasks. The second part of the module will explore some of the key areas of the Visual Basic Editor and explore some VBA editing practices.
Excel Logical, Lookup and Reference Functions
This session is designed for Excel users who need to extend their confidence when building and nesting formulas. The session will explore some of the more advanced decision making and look up functions in Excel that are vital for many spreadsheet models.
Excel Managing and Analysing Datalists
This session is designed for users who need to manipulate and analyse large amounts of data within their spreadsheet models whether it be within a single worksheet or across multiple worksheets.