Excel 2007 / 2010 Level 4
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
| 24 May 2012 (Thu) | Washington | 1 | £ 165 |
| 13 Jun 2012 (Wed) | Washington | 1 | £ 165 |
| 14 Sep 2012 (Fri) | Washington | 1 | £ 165 |
| 15 Nov 2012 (Thu) | Washington | 1 | £ 165 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Prerequisites
- Delegates should have reasonably advanced knowledge of Microsoft Excel to get the most from this course, as this is a expert session. We recommend that delegates attend our Excel Level 1, 2 and 3 courses or have equivalent knowledge.
Objectives
Other courses in this series: 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)
Microsoft Excel and Databases
Using Microsoft Excel with Microsoft Access
(To make these two popular programs work in harmony - includes table linking - needs MS Access installation)
Using Microsoft Excel to analyse larger databases (SQL / Oracle databases using ODBC connections)
Data Analysis
SQL OLAP Cube Analysis using Microsoft Excel
(in order to analyse large datasets as produced by SQL / Oracle and other mainstream MIS systems - Requires OLAP connector)
Using Microsoft Query with Microsoft 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
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
What's 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
Microsoft and Microsoft Excel are Registered Trademarks
training courses, Durham, Washington, Newcastle, North East
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
