Mac Excel Advanced

Training

In London

Price on request

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    London

To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros.

Facilities

Location

Start date

London
See map
7th Floor Crystal Gate 28-30 Worship Street, EC2A 2AH

Start date

On request

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

Course programme

Course Contents

Lookup Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
  • Match and Index

Informational Functions

  • IsText
  • IsValue
  • IsDate
  • IsNull
  • IsErr, Is Error, IsNa

Summarising Data with Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart

General Analysis Tools

  • Scenarios
  • Custom Views
  • Reports
  • Goal Seek
  • Solver

Protecting and Sharing Excel Files

  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments

Customisation Options

  • Showing / Hiding Toolbars
  • Customizing Toolbars
  • Customizing Menus
  • Adaptive Menus
  • Default Options
  • Add-ins

Introduction to Macros

  • Purpose of Macros
  • Recording macros
  • Where to save macros
  • Absolute and relative recording
  • Running macros
  • Custom buttons, menu items, keyboard shortcuts

Additional information

Payment options: * 1-to-1 training courses are charged at £450 per day. * All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates. * For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Students per class: 8

Mac Excel Advanced

Price on request