Training Home Page > Computer Training Courses > Microsoft Excel 2007 Training Courses (Advanced)

Part of our range of Microsoft Excel 2007 Training Courses in Manchester.


Course Title:	Microsoft Excel 2007 Training Courses (Advanced)

Related Courses:	Microsoft Excel 2007 Training Courses (Introduction) , Microsoft Excel 2007 Training (Intermediate) , Microsoft Excel 2007 Training Courses (Charts) , Microsoft Excel 2007 Training Courses (Data Analysis)

	Course Overview For Microsoft Excel 2007 Training Courses (Advanced) Delegates completing the Excel level 3 course will be able to use the full functionality of this powerful programme and its many features. This is of particular relevance to anyone working with complex or interlinked calculations that must be capable of comparing the outcome of changes in a number of variables within a given scenario. The many time saving shortcuts and in-depth understanding of the huge array of functions available will enable the delegate to undertake calculations that would most likely have been beyond them before attending the course. Included in this is statistical analysis work which will give the ability to interrogate the data within the worksheet in several ways in order to obtain information on which to base decisions or to interpret facts.

Course Content Of Microsoft Excel 2007 Training Courses (Advanced)

A typical course will cover the following:-

Excel 2007 Pivot Tables

Create A Pivot Table
Use The Page Field In A Pivot Table
Filter Row And Column Values
Format A Pivot Table
Pivot Table Summary And Display Options
Show Data As Percentages in Pivot Tables
Create Calculated Fields
Create Calculated Items
Create A Pivot Chart

Microsoft Excel 2007 Scenarios

Create A Default Scenario
Create Scenarios
Use Names In Scenarios
Display Scenarios
Create A Scenario Summary Report
Merge Scenarios

MS Excel 2007 Goal Seek

Use Goal Seek

Labels And Names in Microsoft Excel

Overview Of Labels And Names
Create Labels
Create Names
Use Names In Formulas
Deleting Names

MS Excel 2007 Lookup Functions

VLOOKUP Function
HLOOKUP Function
INDEX Function

Excel Logical Functions

Using The IF Function
Nesting An IF Function
Using The AND Function
Using The OR Function
Using The NOT Function

Statistical Functions in Excel 2007

Basic Statistical Functions
Using MODE & MEDIAN
Conditional Counting
Conditional Sum Wizard

Excel Date And Time Functions

Using The NOW And TODAY Function
The HOUR And MINUTE Functions
Calculating A Future Date
Calculating An Age
Using The DATE Function

Download As A PDF

To find out more about how Copernicus Training can help your business, please call us on 0870 - 879 - 5327
or e-mail us at info@copernicus-training.com