Audience

This course is designed for individuals interested inlearning the foundational skills necessary to create and develop Microsoft® Office Excel® 2013worksheets and workbooks in order to manipulate and analyze the data that is critical to the success of their organization. 

 

This course covers Microsoft Office Specialist exam objectives to help individuals prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam.

Description

Upon successful completion of this course, participants will be able to:

  • Get started with the Microsoft Office Excel 2013 user interface.
  • Create a basic worksheet.
  • Perform calculations.
  • Modify and format worksheets.
  • Print workbooks.
  • Manage workbooks.

 

Prerequisites

To ensure success, participants will need to be familiar with using personal computers, should have experience using a keyboard and mouse, and be familiar with Microsoft® Office Windows® user interface.

Suggested Class SizeMinimum 3
Maximum 12
Course LengthFull day
Table of Contents

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