Courses

Lessons Include:

01: Creating a Pivot Table (12:14)
02: Summarizing data in a Pivot Table (8:38)
03: Grouping data in a Pivot Table (6:33)

Lessons Include:

01: Using Advanced Chart Features (4:44)
02: Applying Trendlines (4:36)
03: Creating and Applying Chart Templates (3:31)
04: Inserting Graphics (9:15)
05: Modifying Graphics (12:38)

Lessons Include:

01: Creating tables (6:45)
02: Modifying table styles (7:10)
03: Using the Quick Analysis shortcut (1:56)
04: Summarizing data in tables (4:35)

Lessons Include:

01: Querying data (7:16)
02: Using the SUBTOTAL function (4:43)
03: Using the SUBTOTAL feature (7:09)

Lessons Include:

01: Sorting data Part 1 (5:31)
02: Sorting data Part 2 (6:00)
03: Filtering data Part 1 (5:25)
04: Filtering data Part 2 (8:06)
05: Filtering data Part 3 (8:28)

Lessons Include:

01: Working with Text Functions Part 1 (4:22)
02: Working with Text Functions Part 2 (4:55)
03: Working with Text Functions Part 3 (3:49)
04: Working with Text Functions Part 4 (8:56)
05: Working with Math functions (7:55)
06: Calculations options (2:47)

Lessons Include:

01: Working with logical functions (9:03)
02: Working with conditional functions (8:16)
03: Multiple criteria functions (5:23)
04: Using nested functions (5:57)
05: Using IFS and SWITCH functions (6:21)

Lessons Include:

01: Working with date functions – Part 1 (9:15)
02: Working with date functions – Part 2 (4:38)
03: Working with date functions – Part 3 (3:41)
04: Working with time functions – (5:50)

Lessons Include:

01: Using named ranges – Part 1 (5:16)
02: Using named ranges – Part 2 (5:32)
03: Using named ranges – Part 3 (5:10)

Lessons Include

1. Navigating in Word, Part 1 10:26
2. Navigating in Word, Part 2 4:06
3. Creating Documents 7:03

Lessons Include

1. Selecting Text 3:45
2. Copying and Moving Text 7:01
3. Editing Paragraphs 4:20

Lessons Include

1. Applying Character Formatting 8:47
2. Controlling Paragraph Layout 4:26
3. Indenting Paragraphs 6:23