91014: Microsoft Office Excel 2013: Part 1

Microsoft Office Excel 2013: Part 1 is a one-day course that teaches you a foundational understanding of the basic functionality in Excel 2013. You will begin by navigating the Excel 2013 environment. From there, you will perform the basic tasks associated with creating and saving Excel worksheets and exploring the Help system. You will use formulas and functions to perform calculations in your worksheets, and you will modify worksheets by manipulating cells and data, by searching for and replacing data, and by checking for spelling errors. You will format worksheets and prepare them for printing. You will also begin working with larger workbooks that contain multiple worksheets. Finally, you will customize how Excel behaves to more closely meet your needs.

Exam Number:
77-427
Exam Name:
Excel 2013 Expert Part One
Certifications:
MOS
Duration:
1 Day

Upcoming Dates

Apply
Class Date Class Hours Location GTR Price  

What's Included

  • Digital Microsoft Official Curriculum (dMOC)

Course Content

Upon completing this course you will be able to:

  • Get started with Excel 2013
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbook contents
  • Manage large workbooks
  • Customize the Excel environment

Course Outline

Lesson 1: Getting Started with Microsoft Excel 2013

  • Topic A: Identify the Elements of the Excel Interface
  • Topic B: Create a Basic Worksheet
  • Topic C: Use the Help System

Lesson 2: Performing Calculations

  • Topic A: Create Formulas in a Worksheet
  • Topic B: Insert Functions in a Worksheet
  • Topic C: Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Topic A: Manipulate Data
  • Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Topic C: Search for and Replace Data
  • Topic D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  • Topic A: Modify Fonts
  • Topic B: Add Borders and Colors to Cells
  • Topic C: Apply Number Formats
  • Topic D: Align Cell Contents
  • Topic E: Apply Cell Styles

Lesson 5: Printing Workbook Contents

  • Topic A: Define the Basic Page Layout for a Workbook
  • Topic B: Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

  • Topic A: Format Worksheet Tabs
  • Topic B: Manage Worksheets
  • Topic C: Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

  • Topic A: Customize the General and Language Options
  • Topic B: Customize Formula Options
  • Topic C: Customize Proofing and Save Options
  • Topic D: Customize the Ribbon and Quick Access Toolbar
  • Topic E: Customize the Functionality of Excel by Enabling Add-Ins
  • Topic F: Customize Advanced and Trust Center Options