fbpx
config
Excel Intermediate

Excel - Intermediate Training Course

 

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

 

Connect with us

45 Wimbledon Hill Road, Wimbledon, London SW19 7NA, United Kingdom

  • dummy +44 (0) 208 947 1338

  • dummy +44 (0) 208 947 7704

  • dummy info@amitycollege.co.uk

Newsletter

Enter your email and we'll send you more information

© 2019 Amity College Limited. All Rights Reserved.