Excel 2007 Advanced

Book Public Course Now!Get closed/on-site Course Quote!Get distance Course Quote!
ID:
4802
Duration: 
8 hours
Tags: Microsoft Office 2007

Overview

By the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform very advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

Requirements

The Microsoft Excel 2007 Advanced course is designed for those with a good working knowledge of Excel who wish to explore the most complicated functions and features.

Public: 
490 GBP per delegate

Distance instructor-led course price 790 GBP per course
Get distance quote now! >>
Closed, on-site or individual: get quote >>
Too expensive? Tell us your price!
All prices exclude VAT!

Following Courses

No following Courses Found.

Related Training

Microsoft Office 2007 Upgrade

Training Course Outline

What is New?

  • Old Menu/New Location

  • New spreadsheet Dimensions

  • Cell & Table Styles

  • Enhanced Conditional Formatting

  • Enhanced Cell/Font Colour

  • Enhanced Chart Features

  • Page Layout View

  • Old Feature, New Location

Logical functions

Name ranges
Create named ranges
Use named ranges in formulas
Using the IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions

Lookups

VLOOKUP function
HLOOKUP function

List management

Data validation

Entry of text, values and dates
Creating a dropdown list
Use database functions
Setting up criteria

  • DSUM

  • DAVERAGE

  • DCOUNT

PivotTables and PivotCharts

PivotTable Wizard
Arranging PivotTables
PivotTable toolbar
Create PivotCharts

Analytical options

Goal Seek
Solver add-in
Scenarios

Macros

Create macros

Macro recorder

Macro VBA code

Training Course Dates



No public course dates have been created for this course. Please contact us and we will arrange one for you.