Excel Level III: Advanced

Advanced Navigation

Advanced Navigation

• Advanced navigation techniques

Fill Review

• Review of Autofill conventions and techniques

Cell Management

Mixed Reference Formulas

• Create powerful formulas by locking either the column or the row

Hot Keys

• Transform the ribbon into a visual listing of pre-assigned shortcuts

Cell Auditing

• Observe the relationship between formulas and cells

Go To Special

• Quickly select cells that meet certain criteria

Special Formatting

Conditional Formatting-Formulas

• Create custom rules for Conditional Formatting with formulas

Date Functions

• Calculate dates with a variety of functions

Custom Number Formats

• Customize number formats to meet specific requirements

Advanced Functions

Nested IF statements

• Nested "IF" statements allow for more than just two possibilities in a single cell

IF statements with AND/OR

• Expand the functionality of the IF function by adding AND / OR criteria

What If Analysis

Goal Seek

• Find the desired result by adjusting an input value

Data Tables

• Data Tables show the range of effects of one or two different variables on a formula