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.
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
£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