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

Hall Green Software Training

The Old Stables

Iscoyd

Shropshire SY 13 3AS

T: 01948 781175

e. a.norris@hallgreensoftwaretraining.co.uk

  • Facebook Social Icon
  • LinkedIn Social Icon