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
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
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  

To Inquire About Future Classes

Request a class date

if one is not scheduled.