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 1 Overview



  • Lesson 1: Getting Started with Microsoft Office Excel 2013

    • Topic A: Navigate the Excel User Interface

    • Topic B: Use Excel Commands

    • Topic C: Create and Save a Basic Workbook

    • Topic D: Enter Cell Data

    • Topic E: Use Excel Help



  • Lesson 2: Performing Calculations

    • Topic A: Create Worksheet Formulas

    • Topic B: Insert Functions

    • Topic C: Reuse Formulas



  • Lesson 3: Modifying a Worksheet

    • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

    • Topic B: Search for and Replace Data

    • Topic C: Use Proofing and Research Tools



  • Lesson 4: Formatting a Worksheet

    • Topic A: Modify Fonts

    • Topic B: Add Borders and Colors to Worksheets

    • Topic C: Apply Number Formats

    • Topic D: Align Cell Contents

    • Topic E: Apply Styles and Themes

    • Topic F: Apply Basic Conditional Formatting

    • Topic G: Create and Use Templates



  • Lesson 5: Printing Workbooks

    • Topic A: Preview and Print a Workbook

    • Topic B: Define the Page Layout



  • Lesson 6: Managing Workbooks

    • Topic A: Manage Worksheets

    • Topic B: Manage Workbook and Worksheet Views

    • Topic C: Manage Workbook Properties



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

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

  • Appendix C: Microsoft Excel 2013 Common Keyboard Shortcuts


 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 10/10/2017
 $199
Enroll
 10/10/2017
 $199
Enroll
 12/7/2017
 $199
Enroll
 12/7/2017
 $199
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.