Keystone Training Tapes

Advanced Excel

(2 Hrs 2 Mins)

1.0 Adjusting Worksheet Views (13 Mins)

1.1 Freeze/Unfreeze Panes

1.2 Horizontal & Vertical Split screen

2.0 Auditing Techniques (12 Mins)

2.1 Using the Auditing Toolbar

2.2 Tracing Dependant Cells

2.3 Tracing Precedent Cells

3.0 Using Functions (18 Mins)

3.1 Paste Function

3.2 The PMT Function

3.3 Expanding the use of standard functions

4.0 Logical Functions (30 Mins)

4.1 IF Functions & Relational Operators (> < >= <= = <> )

4.2 Using Words in IF Functions

4.3 Using IF Functions with Arithmetic Operators (* / + -)

4.4 Using Logical Operators (AND & OR) with the IF Function

4.5 Nested IF Functions

4.6 Using the VLOOKUP Function to overcome Limitations of

the IF Functions

5.0 Date & Time Functions (21 Mins)

5.1 Using Dates as Values

5.2 Entering a Series of Dates

5.3 Date/Time entry Techniques

6.0 Multi-Sheet Workbooks (22 Mins)

6.1 Re-Naming & Re-Ordering Sheets

6.2 Inserting & Deleting Sheets

6.3 Moving

6.4 Formulas across multiple sheets