Excel 2007-2016 office 365 Advanced

Taylor Mason Training

Course

Online

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Day

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Our Microsoft Excel 2010 Advanced course is suitable for those with a sound working knowledge of Excel who wishes to progress to the most complicated functions and features.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Office IT
  • Ms Office
  • Formulas
  • Function
  • Logical
  • Combining
  • Lookups
  • Vlookup
  • HLOOKUP

Course programme

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

See related categories

Excel 2007-2016 office 365 Advanced

Price on request

The best Excel courses

See all

See all