Excel 2007 Level 4
| Date |
Location |
Duration |
Cost |
| 16 Sep 2010 (Thu) | Washington | 1 | £ 165 |
| 17 Nov 2010 (Wed) | Washington | 1 | £ 165 |
| 15 Mar 2011 (Tue) | Washington | 1 | £ 165 |
| 25 May 2011 (Wed) | Washington | 1 | £ 165 |
| 15 Jul 2011 (Fri) | Washington | 1 | £ 165 |
Please contact us to discuss private course dates and locations |
Prerequisites
- Delegates should have reasonably advanced knowledge of Excel to get the most from this course, as this is a expert session. Prior attendance at our Level 1, 2 and 3 courses is recommended
Objectives
Follow on Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
Whats Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
Course Content
Expert Features
Solver & Goal Seek (to solve multi-variable complex scenarios)
Auditing (to provide formula audit and error checking facilities)
Expert Formulas
Array Formulas (for advanced calculation and summarising)
Index / Match (a powerful alternative to VLOOKUP functions)
Expert Codes
#NULL! - #DIV/0! - #VALUE! - #REF! - #NAME? - #NUM! - #N/A
(a discussion of why these errors occur and how to avoid them)
Expert Tables
Advanced Pivot Tables (using calculated fields, items, and groups)
Advanced Charts (using Charts with Multi Axes & Trend line analysis)
Excel and Databases
Using Excel with Access
(To make these two popular programs work in harmony - includes table linking - needs MS Access installation)
Using Excel to analyse larger databases (SQL / Oracle databases using ODBC connections)
Data Analysis
SQL OLAP Cube Analysis using Excel
(in order to analyse large datasets as produced by SQL / Oracle and other mainstream MIS systems - Requires OLAP connector)
Using Microsoft Query with Excel (Basic SQL Introduction included)
Sufficient time will be allowed to look at specific requirements, if discussed with the tutor, prior to starting the session
Print