top of page
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
bottom of page