Excel 2002 (xp) - effective use of

Intuition Computer Training

Course

In London

£ 490 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables. manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates. prevent unauthorised changes to spreadsheets. automate repetitive tasks. use keyboard shortcuts where appropr

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 formulae with excel functions, including conditional and nested functions
  • produce a variety of reports and models including what if analysis and pivot tables
  • manipulate and analyse data using list management techniques
  • create and manage shared workbooks
  • create and use custom templates
  • prevent unauthorised changes to spreadsheets
  • automate repetitive tasks
  • use keyboard shortcuts where appropriate
topic
  1. review excel essentials-relative & absolute references, range finder, range names, paste function, logical functions
  2. formatting-format painter, conditional formats, number formats, custom formatting, protection - protect cell contents, password protection
  3. functions & formulae-logical, vlookup & hlookup, financial, reference, statistical, multiple conditions, nested functions
  4. data analysis-working with arrays, data tables, goal seek, scenario manager, goto special, custom views, report manager, pivot tables
  5. list management-sort data, autofilter, custom filter, advanced filter, subtotals, pivot table, data validation
  6. shared workbooks-create a shared workbook, view changes, manage conflicts, view change history
  7. workbook templates-custom template, worksheet protection, new default templates
  8. automation-macros, record, run, relative & absolute macros, customise toolbars

See related categories

Excel 2002 (xp) - effective use of

£ 490 + VAT

The best Excel courses

See all

See all