Introduction

 

Intermediate Editing and Formatting Techniques

·       Finding a specific entry in a worksheet

·       Finding and Replacing a Specific Entry in a Worksheet

·       Creating a New Style

·       Applying Style

·       Using Options in the Paste Special Dialog Box
Using Alignment Options in the Format Cells Dialog Box

 

Using Absolute Cell References

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

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

 

Using Logical Functions

·         Using the IF Function

·         Nesting IF Functions

 

Using Financial Functions

·         Using the Payment Function

·         Using the  FV Function

 

Using Date/Time Functions

·         Using the DATE Function

·         Using the NOW Function

 

Creating a Chart

·         What is a Chart?

·         Plotting a Chart

·         Previewing and Printing a Chart

·         Including non-contiguous Data Ranges in a Chart

 

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

 

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

 

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 in a Workbook

·       Formatting Multiple Worksheets in One Operation

·       Previewing and Printing Multiple Worksheets in One Operation.

 

Controlling the Worksheet Display

·         Splitting the Workbook Windows into Panes

·         Freezing Windows Panes

·         Hiding Rows and Columns of a Worksheet

·         Opening a New Workbook Window / Arranging Open Workbook Windows

·         Changing the Zoom level of a Worksheet

 

Adding Pictures and Diagrams to Worksheets

·         Inserting a Picture into a Worksheet

·         Inserting a Smartart Graphic into a Worksheet

 

Additional Intermediate Excel Features

·         Using an Excel Template to Create a Workbook

·         Applying a Background to a Worksheet

·         Hiding an Entire Worksheet and an Entire Workbook

·         Previewing and Saving Excel Data as a Web Page

·         Inserting a Hyperlink into a Worksheet

·         Using the Research Feature

·         Inserting Comments into a Worksheet

 

Final Case Study