- Learn to improve the application of Excel spreadsheets
- Save time by using efficient spreadsheets in a work based situation.
The Excel 2007 workshop focuses on the practical application of program features. Training Course OutlineThe course is aimed at increasing the usability of the client’s own spreadsheets, content will therefore be adapted to the unique requirements of the delegates. The workshop includes features from our “Building Blocks” and “Getting more from Excel” courses and might typically include some of the following: Working with Lists | Working with Macros and User Defined Functions | - Designing and creating a list
- Maintaining a list
- Filtering a list
- Using subtotals in a list
- Using conditional formatting techniques.
| - Recording and using macros
- Assigning macros
- Using user defined functions.
| Analysing Data | Managing your Data | - The “IF” function
- The “Vlookup” function
- Working with dates
- Use of advanced formatting features.
| - Importing and exporting files
- Protecting data
- Using data validation
- Using worksheet protection
- Password protecting a workbook.
|
Bespoke Excel 2007 courses can be delivered at your premises, for a minimum of six delegates, and will cover specific program features most relevant to your organisation. For more information on bespoke training courses please call 01923 698498 or This e-mail address is being protected from spambots. You need JavaScript enabled to view it . Entry Requirements: Delegates should have an understanding of any of the following operating systems: Windows 2000 or above
Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Excel 2007 Building Blocks course. We require access to work based spreadsheets before the course takes place. Duration: Full day Cost per delegate: £195.00 excl VAT
These courses are usually presented at the client's premises, course dates are available on request. .png) | 
RSS