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