Microsoft Excel - Intermediate
Excel Intermediate (Versions 1997 to 2007)
Duration: One Day
| Aims and Objectives of the workshop | To develop the use of excel using formulae and build upon 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 about using complex formulae in excel spreadsheets |
| Who should attend | People who are fully conversant with using formulae in an excel |
| Experience needed | Delegates should be familiar with creating and working on Excel spreadsheet files. |
Course Content
Relative and Absolute references
If statements and Nested If statements
Working With Multiple Sheets
- Renaming Sheets
- Group Formatting
- Copying Formats To ‘Selected’ Sheets
- Linking Formula Between Sheets
- 3-D Formulas
Advanced Autofilter
Extracting sub totals
Using the SumIf and CountIf functions
Protecting Formulae and/or worksheets
Creating and manipulating Graphs
Related courses: Excel Introduction, Excel Advanced
Please note that sections of this course can be mixed with other courses to create your own bespoke training package.