Excel Intermediate

 

Excel Intermediate 2010

Topics:

Lesson 1: Managing Workbooks

  • Topic A: Managing Worksheets
  • Topic B: Customizing Excel

 

Lesson 2: Named Ranges  

  • Topic A: Using Names in Formulas

 

Lesson 3: Tables

  • Topic A: Sorting
  • Topic B: Filtering Tables
  • Topic C: Validation
  • Topic D: Transposing Data

 

Lesson 4: Summarizing Data

  • Topic A: Consolidation
  • Topic B: Subtotals

 

Lesson 5: PivotTables

  • Topic A: Creating and Formatting PivotTables
  • Topic B: Manipulating PivotTables
  • Topic C: PivotCharts

 

Lesson 6: Presentation Features

  • Topic A: Conditional Formats
  • Topic B: Graphics

Lesson 7: Advanced Charts

  •  Topic A: Special Chart Types
  • Topic B: Sparklines

 

Lesson 8: Collaboration

  • Topic A: Permissions
  • Topic B: Shared Workbooks
  • Topic C: Web Features

 

Course Hours: 8 hours

 


Excel Intermediate 2013

Topics:

Lesson 1: Managing Workbooks

  • Topic A: Managing Worksheets
  • Topic B: Customizing Excel

 

Lesson 2: Named Ranges  

  • Topic A: Using Names in Formulas

 

Lesson 3: Tables

  • Topic A: Sorting
  • Topic B: Filtering Tables
  • Topic C: Validation
  • Topic D: Transposing Data

 

Lesson 4: Summarizing Data

  • Topic A: Consolidation
  • Topic B: Subtotals

Lesson 5: PivotTables

  • Topic A: Creating and Formatting PivotTables
  • Topic B: Manipulating PivotTables
  • Topic C: PivotCharts

 

Lesson 6: Presentation Features

  • Topic A: Conditional Formats
  • Topic B: Graphics

 

Lesson 7: Advanced Charts

  • Topic A: Special Chart Types
  • Topic B: Sparklines

 

Lesson 8: Collaboration

  • Topic A: Permissions
  • Topic B: Shared Workbooks
  • Topic C: Web Features

 

Course Hours: 8 hours

 


Excel Intermediate 2016

Topics:

Lesson 1: Managing Workbooks

  • Topic A: Managing Worksheets
  • Topic B: Customizing Excel

 

Lesson 2: Named Ranges  

  • Topic A: Using Names in Formulas

 

Lesson 3: Tables

  • Topic A: Sorting
  • Topic B: Filtering Tables
  • Topic C: Structured References
  • Topic D: Validation
  • Topic E: Transposing Data

 

Lesson 4: Summarizing Data

  • Topic A: Consolidation
  • Topic B: Subtotals

 

Lesson 5: PivotTables

  • Topic A: Creating and Formatting PivotTables
  • Topic B: Manipulating PivotTables
  • Topic C: PivotCharts

 

Lesson 6: Presentation Features

  • Topic A: Conditional Formats
  • Topic B: Custom Formats
  • Topic C: Graphics

 

Lesson 7: Advanced Charts

  • Topic A: Special Chart Types
  • Topic B: Sparklines
  • Topic C: Quick Analysis

 

Lesson 8: Collaboration

  • Topic A: Permissions
  • Topic B: Shared Workbooks

 

Course Hours: 8 hours