Auditing Toolbar Training on CD-ROM
From 123-CBT Computer Based Training
Excel XP Essentials Set of 3
...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 Logical Operators 3.4 Nested IF Functions 3.5 Getting Data from the Table with a VLOOKUP Function 4.0 Date & Time Functions 4.1 Using
more...
Excel 2002 Intermediate
...Argument Tooltips Viewing Formula & Results The Formula Auditing Toolbar Additional Help On Functions Formatting A Range Of Cells Creating A Pie Chart Specifying A Data Range Entering Titles Positioning The Legend Selecting Data Labels Specifying A Location For A Chart Formatting Data Labels Repositioning Chart Components Formatting The Chart Area Saving Your Work Lesson 3:
more...
Excel 2000 User Set of 3
...
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)
4.1 IF Functions and Relational Operators (> =
)
4.2 Using Words in IF Functions
4.3
more...
Excel 2000 Advanced
...
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)
4.1 IF Functions and Relational Operators (> =
)
4.2 Using Words in IF Functions
4.3
more...
