Excel 2007 Level 4
Sponsored links
This course will enable delegates to fully master the advanced features of Excel, particularly using advanced formulas & functions, as well as the more advanced pivot table, lookup table, and charting features. Data analysis is featured heavily in this session, with a view to Excel as an Analysis tool connected to external databases, thereby overcoming storage limitations of excel sheets, both in Excel 2003 and 2007 .
| Delivery: |
|
| Category: |
Further Details
Objectives
Delegates will be able to:
Fully master the advanced features of Excel, particularly using advanced formulas & functions, as well as the more advanced pivot table, lookup table, and charting features. Data analysis is featured heavily in this session, with a view to Excel as an Analysis tool connected to external databases, thereby overcoming storage limitations of excel sheets, both in Excel 2003 and 2007 .
Follow on Courses
VBA using Excel
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
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
