Templates, Macros and Controls - SS11

General Description

Automate, secure and extend the functionality of spreadsheets and spreadsheet production by utilising Microsoft Excel's programming and design features.

Target Audience

This session is intended for participants wishing to improve on their existing basic working knowledge of Microsoft Excel.

Pre-requisites

Participants should be able to use standard features of Microsoft Excel including how to use some of the more complex features such as using functions and formulas.

Duration

3 hours

Learning Outcomes

• Create and modify a template
• Format worksheets and workbooks that can be used flexibly in various situations
• Design and work with Microsoft Excel spreadsheet templates
• Record macros
• Run and edit recorded macros
• Create and customise toolbars to quickly access macros
• Create and apply controls to a worksheet
• Integrate spreadsheet formulae with control functions