Objectives
After completing the course, participants will be able to:

• Use Excel Templates

• Save Excel Worksheets as a Web Page

• Use PMT, FV, IF, DATE & NOW functions

• Plot, modify and enhance a basic chart

• Create Sparklines

• Use Absolute References

• Split the Workbook window and freeze window panes

• Work with Lists

• Arranging Workbooks

What you will learn
Topics covered by this course include:

Intermediate Editing & Formatting Techniques

• Finding & Replacing Worksheet entries

• Creating & Applying a Style

• Using Alignment Options

• Using options in the Paste Special dialog box

Using Absolute Cell References

• Entering Absolute References into a Formula

Using Financial Functions

• Using the PMT & FV functions

Using Logical Functions

• Using the IF function

• Nesting IF functions

Using Date/Time Functions

• Using the DATE & NOW functions

Creating a Chart

• Plotting, Modifying and Enhancing a Chart

• Previewing and Printing a Chart

• Plot Non-Contiguous Data Ranges in a Chart

• Create Sparklines

Linking Worksheets Within a Workbook

• Entering a Formula to link related Worksheets

• Formatting multiple Worksheets

• Printing and Previewing multiple sheets of a workbook

• Inserting and Deleting worksheets

Controlling the Worksheet Display

• Splitting & Freezing the Worksheet Window

• Hiding Rows and Columns

• Opening a New Workbook window/Arranging Workbook windows

• Changing the Zoom Level

Working with Lists

• Filtering and Sorting records of a List

• Specify a Criteria Range in a Filter Operation

Additional Intermediate Excel Features

• Insert Hyperlinks and Comments

• Applying a background to a worksheet

• Using the Research feature

Prerequisites
Course participants should have completed Excel 2010 Part 1 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R^®