Microsoft Excel Advanced 2003

Qualtech

Short course

In Treforest

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    Treforest (Wales)

  • Duration

    1 Day

This one-day training session will offer delegates the opportunity to explore many of the more complex tools available in Microsoft Excel, concentrating on Data Analysis and Manipulation Techniques. During the session participants will receive hands-on training on a variety of uses of Excel in the workplace. Suitable for: The training session is designed for those with an excellent knowledge of using Excel for basic mathematical calculations and who wish to expand on these and increase their speed. Each participant will be given a comprehensive reference manual to take away with them.

Facilities

Location

Start date

Treforest (Rhondda Cynon Taff)
See map
Qed Centre, Main Avenue, Treforest Industrial Estate, CF37 5YR

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

Microsoft Excel Advanced 2003


COURSE CONTENT

More on IF Statement

  • Nesting IF statements
  • Using AND,OR
  • Using IS functions to trap errors
LOOKUP Tables
  • VLOOKUP
  • HLOOKUP

Pivot Tables

  • What is a pivot table?
  • Creating a pivot table
  • Adding/removing fields
  • Pivoting the results
  • Viewing pages individually
  • Drilling down for more detail
  • Adding formulae to pivot tables

Using Data Validation

  • Prevent entry of incorrect data
  • Displaying error messages

External Data

  • Microsoft Query
  • ODBC
  • Importing data into pivot tables
Goal/Seek
  • Why we goal seek
  • Uses

The Solver

  • Overview
  • Uses

Scenarios

  • Overview
  • Uses

Macros

  • Assigning a macro to a toolbar button

See related categories

Microsoft Excel Advanced 2003

Price on request

The best Excel courses

See all

See all