Course not currently available
Training U IT Ltd

Microsoft Excel Advanced

Training U IT Ltd
In Harpenden ()

Price on request
Prefer to call the centre directly?

Important information

Typology Short course
Level Advanced
Duration 1 Day
  • Short course
  • Advanced
  • Duration:
    1 Day
Description

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

To take into account

· Requirements

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

Questions & Answers

Ask a question and other users will answer you

We will only publish your name and question

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

Compare to choose better:
See all