Home > Training > Professional Technical Education > Classes Offered

Excel 2010: Beginners

In this course, students will use Microsoft Office Excel 2010 to manage, edit, and print data. This course will be useful if you manage data, create charts, or perform basic mathematical analysis. This class is intended for beginners. Excel is a powerful, easy to use application that will be of great benefit in management of your data.

Course Outline

Creating a Basic Worksheet
Explore the User Interface and the Ribbon
Navigate and Select in Excel
Enter Data and Save a Workbook

Performing Calculations
Work with Basic Formulas and Functions

Modifying a Worksheet
Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet

Formatting a Worksheet
Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents

Printing Workbook Contents
Print Workbook Contents
Manage Print Options
Set Page Breaks

Managing Large Workbooks
Format Worksheet Tabs
Manage Worksheets in a Workbook
Freeze Rows and Columns
Split the View of Large Worksheets