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 2013 Level 2 Overview


Unit 1: Managing workbooks and worksheets

  • Topic A: Viewing large worksheets
  • Topic B: Printing large worksheets
  • Topic C: Working with multiple worksheets
  • Topic D: Linking worksheets with 3-D formulas
  • Topic E: Using multiple workbooks
  • Topic F: Linking workbooks

Unit 2: Advanced formatting

  • Topic A: Using special number formats
  • Topic B: Working with themes
  • Topic C: 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: Data structure and tables

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

Unit 6: Web and sharing features

  • Topic A: Saving workbooks as Web pages
  • Topic B: Using hyperlinks

Unit 7: Documenting and auditing

  • Topic A: Auditing features
  • Topic B: Comments in cells and workbooks
  • Topic C: Protection
  • Topic D: Workgroup collaboration

Unit 8: Application settings and templates

  • Topic A: Application settings
  • Topic B: Working with templates

 

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.