
School
of Business Administration
Decision and Information Sciences
421 N. Woodland Boulevard (Unit 8398)
386-822-7464
pgleason@stetson.edu
|
Excel Tutorial 2 – Formatting a Workbook |
Key # |
Time |
|
Formatting |
|
|
|
Using the Merge and Center command |
1:44 |
|
|
Formatting numbers using the ribbon |
2:37 |
|
|
Rotating information in a cell |
2:16 |
|
|
Wrapping text in a cell |
0:39 |
|
|
Using the Borders command |
1:49 |
|
|
Drawing cell borders |
1:39 |
|
|
Formatting information using the format cells dialog box |
3:03 |
|
|
Manipulating Columns and Rows |
|
|
|
Selecting columns and rows pt. 1 |
2:29 |
|
|
Selecting columns and rows pt. 2 |
1:46 |
|
|
Changing column width |
3:08 |
|
|
Changing row height |
3:08 |
|
|
Hiding and unhiding columns and rows |
2:49 |
|
|
Inserting columns |
2:50 |
|
|
Inserting rows |
2:27 |
|
|
Deleting columns and rows |
2:37 |
|
|
Inserting and deleting cells |
2:32 |
|
|
Styles – Cells & Tables |
|
|
|
Using cell styles |
1:50 |
|
|
Creating a custom cell style by example |
2:12 |
|
|
Creating a custom cell style |
3:00 |
|
|
Using themes |
0:46 |
|
|
Customizing themes |
1:13 |
|
|
Formatting as a table pt. 1 |
1:44 |
|
|
Formatting as a table pt. 2 |
2:27 |
|
|
Manipulating Worksheets/Documentation |
|
|
|
Activating and moving between worksheets |
2:53 |
|
|
Selecting multiple worksheets |
2:31 |
|
|
Adding a worksheet to a workbook |
2:26 |
|
|
Deleting a worksheet from a workbook |
1:04 |
|
|
Changing the name of a worksheet |
1:54 |
|
|
Changing the sheet tab color |
0:59 |
|
|
Rearranging the worksheets pt. 1 |
2:16 |
|
|
Rearranging the worksheets pt. 2 |
2:42 |
|
|
Splitting the worksheet window |
2:27 |
|
|
Freezing and unfreezing panes |
2:33 |