fbpx
config
Excel Advanced
 

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wishes to progress to the most complicated functions and features. Working knowledge of Excel or our Excel Intermediate course. 

Benefits

  • At the end of the Excel Advanced course you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

Duration & Cost

Hours per Week 3 Months 6 Months 9 Months 11 Months 12 Months
 15 £1,800 £3,000 £4,000 £4,720 £4,900
 9 £1,500  £2,500  £3,300  £3,900  £4,050 
 6 £1,190  £2,030  £2,750 £3,350  £3,500
 4 £860  £1,460  £1,940 £2,360  £2,465 

Full time classes are 15 hours per week or more

Excel Advanced Course Syllabus

  • Using logical functions

    Naming ranges

    - Creating named ranges
    - Using named ranges in formulas

    The IF function (recap)
    Creating nested IF functions
    AND and OR functions
    Combining logical functions

  • Working with lookups

    The VLOOKUP function
    The HLOOKUP function

  • Advanced list management

    Using data validation

    - Setting criteria for entry of text, values and dates
    - Creating a dropdown list

    Using database functions

    - Setting up criteria
    - DSUM
    - DAVERAGE
    - DCOUNT
  • PivotTables and PivotCharts

Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

  • Using analytical options

Using Goal Seek
Using the Solver add-in
Working with scenarios

- Creating and saving scenarios
- Viewing scenarios

  • Macros

Creating macros
Using the macro recorder
Viewing and editing macro VBA code

Connect with us

Wimbledon Branch

45 Wimbledon Hill Road, Wimbledon, London SW19 7NA, United Kingdom


Ealing Branch

43-47 New Broadway, Ealing, London W5 5AH, United Kingdom


  • dummy +44 (0) 208 947 1338

  • dummy +44 (0) 7783 424 089

  • dummy +44 (0) 208 947 7704

  • dummy info@amitycollege.co.uk

Newsletter

Enter your email and we'll send you more information

© 2019 Amity College Limited. All Rights Reserved.