Menu

Tel: 01423 534630    Email: info@tts-uk.com

Microsoft Excel Advanced

Designed for Excel 365, 2019, 2016, 2013, 2010

Who is this course for?

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.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

Benefits

At the end of this advanced Excel 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.


  • Course content

    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

Duration: 1 day
Level: Advanced
Price: £295 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.