Excel 2

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

Contact