Professor Gleason

Stetson UniversitySchool of Business Administration
Decision and Information Sciences
421 N. Woodland Boulevard (Unit 8398)
 386-822-7464
 pgleason@stetson.edu

 

Atomic Learning - Excel Tutorial 2

Excel Tutorial 2 – Formatting a Workbook

Key #

Time

Formatting

 

 

Using the Merge and Center command

28680

1:44

Formatting numbers using the ribbon

28668

2:37

Rotating information in a cell

28678

2:16

Wrapping text in a cell

28679

0:39

Using the Borders command

28681

1:49

Drawing cell borders

28682

1:39

Formatting information using the format cells dialog box

28683

3:03

Manipulating Columns and Rows

 

 

Selecting columns and rows pt. 1

28685

2:29

Selecting columns and rows pt. 2

28686

1:46

Changing column width

28687

3:08

Changing row height

28688

3:08

Hiding and unhiding columns and rows

28689

2:49

Inserting columns

28690

2:50

Inserting rows

28691

2:27

Deleting columns and rows

28692

2:37

Inserting and deleting cells

28693

2:32

Styles – Cells & Tables

 

 

Using cell styles

28694

1:50

Creating a custom cell style by example

28695

2:12

Creating a custom cell style

28696

3:00

Using themes

28705

0:46

Customizing themes

28706

1:13

Formatting as a table pt. 1

28700

1:44

Formatting as a table pt. 2

28701

2:27

Manipulating Worksheets/Documentation

 

 

Activating and moving between worksheets

30871

2:53

Selecting multiple worksheets

30872

2:31

Adding a worksheet to a workbook

30873

2:26

Deleting a worksheet from a workbook

30874

1:04

Changing the name of a worksheet

30875

1:54

Changing the sheet tab color

30876

0:59

Rearranging the worksheets pt. 1

30877

2:16

Rearranging the worksheets pt. 2

30878

2:42

Splitting the worksheet window

30883

2:27

Freezing and unfreezing panes

30884

2:33