EXCEL LEVEL 2 SESSION OUTLINE

The Open Dialog Box

Opening Multiple Workbooks

Working With Multiple

Workbooks

Compare Workbooks Side By Side

Copying A Worksheet

Renaming Worksheets

Moving Worksheets

Inserting And Deleting

Worksheets

Grouping Worksheets

Inserting Cells

Deleting Cells

Inserting Columns

Inserting Rows

Deleting Rows And Columns

Resizing Columns

Resizing Rows

Hiding Grid Lines

Freezing Columns And Rows

Splitting Windows

Using Zoom

Hiding Rows And Columns

Absolute And Relative

Referencing

Problems With Relative

Formulas

Tracing Precedents

Creating Absolute References

Creating Mixed References

Circular References

Filling A Series

Filling A Growth Series

Filling A Series Backwards

Filling Using Options

Creating A Custom Series

Modifying And Deleting

Custom Series

Logical Function Concepts

Displaying Information Using

IF

Displaying Values Using IF

Nesting An IF Function

Using The AND Function

Using The OR Function

Using The NOT Function

Requirements Of Lookup

Functions

The CHOOSE Function

The ISERROR Function

The VLOOKUP Function

Testing Lookup Functions

Using VLOOKUP For Exact

Matches

The Index Function

Performing A Simple Sort

Sorting On More Than One

Column

Sorting Numbers

Sorting By Rows

Applying & Using AutoFilter

Creating Compound Filters

Creating Custom Filters

Multiple Value Criteria

Using Wildcards In Custom

Criteria