data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==

Excel - Intermediate Training Course

 

This 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

  • 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

 

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