Excel Advanced
 

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

Benefits

  • At the end of this 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

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

47A Wimbledon Hill Road, Wimbledon, London SW19 7NA, United Kingdom

  • dummy +44 (0) 208 947 1338

  • dummy +44 (0) 208 947 7704

  • dummy info@amitycollege.co.uk

Newsletter

Enter your email and we'll send you more information