Become a power user of Excel and experience the full ability of spreadsheets

A one day course for delegates who wish to use the spreadsheet options in Excel to manipulate and interrogate the data and automate their Excel worksheets.

What you will gain

You will gain enhanced skills through advanced techniques associated with analysis and manipulation of data in spreadsheets, including pivot tables and database functions, recording macros and solving tools.

Who should attend this course?

You should attend this course if you are currently using Excel to intermediate level (see Excel Intermediate) and would like to develop your Excel skills to take advantage of the full power of the software.

Course Objectives

This course covers the following key topics: -

  • Analyse worksheet data using pivot tables
  • Analyse worksheet data using Scenario Manager, Goal Seek and Solver
  • Create templates for individual and group use
  • Record macros
  • Apply the various protection settings to shared workbooks
  • Customise the Excel workspace

 Booking Form 

Duration:
Course Code:
Delegate Cost:
1 day
ME3
£210 + VAT
Other courses you may like:

Microsoft Excel Introduction
Microsoft Excel Intermediate

Book this course for in-house delivery
 Request Now 
What others said about this course  
An excellent trainer. He made you feel comfortable and at ease. His pleasant manner and enthusiasm really made the course a pleasure. LM (DCLG)
I thoroughly enjoyed the course - very participative. RR (Department for Work and Pensions)
I am glad to have done this course and learnt much from it. JC (Department for Transport)

Course Finder 

Call us now for further information

0844 33 505 87


Course Finder


Copyright © 2014 Alpha Consolidated Training Limited. All Rights Reserved.