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

    45 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