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 3

Excel Tutorial 3– Working with Formulas and Functions

Key #

Time

Advanced Functions

 

 

Using COUNT functions

30948

3:12

Using the IF function

30949

2:20

Using the VLOOKUP function

30950

2:32

Creating range names

30888

2:48

Using range names in formulas

30890

1:03

Understanding absolute cell references

28666

3:04

Creating an absolute cell reference

28667

1:37

Dates

 

 

Entering dates into a cell

34267

0:59

Formatting date entries

34268

0:46

Displaying the current date

34269

1:00

Generating a series of dates

34270

0:51

Using date related functions pt. 1

34271

3:06

Using date related functions pt. 2

34272

0:45

Sorting Data

 

 

Sorting data in a worksheet

34302

1:04

Sorting by multiple columns or criteria

34303

2:55