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

Option 1: 
1 day (9 hours), was £450, currently only £195

Option 2: 
3 days (3 hours per day), was £450, currently only £195

Option 3: 
12 Weeks (6 hours per week - 3 hours per day), £1500.00

 

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
Go to top
Join us at Amity College Ltd.