Keystone Training Tapes

Excel

Beginning (2 Hrs 16 Mins)

1.0 The Excel Screen (32 Mins)

1.1 The Excel Workbook & Worksheets

1.2 Title Bar & Menu Bar

1.3 Toolbars

1.4 Formula Bar

1.5 Columns & Rows

1.6 Navigation

1.7 Sheet Names & the Status Bar

1.8 Mouse Pointers & Shortcut Menus

2.0 Entering Data into a Worksheet (27 Mins)

2.1 Data Entry Techniques

2.4 Auto Complete

3.1 Three Methods of Entering Formulas

3.2 Repeating a Formula

3.3 Formulas Beyond Addition & Subtraction

4.0 Basic Functions (21 Mins)

4.1 Summation

4.2 Recalculating Effects

4.3 Averages

5.0 Formatting (13 Mins)

5.1 The Formatting Toolbar

6.0 Saving (17 mins)

6.1 File Save or File Save as

6.2 Opening a File

6.3 Closing a File

6.4 Creating a new Workbook