Microsoft Excel 2010 Level 1 Introduction

1 day

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.

Course Outline

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