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



  • Lesson 1: Customizing the Excel Environment

    • Topic A: Configure Excel Options

    • Topic B: Customize the Ribbon and the Quick Access Toolbar

    • Topic C: Enable Excel Add-Ins



  • Lesson 2: Creating Advanced Formulas

    • Topic A: Use Range Names in Formulas

    • Topic B: Use Specialized Functions

    • Topic C: Use Array Formulas



  • Lesson 3: Analyzing Data with Functions and Conditional Formatting

    • Topic A: Analyze Data by Using Text and Logical Functions

    • Topic B: Apply Advanced Conditional Formatting



  • Lesson 4: Organizing and Analyzing Datasets and Tables

    • Topic A: Create and Modify Tables

    • Topic B: Sort Data

    • Topic C: Filter Data

    • Topic D: Use SUBTOTAL and Database Functions



  • Lesson 5: Visualizing Data with Basic Charts

    • Topic A: Create Charts

    • Topic B: Modify and Format Charts



  • Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

    • Topic A: Create a PivotTable

    • Topic B: Analyze PivotTable Data

    • Topic C: Present Data with PivotCharts

    • Topic D: Filter Data by Using Slicers



  • Appendix A: Microsoft Office Excel 2013 Exam 77-420

  • Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428

  • Appendix C: Financial Functions

  • Appendix D: Date and Time Functions

  • Appendix E: Working with Graphical Objects


 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 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.