Microsoft Excel - Advanced
Excel Advanced (Versions 1997 to 2007)
Duration: One Day
| Aims and Objectives of the workshop | Delegates will build on basic knowledge of a spreadsheet application or the fundamentals and move on to more complex formulae and other more advanced Excel features. At the end of the workshop delegates will feel confident in using the more advanced aspects of Excel |
| Who should attend | People who are fully conversant with using formulae in an excel |
| Experience needed | Delegates should be fluent in the use of multiple sheets, absolute references and other Excel formulae. |
Course Content
Protecting Formulae
Using Pivot tables
Lookup functions
Frequency functions
Concatenate
Logical and time and date functions
Financial and database functions
Text functions
Maths and statistical functions
One and two data input tables
Tracing errors
Validation of data and using lists
Related courses: Excel Introduction, Excel Intermediate
Please note that sections of this course can be mixed with other courses to create your own bespoke training package.