MS Excel Level 2: Intermediate

Wise

Short course

In Gatwick

£ 201-500

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Location

    Gatwick

  • Duration

    1 Day

Upon completion of this presentation, the participant should be able to use Excel to effectively create and manage data lists and summary data. The participant should also be able to extract and display information from a workbook(s) based upon certain criteria.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course MS Excel Level 1 or equivalent knowledge.

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

Referencing Cells & Cell Ranges

  • Absolute, relative & mixed referencing
  • Named ranges
  • Referencing values in other worksheets/workbooks
  • 3-D referencing
  • Circular referencing

Working With Large/Multiple Spreadsheets

  • Freeze panes
  • Split window
  • Arrange windows

Consolidating Data

  • Consolidating worksheets
  • Consolidating workbooks

Lookup Functions

  • VLOOKUP
  • HLOOKUP

Working With Data Lists

  • Sorting
  • Subtotals
  • Filtering
  • Setting search criteria

Excel's Database Functions

  • DSUM
  • DMIN
  • DMAX
  • DAVERAGE

Conditional Formatting

  • Setting up conditional formats
  • Using formulas in conditional formats

Advanced Chart Creation

  • Create various chart types
  • Modify a chart
  • Add data to a chart

See related categories

MS Excel Level 2: Intermediate

£ 201-500

The best Excel courses

See all

See all