·         Defining a Range Name

·         Using a Range Name

·         Selecting a Named Range

Working with a List

·       What is a list?

·       Sorting the Records of a list

·       Filtering the Records of a List

·       Specifying a Range of Values as Criteria for a Filter Operation

Using DATE / TIME Functions

·         Using the DATE Function

·         Using the NOW Function

Using Absolute Cell References

·         Entering an Absolute Column and Absolute Row Cell Reference into a Formula

 Using Financial Functions

·       Using the PMT Function

·       Using the FV Function

Linking Worksheets Within a Workbook

·       Renaming Worksheets in a Workbook

·       Moving the Cell Pointer From One Worksheet to Another

·       Inserting and Deleting Worksheets

·       Entering a Formula to Link Related Worksheets

·       Formatting Multiple Worksheets in One Operation

·       Previewing and Printing Multiple Worksheets in One Operation

Linking Multiple Workbooks

·       Entering a Formula to Link Multiple Workbooks

·       Creating a Workspace

 Analyzing Worksheet Data

·       Creating a PivotTable Report

·       Resetting the Summary Function in a PivotTable Report

·       Creating a PivotChart Report

·       Creating and Displaying a Scenario

·       Using the Analysis ToolPak

·       Using Solver

Controlling the Worksheet Display

·       Splitting the Workbook Window into Panes

·       Freezing Window Panes

·       Hiding Rows and Columns of a Worksheet

·       Opening a New Workbook Window / Arranging Open Workbook Windows

·       Changing the Zoom Level of a Worksheet

Advanced Data Entry and Formatting Techniques

·       Restricting Cell Entries to Specific Numbers, Dates or Times

·       Restricting Cell Entries to Specific Entries in a List

·       Creating a Custom Number Format

·       Applying Conditional Formatting to a Worksheet

Creating a Custom Workbook Template

·       Creating a New Workbook Template

·       Modifying the Default Workbook Template Style

·       Basing a New Workbook on a Custom Workbook Template