Keystone Training Tapes

Intermediate Excel

(2 Hrs 5 Mins)

1.0 Changing Worksheet Layout (26 Mins)

1.1 Inserting Columns

1.2 Deleting Columns

1.3 Moving Cells

1.4 Copying Cells

2.0 Additional Formatting (6 Mins)

2.1 Formatting Cell Attributes & Alignment

2.2 Borders

2.3 Numeric Formatting

2.4 Center Text across Columns

2.5 Hiding & Unhiding Columns & Rows

3.0 Printing (25 Mins)

3.1 Using Print Preview & Page Setup

3.2 Printing Controls

3.3 Using Page Break Preview

4.0 Using Cell References (29 Mins)

4.1 Absolute References

5.0 Tools Options Command (18 Mins)

5.1 Show/Hide Gridlines

5.2 Show/Hide Formulas

5.3 Recently used Files List

5.4 Sheets in New Workbook

5.5 Default Settings