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

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbook

Contains unit objectives, exercises and space to write notes

Refreshments

Available throughout the day:

• Hot beverages
• Clean, filtered water
• Biscuits

Reference material

Available online. 100+ pages with step-by-step instructions

Lunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

• Bloomsbury
• Limehouse
• Southwark

24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

• On a public schedule at one of our
  London training venues.
• On-site at your company office UK wide
• Near-site, at a location close to you
• Tailored courses to your requirements
• Consultancy