Course not currently available

Microsoft Excel Advanced

Training U IT Ltd

Short course

In Harpenden ()

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Duration

    1 Day

On completion of this course, attendees will be able to create a variety of functions, present their data using PivotTables, analyse workbooks and data and record macros. Suitable for: This course is designed for those who wish to understand how to analyse and present their data more efficiently as well as automate common tasks.

Important information

Documents

  • Excel Advanced

About this course

Attendees should have attended our Excel Intermediate course or have equivalent knowledge.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Course programme

Microsoft Excel Advanced Course Outline
Review of Excel Skills

  • Constructing formulae
  • Using functions
  • Absolute and relative cell referencing
  • Naming ranges

Automating Worksheets

  • Creating and editing templates
  • Using data validation
  • Applying workbook & cell protection

Further Functions

  • Nested IF functions
  • Using AND OR operators
  • Lookup functions
  • Text functions

Summarising Worksheets

  • Group and outline a worksheet
  • Hiding and displaying outlines

Pivot Tables

  • Creating and modifying Pivot Tables
  • Refreshing the data
  • Grouping data within a Pivot Table

Data Management

  • Using worksheet auditing tools
  • Tracing dependent and precedent cells
  • Checking for errors & highlighting invalid data

Macros

  • Recording simple Macros
  • Running and editing Macros
  • Assigning Macros to the keyboard, toolbar buttons and menus

See related categories

Microsoft Excel Advanced

Price on request

The best Excel courses

See all

See all