Excel Intermediate 1 & 2
This course is for existing users of Excel who wish to who wish to improve competence working with calculations, large spreadsheets, and lists.
You can choose to do Intermediate session 1 or 2 or both depending on your requirements.
| Duration | 3 hours for each session (full day for both) |
| Group Size | Up to 10 people maximum |
| Prerequisite | No Prerequisite |
| Course type | Microsoft 365 |
| Training Room Requirements | Meeting Room TV/Projector PC/Laptop with Windows 10 |
| Remote Training Requirements | Sessions will be hosted using either Webex or Microsoft Teams sessions Attendees must have access to a PC/ Laptop that can access Webex or Microsoft Teams |
| Note | This course should take place before a cutover |
Course Content
Delegates will undertake the following modules:
Excel Intermediate session 1:
Formulas and Functions
- Revision of basic formulas & AutoSum
- Creating statistical functions
- Using absolute & mixed cell addresses
- Using the Insert Function button
- Testing data using the IF function (to include IFS)
- The ERROR function
Formula Auditing
- Tracing precedents and dependents
- Tracing errors
- Showing formulas
Multiple Worksheets
- Inserting & deleting worksheets
- Colour-coding worksheet tabs
- Moving and copying worksheets
- Grouping worksheets for formatting and printing
- Linking cells between worksheets
- Creating calculations across worksheets
Excel Intermediate session 2:
Lists
- Sorting lists
- Filtering lists
- AutoSum with lists
- Formatting a list as a table
Managing Large Worksheets
- Freezing columns and rows
- Splitting the screen
- Hiding & unhiding columns and rows
Printing
- Printing a selection
- Setting & clearing print areas
- Scaling a sheet to fit
- Centring horizontally & vertically
- Inserting & removing page breaks
- Headers & footers revision
- Repeating titles on each page