Microsoft Office Excel Foundation

Prerequisites

To ensure success, participants will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to use Windows to manage information on their computers.

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. Perform calculations. Modify a worksheet. Format a worksheet. Print workbooks. Manage workbooks.

Getting Started with Microsoft Office Excel

Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help

Performing Calculations

Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions

Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

Formatting a Worksheet

Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

Printing Workbooks

Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers

Managing Workbooks

Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties