|
|
Advanced Microsoft Excel (Windows XP)
 Reed Learning -
2 days - Advanced - Public & In-House - £495.00 (includes materials, lunch, refreshments)
Course Code: ADEXP
Send A Message
- visit website http://www.reedlearning.co.uk/training
| Venue | Dates
| | 1 | Holborn Training Centre, 9 Kingsway, London, London, WC2B 6XF | 26 Jan 2009 to 27 Jan 2009 10 Feb 2009 to 11 Feb 2009 26 Feb 2009 to 27 Feb 2009 16 Mar 2009 to 17 Mar 2009 1 Apr 2009 to 2 Apr 2009 16 Apr 2009 to 17 Apr 2009 |
Description and objective: Microsoft Excel offers a vast array of functionality to assist in manipulating and analysing data. This course looks at:
Count Functions
Advanced If statements
Auditing Worksheets
Trace Cell Precedents & Cell Dependents
Watch and Evaluate Formulas
Goal Seek to reverse calculate a formula
Creating Input Data Tables
What-If? Analysis
Consolidating Data by position
Group And Outline Features
Analysing Data with Pivot Tables
Importing Text Files
Setting Up Database Queries
Recording Macros
Creating your own Menu Suitability: For people who have attended the intermediate course or have good knowledge and understanding of Excel and would like to explore the more complex functionality Excel can offer
Contact Reed Learning
| Phone | 0800 132 448 When calling be sure to mention Training Pages
| Fax | 0800 435 314 |
|
Send a Message
|
|
|
|
| Back to Top
© Training Pages, 2002-2007. Site use subject to our Terms and Conditions and Privacy Policy. Training Pages is a division of Ecube Limited. Registered office 1.23 Plaza 535, Kings Road, London SW10 0SZ. Company Number: 3839310. VAT Registration No. 75908879.
|