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 1

Excel Tutorial 1 – Getting Started With Excel

Key#

Time

Introduction and Basics

 

 

Understanding a worksheet & entering information into cells

28642

2:16

Changing the default worksheets and cell movement

28643

2:30

Using AutoComplete

28651

2:05

Editing a cell

28652

2:01

Selecting cell ranges pt. 1

28654

2:54

Selecting cell ranges pt. 2

28655

3:01

Entering values in a cell range

28656

1:31

Using AutoFill

28657

2:27

Using the Clear command

28675

0:51

Functions and Formulas

 

 

Using autocalculate

28658

1:50

Using auto sum

28659

2:54

Creating formulas

28660

3:03

Using functions and the function wizard pt. 1

28661

2:07

Using functions and the function wizard pt. 2

28662

3:18

Editing formulas

28663

3:05

Checking formulas for errors

28664

1:33

Using relative cell referencing

28665

2:40

Displaying formulas

34861

0:32

Printing and print setups

 

 

Using Normal view

28707

1:22

Using Page Layout view

28708

2:07

Using Page Break preview

28709

3:34

Using the Page Layout command tab

28710

3:25

Changing the margins

28711

3:01

Changing the page orientation and paper size

28712

1:13

Creating headers and footers

28715

2:04

Using the Page Setup dialog box

28716

1:08

Using print preview

28717

1:30

Printing

28718

1:53

Printing selected ranges

28719

1:56