Integrity Training – Microsoft Office Excel 2010: Intermediate

Outlining and Subtotals (0:18)

Topic A: Outlining and Consolidating Data (0:05)

The Expanded Outline Form (0:47)

The Collapsed Outline Form (0:38)

Demo – A-1: Creating an Outline (2:49)

Create a Custom View (0:41)

Switch Among Custom Views (0:22)

Demo – A-2: Creating Custom Views (1:42)

The Consolidate Dialog Box (1:25)

Demo – A-3: Using the Consolidate Command (4:19)

Topic B: Creating Subtotals (0:04)

The Subtotal Dialog Box (1:25)

Demo – B-1: Creating Subtotals in a List (3:01)

Demo – B-2: Using Multiple Subtotal Functions (1:57)

Unit 03 Review (0:17)

Unit 03 Quiz

Cell and Range Names (0:19)

Topic A: Creating and Using Names (0:05)

Defining Names (0:50)

Demo – A-1: Naming and Selecting Ranges (1:21)

Using Names in Formulas (0:51)

Demo – A-2: Using Names in Formulas (1:49)

Using Create from Selection (1:07)

Demo – A-3: Using the Create from Selection Command (2:12)

Applying Names (1:07)

Demo – A-4: Applying Names to Existing Formulas (4:14)

Topic B: Managing Names (0:05)

The Name Manager Dialog Box (0:43)

Demo – B-1: Modifying and Deleting Named Ranges (2:15)

Creating a 3-D Name (1:26)

Demo – B-2: Defining and Applying 3-D Names (2:26)

Unit 04 Review (0:15)

Unit 04 Quiz

Tables (0:23)

Topic A: Sorting and Filtering Data (0:05)

Structure of Organized Data (1:24)

Sorting Data Based on a Cell (0:37)

Sorting by Multiple Columns (0:45)

Demo – A-2: Sorting Data (1:29)

Filtering Data (0:44)

Sort and Filter by Color (1:05)

Demo – A-3: Filtering Data by Using AutoFilter (2:23)

Topic B: Advanced Filtering (0:09)

Custom AutoFilter Dialog Box (0:56)

Demo – B-1: Using Custom AutoFilter Criteria (1:50)

Creating a Criteria Range (0:51)

Demo – B-2: Using the Advanced Filter Dialog Box (2:45)

Copying the Filtered Data (1:14)

Topic C: Working with Tables (0:04)

Creating a Table (1:02)

Table Tools | Design Tab (1:00)

Adding to a Table (0:35)

Demo – C-1: Creating a Table (0:51)

Demo – C-2: Formatting a Table (1:13)

Demo – C-3: Adding and Deleting Rows and Columns (1:35)

Structured References (1:07)

Demo – C-4: Using Structured References (1:17)

Table Names (0:28)

The [@] Argument (1:02)

Unit 05 Review (0:24)

Unit 05 Quiz

Web and Sharing Features (0:20)

Topic A: Saving Workbooks as Web Pages (0:05)

Customizing the Quick Access Toolbar (0:27)

Saving a Workbook as a Web Page (0:38)

Demo – A-2: Saving a Workbook as a Web Page (1:42)

Publishing a Web Page (0:30)

The Publish as Web Page Dialog Box (0:54)

Topic B: Using Hyperlinks (0:05)

Inserting a Hyperlink (0:39)

Demo – B-1: Inserting a Hyperlink (2:21)

Modify a Hyperlink (0:47)

Demo – B-2: Modifying and Deleting a Hyperlink (2:02)

Topic C: Sharing Workbooks (0:05)

File Save & Send Page Options (0:14)

Demo – C-1: Examining Workbook Sharing Options (0:48)

Save & Send Options (1:29)

Sharing Workbooks by Email (0:23)

Unit 06 Review (0:20)

Unit 06 Quiz

Advanced Charting (0:20)

Topic A: Chart Formatting Options (0:05)

Format Axis: Axis Options (0:52)

Demo – A-1: Adjusting the Scale of a Chart (1:14)

Labeling a Data Point (0:21)

Demo – A-2: Formatting a Data Point (2:07)

Topic B: Combination Charts (0:04)

Combination Chart: Changing Chart Type (0:23)

Combination Chart: Adding a Secondary Axis (0:22)

Demo – B-1: Creating a Combination Chart (1:20)

Adding a Trendline (0:22)

Demo – B-2: Creating a Trendline (0:43)

Inserting Sparklines (0:48)

Sparklines in a Worksheet (0:24)

Demo – B-3: Inserting Sparklines (1:39)

Downloading a Chart Template (1:44)