|
 Overview
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
What some delegates have 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 (Communities and Local Government)
“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)
|
