£270

Multiple Dates

Microsoft Excel Level 2

Event Information

Share this event

Date and Time

Location

Location

Pitman Training London

Salisbury House

London Wall

London

EC2M 5QQ

United Kingdom

View Map

Event description

Description

IDEAL FOR: This course is for anyone who wants to gain an advanced skill set necessary for calculating data using functions and formulas, sorting and filtering data, creating PivotTables to analyse data and customising workbooks.

AIMS AND OBJECTIVES

You will use advanced formulas and work with various tools to analyse data in spreadsheets. You will also organise table data, present data as charts and enhance the look and appeal of workbooks by adding graphical objects.

Programme

Lesson One – Calculating Data with Advanced Formulas

  • Apply Cell and Range Names

  • Calculate Data across Worksheets

  • Use Specialised Functions

  • Concatenate, Proper, Left and Right

  • Analyse Data with Logical and Lookup Functions

  • If, SumIf, CountIf and Vlookup


Lesson Two – Organising Worksheet and Table Data

  • Create and Modify Tables

  • Format Tables

  • Sort and or Filter Data

  • Use Functions to Calculate Data


Lesson Three – Presenting Data using Charts

  • Create a Chart

  • Modify a Chart

  • Format a Chart

Lesson Four – Analysing Data using PivotTables, Slicers and PivotCharts

  • Create a PivotTable Report

  • Filter Data using Slicers

  • Analyse Data using PivotCharts


Lesson Five – Inserting Graphical Objects

  • Insert and Modify Images

  • Draw and Modify Shapes

  • Illustrate Workflow using SmartArt Graphics

  • Layer and Group Graphical Objects


Lesson Six – Customising and Enhancing the Excel Environment

  • Customise the Excel Environment

  • Customise Workbooks

  • Manage Themes

  • Create and Use a Template

FAQs

What are my transport/parking options for getting to and from the event?

FROM MOORGATE: Walk down Moorgate towards the City and turn left at the traffic lights into London Wall. The entrance to Salisbury House is about 50 yards on the left-hand side.

FROM LIVERPOOL STREET: Take the main exit from the station (by McDonalds). Cross the road and walk down Old Broad Street. At the traffic lights turn right onto London Wall. Walk along London Wall and through the traffic lights. When you see “Pizza Express” you are nearly there so continue walking along London Wall. The entrance to Salisbury House is on your right.

FROM BANK TUBE STATION: Take Exit 2 and turn immediately right into Prince’s Street. Go straight across first set of traffic lights on to Moorgate. Turn right at next set of traffic lights on to London Wall. The entrance to Salisbury House is about 50 yards down the road on the left-hand side.

We recommend that you do not drive to the training venue.

How can I contact the organiser with any questions?

You can contact us by emailing courses@pitmanlondon.co.uk or calling 020 7256 6668.

What's the refund policy?

Full refund up to 14 days before course. Substitute a delegate at any time up to previous day by phone or email to let us know the new delegate's name

Do I have to bring my printed ticket to the event?

Yes please.

Share with friends

Location

Pitman Training London

Salisbury House

London Wall

London

EC2M 5QQ

United Kingdom

View Map

Save This Event

Event Saved