Module 2: Customize the Excel 2010 Program WindowThis module explains how to change the Excel program window, including the user interface, to suit your personal working style and the types of data collections you work with.

Lessons

Zooming In on a Worksheet

Arranging Multiple Workbook Windows

Adding Buttons to the Quick Access Toolbar

Customizing the Ribbon

Maximizing Usable Space in the Program Window

Lab : Maximizing Usable Space in the Program Window

Change the zoom level; switch between workbooks; cascade workbooks in the program window; add a button to the Quick Access Toolbar; customize the ribbon

After completing this module, students will be able to:

Modify how Excel displays worksheets.

Zoom in on worksheet data.

Hide, display, and reorder ribbon tabs.

Create custom tabs to make commands more accessible.

Module 3: Work with Data and Excel TablesThis module explains how to use Excel tools to enter and manage worksheet data effectively.

Lessons

Entering and Revising Data

Moving Data Within a Workbook

Finding and Replacing Data

Correcting and Expanding Upon Worksheet Data

Defining Excel Tables

Lab : Entering and Revising Data

Enter data by using multiple methods; control how Excel formats an extended data series

Lab : Moving Data Within a Workbook

Lab: Moving Data Within a Workbook

Lab : Finding and Replacing Data

Find and replace data and formatting

Lab : Correcting and Expanding Upon Worksheet Data

Check spelling; work with the dictionary, thesaurus, and translation tools

Module 5: Print Workbook ContentThis module explains how to configure worksheets to convey the greatest possible amount of information and then print all or part of the worksheet.

Lessons

Adding Headers and Footers to Printed Pages

Preparing Worksheets for Printing

Printing Worksheets

Printing Parts of Worksheets

Printing Charts

Lab : Adding Headers and Footers to Printed Pages

Create custom headers and footers

Lab : Preparing Worksheets for Printing

Set worksheet and workbook print options

Lab : Printing Worksheets

Print nonadjacent worksheets; suppress error printing

Lab : Printing Parts of Worksheets

Control the content, size, and location of printed worksheet content

Lab : Printing Charts

Print a chart

After completing this module, students will be able to:

Add headers and footers to worksheets.

Prepare worksheets for printing.

Print all or part of a worksheet.

Print charts.

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 7.

E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location