Microsoft Excel Intermediate

Keyboard Shortcuts

 

Selecting and formatting review

Format Painter

Conditional formatting

Review of using basic functions

SUM, AVERAGE, MIN, MAX,

TODAY, NETWORKDAYS

CONCATENATE, UPPER, LOWER

Advanced formula construction

VLOOKUP

IF & NESTED IF

Sheet linking

3D Formulas

Display options

Add comments

Display & Hide columns or rows

Sorting Data

Sort and Filter

Previewing charting

Create and format Charts

Using Print Preview

Print on one Page

Headers & Footers