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