Learn Excel 2013- Part 1

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets.

COURSE OBJECTIVES

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will:

  • Get started with Microsoft Office Excel 2013
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks
  • Manage workbooks.

COURSE OUTLINE

1 – GETTING STARTED WITH MICROSOFT OFFICE EXCEL 2013

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter Cell Data

Use Excel Help

2 – PERFORMING CALCULATIONS

Create Worksheet Formulas

Insert Functions

Reuse Formulas

3 – MODIFYING A WORKSHEET

Insert, Delete, and Adjust Cells, Columns, and Rows

Search for and Replace Data Use

Proofing and Research Tools

4 – FORMATTING A WORKSHEET

Modify Fonts

Add Borders and Colors to Worksheets

Apply Number Formats

Align Cell Contents

Apply Styles and Themes

Apply Basic Conditional Formatting

Create and Use Templates

5 – PRINTING WORKBOOKS

Preview and Print a Workbook

Define the Page Layout

6 – MANAGING WORKBOOKS

Manage Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties