Excel 2007 Level 4
|
This course outline is available as a private course.
|
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 course at one of our training venues
- Private course at your company office throughout the UK, at our training room 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
- Comprehensive course manual and exercises
- Telephone and email support
- Lunch and refreshments when training is delivered at our training venue
- Relaxed refreshment area at our training room
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