Excel 2013

Advanced

Lesson 1: Using Conditional Formatting

Topic A: Applying Conditional Formatting

Topic B: Applying Multiple Rule Sets

Topic C: Creating Custom Rule Sets

Topic D: Viewing and Managing Rules

Topic E: Clearing Custom Rules

Lesson 2: Working with Slicers

Topic A: Inserting and Using a Slicer

Topic B: Renaming the Slicer

Topic C: Changing Slicer Settings

Topic D: Formatting a Slicer

Topic E: Clearing the Slicer

Lesson 3: Using the Inquire Add-In

Topic A: Installing Inquire

Topic B: Generating a Workbook Analysis Report

Topic C: Viewing Workbook and Worksheet Relationships

Topic D: Viewing Cell Relationships

Topic E: Comparing Two Workbooks

Lesson 4: Working with Tables

Topic A: What is a Table?

Topic B: Creating Tables

Topic C: Resizing the Table

Topic D: Choosing a Table Style

Topic E: Clearing the Table

Lesson 5: Working with Records and Fields

Topic A: What are Records and Fields?

Topic B: Adding Fields by Inserting Columns

Topic C: Adding Records by Inserting Rows

Topic D: Deleting Records or Fields

Lesson 6: Using Excel as a Database

Topic A: Filtering with Wildcard Characters

Topic B: Validating Your Data

Topic C: Data Validation Using Lists

Topic D: Data Validation Using Formulas

Topic E: Using Database Functions

Lesson 7: Using Custom AutoFill Lists

Topic A: Creating a Custom AutoFill List

Topic B: Using a Custom AutoFill List

Topic C: Modifying a Custom AutoFill List

Topic D: Deleting a Custom AutoFill List

Lesson 8: Using Comments

Topic A: Inserting Comments

Topic B: Editing Comments

Topic C: Navigating Through Comments

Topic D: Deleting Comments

Lesson 9: Tracking Changes

Topic A: Tracking Changes

Topic B: Reviewing Changes

Topic C: Setting Options for Tracking Changes

Topic D: Stopping Tracking Changes

Lesson 10: Linking, Consolidating, and Combining Data

Topic A: Linking Workbooks

Topic B: Consolidating Workbooks

Topic C: Consolidating Worksheets

Topic D: Pivoting Consolidated Data

Comments are closed, but trackbacks and pingbacks are open.