Worksheet Views Training on CD-ROM
From 123-CBT Computer Based Training
Excel XP Essentials Set of 3
...Workbook 5.4 Default Settings Advanced 1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split Screens 2.0 Auditing Techniques 2.1 Using the Formula Auditing Toolbar 2.2 Tracing Dependent Cells 2.3 Tracing Precedent Cells 3.0 The IF & VLOOKUP Functions 3.1 The IF Functions & Relational Operators 3.2 Using Words in IF Functions 3.3 Using
more...
Excel 2000 User Set of 3
...ttings
Advanced (2 Hours 2 Minutes)
1.0 Adjusting Worksheet Views (13 Minutes)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Minutes)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Minutes)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use
more...
Excel 2000 Advanced
...Worksheet Views (13 Minutes)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Minutes)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Minutes)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Minutes)
more...
