What You’ll Learn

After completing this module, students will be able to:

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

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

Course Outline

Lesson 1: Charts and Data Tables

This lesson explains how to create and modify charts and data tables.

• Creating Charts
• Designing a Table

Lab : Charts and Data Tables

• Create, modify, and move a chart first within the worksheet and then to its own chart sheet.
• Create a data table, add data, summarize the data, and rename the table.

Lesson 2: Calculations

This lesson explains how to create named ranges and how to create and edit formulas.

• Naming Groups of Data
• Creating Formulas to Calculate Values

Lab : Calculations

• Assign range names.
• Create and edit formulas that use table references, relative references, and absolute references.

Lesson 3: Printing

This lesson explains how to add headers and footers to printed pages and how to preview and set up a worksheet for printing. 

• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing

Lab : Printing

• Create a custom header and a footer containing a graphic.
• Preview a worksheet; change its margins, orientation, size, page breaks, and page printing order.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

Getting Certified

You may wish to consider the following MCAS certification associated with Microsoft Office Excel 2007:

• Microsoft Certified Application Specialist: Microsoft Office Excel 2007

To gain this certification, students need to pass Exam 77-602: MCAS: Using Microsoft Office Excel 2007.

Candidates for this exam should have the equivalent of six months to one year of hands-on experience creating business deliverables with Microsoft Office Excel 2007 and might have experience with previous versions of Microsoft Office Excel. These candidates are especially effective and efficient at creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

Is This Course Right For you?

This course is intended for novice information workers who want to learn beginning-level Excel 2007 skills.

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.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

Ask Us A Question

Live Chat

Why not ask one of our knowledgeable team to answer your question using our Live Chat?

Call Us

Our team are also on standby to answer your questions over the phone. Just call 0117 230 9689 now!