acca-cbe-centre-banner

acca-cbe-centre-banner

acca-cbe-centre-banner

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

Refer A Friend Banner

Accountancy Course Info Request

Form by ChronoForms - ChronoEngine.com

Save 30% on Student Oyster Card

Student Oyster Discount Offer


Website security

NUS NY 728x90 2016 12 15 V1 NC

Opening Hours

Monday
09:00 - 21:00
Tuesday
09:00 - 21:00
Wednesday
09:00 - 21:00
Thursday
09:00 - 21:00
Friday
09:00 - 21:00
Saturday
09:00 - 21:00
Sunday
09:00 - 21:00

Logo Bar

Go to top
Join us at Amity College Ltd.