1. Understanding Excel List Structure

2. Sorting a List Using Single Level Sort

3. Sorting a List Using Multi-Level Sorts

4. Using Custom Sorts in an Excel List

5. Filter an Excel List Using the AutoFilter Tool

6. Creating Subtotals in a List

7. Format a List as a Table

8. Using Conditional Formatting to Find Duplicates

9. Removing Duplicates

1. Why PowerPivot

1. Excel Function DSUM()

2. Excel Function DAVERAGE()

3. Excel Function DCOUNT()

4. Excel Function SUBTOTAL()

4. Dynamic Formulas by Using Validation Techniques

2. Creating a Validation List

3. Adding a Custom Validation Error

4. Dynamic Formulas by Using Validation Techniques

2. Importing Data from Microsoft Access

3. Exporting Data to a Text File

1. Understanding Excel PivotTables

2. Creating an Excel PivotTable

3. Modifying Excel PivotTable Calculations

4. Grouping PivotTable Data

5. Formatting PivotTable Data

6. Drilling Down into PivotTable Data

7. Creating PivotCharts

8. Filtering with the Slicer Tool

1. Importing Data from Text Files

2. Activating the Excel PowerPivot AddIn

3. Creating Data Models with PowerPivot

4. Creating PivotTables based on Data Models

5. PowerPivot Calculated Fields

6. PowerPivot KPIs

1. Using the Freeze Panes Tool

2. Grouping Data (Columns and or Rows)

3. Print Options for Large Sets of Data

4. Linking Worksheets (3D Formulas)

5. Consolidating Data from Multiple Worksheets