MS Excel 2007 Advanced

Training

In London

Price on request

Description

  • Type

    Training

  • Location

    London

  • Duration

    1 Day

To build on previous knowledge and explore Advanced 2007 functionality within Excel, finishing with an introduction to Macros. Suitable for: Fairly experienced Excel 2007 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros.

Facilities

Location

Start date

London
See map
7th Floor Crystal Gate 28-30 Worship Street, EC2A 2AH

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel

Course programme

Course Contents

Lookup & Information Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
  • Match and Index
  • IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa

Advanced List Management

  • Advanced Filters
  • Using List Features
  • Dynamic Lists

Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart

What If Analysis

  • Scenarios
  • Custom Views
  • Reports
  • Goal Seek
  • Solver
  • Data Tables

Protecting & Sharing Files

  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments

Introduction to Macros

  • Purpose of Macros
  • Recording macros
  • Where to save macros
  • Absolute and relative record
  • Running macros:
  • Custom buttons, menu items, keyboard shortcuts

**You are able to include/exclude as much content as you need to create your own Excel 2007 Advanced Training Course**

Time: Course starts at 09:30 and runs until 16:30

The course is run on a date that suits you! We do not run public scheduled courses.

Additional information

Payment options: All our courses are charged at a flat rate per day. One to One - Charged at £450 per day Training our Training centre - Charged at£695 per day All prices are excluding VAT and per day. Travel cost outside the M25 applies.

MS Excel 2007 Advanced

Price on request