Course 50123A: Learn Microsoft® Office Excel® 2007 Step by Step, Level 1

Type:Course
Audience(s):information workers
Technology:Microsoft Excel
Level:100
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:1 day
Language(s):English

First published:

02 February 2009
Overview
About this course This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Office Excel 2007. Audience profile
This course is intended for novice information workers who want to learn beginning-level Excel 2007 skills.
At course completion
After completing this course, students will be able to:
  • Become familiar with the new user interface.
  • Create workbooks.
  • Modify workbooks.
  • Customize the Excel 2007 program window.
  • Enter and revise data.
  • Modify worksheets.
  • Move data within a workbook.
  • Find and replace data.
  • Correct and expand upon worksheet data.
  • Format cells.
  • Define styles.
  • Apply workbook themes and table styles.
  • Make numbers easier to read.
  • Create charts.
  • Define a table.
  • Name groups of data.
  • Create formulas to calculate values.
  • Add headers and footers to printed pages.
  • Prepare worksheets for printing.
Course details
Course OutlineModule 1: Introduction to Excel 2007This module discusses the new Excel interface and explains how to work with workbooks, including how to create and modify them. It also explains how to customize the Excel program window to suit your needs.Lessons
  • Becoming Familiar with the New User Interface
  • Creating Workbooks
  • Modifying Workbooks
  • Customizing the Excel 2007 Program Window
Lab : Introduction to Excel 2007
After completing this module, students will be able to:
  • Create and save workbooks.
  • Work with workbook properties.
  • Change the number, position, and names of sheets in a workbook.
  • Tailor the Excel program to meet their needs.
Module 2: DataThis module explains how to enter and edit worksheet data, rearrange data, find and replace specific information, and use tools to check spelling, find synonyms, and translate words.Lessons
  • Entering and Revising Data
  • Modifying Worksheets
  • Moving Data Within a Workbook
  • Finding and Replacing Data
  • Correcting and Expanding Upon Worksheet Data
Lab : Data
After completing this module, students will be able to:
  • Enter and modify worksheet content.
  • Move data within the same worksheet and from one worksheet to another.
  • Ensure that terms are used consistently throughout a worksheet.
  • Ensure that text data is spelled correctly.
  • Use words with precise meanings, as well as work with other languages.
Module 3: FormattingThis module explains how to format data, cells, and cell ranges; create and apply styles such as table styles and themes; and make data easier to read.Lessons
  • Formatting Cells
  • Defining Styles
  • Applying Workbook Themes and Table Styles
  • Making Numbers Easier to Read
Lab : Formatting
After completing this module, students will be able to:
  • Format cells by adding borders and shading.
  • Store and apply sets of formatting as a style.
  • Copy formatting by using the Format Painter.
  • Format entire worksheets with themes, and format data lists with table styles.
  • Assign formats to numbers to make them easier to read.
Module 4: Charts and Data TablesThis module explains how to create and modify charts and data tables.Lessons
  • Creating Charts
  • De?ning a Table
Lab : Charts and Data Tables
After completing this module, students will be able to:
  • Create, plot, resize, and move charts.
  • Create and modify data tables.
Module 5: CalculationsThis module explains how to create named ranges and how to create and edit formulas.Lessons
  • Naming Groups of Data
  • Creating Formulas to Calculate Values
Lab : Calculations
After completing this module, students will be able to:
  • Create and use named ranges.
  • Perform calculations that use formulas and reference cells in various ways.
Module 6: PrintingThis module explains how to add headers and footers to printed pages and how to preview and set up a worksheet for printing.Lessons
  • Adding Headers and Footers to Printed Pages
  • Preparing Worksheets for Printing
Lab : Printing
After completing this module, students will be able to:
  • Insert headers and footers to repeat the information at the top and bottom

    of the page.
  • Set up a worksheet so that it will look good when printed.
Prerequisites
Before attending this course, students must have:
  • Basic computer knowledge, such as keyboard and mouse skills.
  • Basic file-management skills. The student should know how to navigate to folders and files on a computer running Windows Vista.
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you