Excel 2002 (xp) - advanced

Intuition Computer Training

Short course

In London

£ 225 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    London

  • Duration

    1 Day

create custom templates to be more productive. automate repetitive and/or complex tasks using macros. summarise data using pivot tables. analyse and extrapolate data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae to speed up spreadsheet development

Facilities

Location

Start date

London
See map
210 Borough High St, SE1 1JX

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 description
after completing this course, participants will be able to:
  • create custom templates to be more productive
  • automate repetitive and/or complex tasks using macros
  • summarise data using pivot tables
  • analyse and extrapolate data using scenarios and solver
  • create complex formulae using combinations of functions like vlookup and match
  • use array formulae to speed up spreadsheet development

topic
  • hyperlinks-save as html, make data interactive - pivots, formulas
  • automation-macros, record, run, relative & absolute, assign to buttons, customise toolbars, edit vba code
  • workbook templates-new default templates
  • get external data
  • array formulas
  • data analysis-pivot tables, data tables, solver
  • advanced functions-statistical, dates, text, financial, lookup, counta, edate, upper, pmt, match, countblank, eomonth, lower, fv, index, countif, proper, lookup, sum using names, vlookup & match, split first & last name

See related categories

Excel 2002 (xp) - advanced

£ 225 + VAT

The best Excel courses

See all

See all