Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Microsoft Excel 2010 Level 2 Overview


Unit 1: Using multiple worksheets and workbooks

  • Topic A: Using multiple workbooks
  • Topic B: Linking worksheets with 3-D formulas
  • Topic C: Linking workbooks
  • Topic D: Managing workbooks

Unit 2: Advanced formatting

  • Topic A: Using special number formats
  • Topic B: Using functions to format text
  • Topic C: Working with styles
  • Topic D: Working with themes
  • Topic E: Other advanced formatting

Unit 3: Outlining and subtotals

  • Topic A: Outlining and consolidating data
  • Topic B: Creating subtotals

Unit 4: Cell and range names

  • Topic A: Creating and using names
  • Topic B: Managing names

Unit 5: Tables

  • Topic A: Sorting and filtering data
  • Topic B: Advanced filtering
  • Topic C: Working with tables

Unit 6: Advanced charting

  • Topic A: Chart formatting options
  • Topic B: Combination charts
  • Topic C: Graphical elements

Unit 7: PivotTables and PivotCharts

  • Topic A: Working with PivotTables
  • Topic B: Rearranging PivotTables
  • Topic C: Formatting PivotTables
  • Topic D: Using PivotCharts

 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 8/3/2017
 $199
Enroll
 8/3/2017
 $199
Enroll
 10/11/2017
 $199
Enroll
 10/11/2017
 $199
Enroll
 12/8/2017
 $199
Enroll
 12/8/2017
 $199
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.