The Excel Intermediate course is designed for those who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.
Benefits of the Excel Intermediate Course
- Quickly summarise multiple sheets of data into one
- Turn long lists and reports into easy to read tables
- Formulas to check whether cells pass or fail your rules
- Create links between cells so that they all update automatically
- Highlight targets, trends, duplicates and errors with Conditional Formatting
- Formatting and layout consistency by saving as a Template
Duration
| Hours per Week | 3 Months | 6 Months | 9 Months | 11 Months | 12 Months |
|---|---|---|---|---|---|
| 15 | £1,800 | £3,000 | £4,000 | £4,720 | £4,900 |
| 9 | £1,500 | £2,500 | £3,300 | £3,900 | £4,050 |
| 6 | £1,190 | £2,030 | £2,750 | £3,350 | £3,500 |
| 4 | £860 | £1,460 | £1,940 | £2,360 | £2,465 |
Full time classes are 15 hours per week or more
Excel Intermediate Course Syllabus
- Working with Large Worksheets
Viewing options
- Adjusting zoom
- Using Freeze Panes
- Using Split Window
Hiding and displaying data
- Hiding rows and columns
- Creating an outline
Printing large worksheets
- Page Break preview
- Working with page breaks
- Printing multiple sheets
- Working with Multiple Worksheets and Workbooks
Using multiple worksheets
- Navigating between sheets
- Moving and copying sheets
Linking worksheets
- Creating 3-D formulas
- Consolidating data
Linking workbooks
- Creating a formula to link workbooks
- Using the Paste Link option
- Maintaining links
- Working with dates
Entering date functions
- TODAY function
- NOW function
Date and time formats
Using dates in formulas
- Conditional formulas and formatting
The IF function
Conditional formatting
- Based on a cell value
- Based on a formula
- Identifying cells with conditional formatting
- Copying conditional formats
- List Management
Working with lists
- Structure of a list
Sorting and filtering lists
- Simple sorting
- Sorting by multiple columns
- Using AutoFilter
Advanced filtering
- Using custom filter
- Using Advanced Filter
Adding subtotals to a list
- Documenting and Auditing
Comments
- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
Protection
- Protecting a worksheet
- Protecting cell ranges
- Using Templates
Built-in templates
- Accessing and using Excel’s templates
Creating and managing templates
- Creating, using and modifying a custom template file