Enhance your use of advanced formulas and database features
This one day course is designed for people who have created a spreadsheet and now wish to manipulate and interrogate the data in greater detail.
What you will gain
You will gain enhanced skills in the techniques associated with large and multiple spreadsheet design, including data manipulation, worksheet consolidation and more complex functions and formulae.
Who should attend this course?
You should attend this course if you are currently using Excel for basic formulas and would like to develop your skills in the creation and understanding of functions.
This course covers the following key topics: -
- Work with multiple spreadsheet workbooks
- Dynamically link worksheets and workbooks using more complex formulae and consolidation tools
- Work with lists and manipulate data using sort and filters
- Understand and utilise some of Excel's more advanced functions
- Create nested logical functions
- Create and manipulate charts
£210 + VAT
|Other courses you may like:|
Microsoft Excel Introduction
Microsoft Excel Advanced
|Book this course for in-house delivery|
| Request Now |
|What others said about this course |
Trainer was very helpful, knowledgeable and made sure all delegates needs were met. KV (DCLG)
Very fluent and tailored presentation. PS (DCLG)
Very good, I would recommend colleagues to attend this. TB (Department for Transport)
|Course Finder |
|Call us now for further information|
0844 33 505 87