Please contact 0800 022 3410 to request further information about the scheduling and delivery elements for this specific programme this year.
This Microsoft Excel course aims to cover:
- Advance ‘IF’ statements
- How to use named ranges
- Working with multiple worksheets
- Using pivot tables and ‘What IF’ scenarios
- Creating macros
- Linking to external data sources.
Our Microsoft Office Excel training is ideal for anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Microsoft Excel 2010.
This Microsoft Excel course will help you learn how to:
- Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions
- Use data tables to view the effects of multiple input values on a formula
- Use the Subtotal command, the Subtotal function and database functions to summarise list data; and use data forms and validation to facilitate data entry in lists; and use data tables to project values
- Create and use PivotTables to analyse and compare large amounts of data
- Import data from and export data to external databases
- Use Goal Seek and Solver to perform what-if analysis; and use custom scenarios, advance custom views and pivot tables to manage large worksheets
- Run and record macros to automate complex or repetitive tasks
- Publish a worksheet as an interactive Web page
- Apply financial formulas and array formulas in Data Tables to determine outcomes.
Payment:
Must be made in full no later than 14 working days prior to the course start date.
Transfers:
The following charges will apply if you wish to transfer your booking to a later course date:
21+ working days before a course = 0% of the course fee
5-20 working days before a course = 50% of the course fee
1-4 working days before a course = 100% of the course fee
To transfer a delegate please call us on 0800 022 3410.
Substitute delegates:
You can transfer a place on a course to a substitute delegate free of charge.
Cancellations:
The following charges will apply if you wish to cancel a course:
21+ working days before a course = 20%
1-20 working days before a course = 100%
Cancellations must be received in writing via email to courses@capita-ld.co.uk and must contain the full booking details including
organisation name, booking and delegate contact details.
For full terms and conditions please see Terms and conditions
page, for other queries please refer to our frequently asked questions page.