Publisher: Microsoft

Version: 2010
Length: 1 day
Course-ID: 084576

Course Overview

You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Target student

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.


Creating a Basic Excel Worksheet
  • Identify the Elements of the User Interface
  • Customize the Excel Interface
  • Work with Cells
  • Enter Data in an Excel Workbook
  • Obtain Help in Excel
Performing Calculations in an Excel Worksheet
  • Create Basic Formulas
  • Calculate the Cell Values by Using Functions
  • Copy Formulas and Functions
Modifying an Excel Worksheet
  • Manipulate Data
  • Modify the Worksheet Elements
  • Search for Data in a Worksheet
  • Modify Rows and Columns
Formatting an Excel Worksheet
  • Modify Fonts
  • Check a Worksheet for Spelling Errors
  • Apply Number Formatting
  • Add Borders and Colors to Cells
  • Align the Content in a Cell
  • Apply Cell Styles
Printing Excel Workbooks
  • Set the Page Layout Options
  • Set Page Breaks
  • Print a Workbook
Managing an Excel Workbook
  • Format Worksheet Tabs
  • Manage Worksheets
  • View Worksheets and Workbooks