Excel 2007 Advanced

PPi Learning Services

Short course

In London and Birmingham

£ 250 + VAT

The best Excel courses

See all

See all

Description

  • Duration

    1 Day

This course is designed to familiarise the delegate with the Advanced concepts of Excel. This includes viewing specific worksheet data, using Goal Seek, and working with Databases and PivotTables. You will also learn how to customise the Excel menus and toolbars as well as create your own templates.

Facilities

Location

Start date

Birmingham (West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE

Start date

On request
London
See map
3-5 Crutched Friars, EC3N 2HR

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

Course programme

Course content

  • Utilities
  • Using String Formulas
  • Amending Number Formats
  • Shared Lists
  • Auditing
  • Scenario Manager
  • Goal Seeking
  • Solver
  • Databases
  • Creating A Database
  • Using Data Forms
  • Adding, Editing And Deleting Records
  • Sorting Records
  • Searching For Records
  • Removing Duplicates
  • AutoFilter And Advanced Filter
  • Working With Tables
  • Database andLOOKUPFunctions
  • Data Tables
  • PivotTable and PivotChart Reports
  • Pivot Table
  • Calculating in PivotTables
  • PivotCharts
  • UsingXML
  • UsingXMLdata sources
  • Customising Excel
  • Customising the Quick Access Toolbar
  • Creating Templates

See related categories

Excel 2007 Advanced

£ 250 + VAT

The best Excel courses

See all

See all