Microsoft Excel – Level 3
Course Outline

DURATION 1 Day
PREREQUISITES Should know the difference between absolute and relative references, be comfortable with named ranges and be familiar with a range of functions including Vlookup and If.
DESCRIPTION This course introduces Pivot Tables, advanced functions and array formulas.  Delegates will also explore What-If Analysis and advanced workbook options like sharing, tracking changes and strategies for combining workbooks.
COURSE DATES SPECIAL: Four Days of MS Office training for the price of Three!

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Wed, 15-Feb-12 09:30 - 16:30 £180.00 +VAT
Evening Wed, 22-Feb-12 and Thu, 23-Feb-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 8-Mar-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 24-Mar-12 10:00 - 16:30 £180.00 +VAT
Weekday Mon, 16-Apr-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 23-Apr-12 and Tue, 24-Apr-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 3-May-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 23-May-12 and Thu, 24-May-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 15-Jun-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 23-Jun-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 4-Jul-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 23-Jul-12 and Tue, 24-Jul-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 3-Aug-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 22-Aug-12 and Thu, 23-Aug-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 11-Sep-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 22-Sep-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 3-Oct-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 22-Oct-12 and Tue, 23-Oct-12 18:30 - 21:30 £200.00 +VAT
Weekday Mon, 5-Nov-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 12-Nov-12 and Tue, 13-Nov-12 18:30 - 21:30 £200.00 +VAT
Weekday Mon, 17-Dec-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 22-Dec-12 10:00 - 16:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

 

Please note that this is an Introduction to Pivot Tables. If you would like to go into greater detail then please refer to our Pivot Table half day intensive courses.

PIVOT TABLES

  • What is a PivotTable?

  • Creating a PivotTable
  • Specifying PivotTable Data
  • Rearranging PivotTable Data
  • Modifying PivotTable Calculations
  • Formatting a PivotTable
  • Charting a PivotTable

ADVANCED FUNCTIONS

  • Sum, SumIf, Count, Count,If, Average, Max

    • Using Automatic Outlining

    • Inserting Functions (The PMT Function)

    • Working with Array Formulas

WHAT IF ANALYSIS

  • Exploring Scenarios

  • What is a Scenario?

  • Creating a Scenario

  • Creating a Scenario Summary Report

  • Saving Multiple Scenarios

  • Using One and Two Input Data Table

  • Using Goal Seek

  • Using Solver

SHARING WORKBOOKS

  • Creating and Using Shared Workbooks
  • Sharing a Workbook
  • Opening and Editing a Shared Workbook

TRACKING CHANGES

  • Tracking Changes
  • Resolving Conflicts in a Shared Workbook

LINKING, CONSOLIDATING, AND COMBINING WORKBOOKS

  • Linking Workbooks
  • Consolidating Workbooks
  • Combinging Worksheets

 

 

Home | Contact | Terms and Conditions