Excel 2007 Basic Study Guide

1-4239-1810-X © 2008 Publish date: March 31, 2007 240 pages

 

Microsoft Excel 2007 Training Courseware
Basic Level	$25.99
<="style5 style8">** Unlimited Courseware Printing License:	Call 1-866-718-7246

 

Courseware ID: excel-2007-basic-sg

Learn how to use the basic features of Microsoft Excel 2007 by choosing from our series of computer training books dedicated to teaching you the basic, intermediate, and advanced portions of this spreadsheet program. The Excel 2007 Basic study guide has earned an overall quality rating of 4.9/5.0 in overall quality from ProCert Labs. By choosing this first course in the series, you will learn the basic functions and features found in the 2007 edition of Excel.

This Microsoft Excel training coursware is approved courseware for the Microsoft Certified Application Specialist program along with our intermediate and advanced Excel 2007 study guides. The entire series helps you prepare for the Excel 2007 exam (70-602).

First, you will learn about spreadsheet terminology and explore Excel's environment before moving on to the Help system and navigating worksheets and workbooks. This Excel 2007 courseware will help you get comfortable with the layout of the program. In fact, this course will help seasoned Excel users get familiar with the new look and layout in the 2007 release.

Next, you will learn about entering and editing text, values, formulas, and graphics as well as saving your workbooks in a variety of different formats. Moving and copying data is covered as are absolute and relative references and working with ranges, rows, and columns.

Other topics you'll explore in the Excel 2007 courseware include simple functions, printing, basic formatting techniques, creating charts, and managing large workbooks.

Courseware Objectives

By choosing this course, you will learn how to start Microsoft Excel, become comfortable exploring its environment, use the Help features, and navigate workbooks and worksheets.

You will also be able to add text, formulas, and pictures into your worksheets, move and copy data, insert and delete ranges, use AutoFill, and work with relative and absolute references. You will know how to format text, numbers, columns, and rows as well as how to use conditional formatting. You'll be able to use table formats and copy formats.

The Excel 2007 courseware teaches you how to use basic functions including SUM, AutoSum, AVERAGE, MIN, MAX, COUNT, and COUNTA in order to perform calculations. You will also learn about previewing and controlling Page Setup options, checking spelling, finding and replacing data, printing, working with charts, and managing large worksheets and multiple worksheets.

Courseware Contents

Unit 1 introduces Excel

• Spreadsheet terminology
• Exploring Excel's environment
• Getting help
• How to navigate workbooks

Unit 2 covers entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Working with graphics and pictures
• Saving and updating your workbooks

Unit 3 goes over modifying a worksheet

• How to move and copy data
• How to move and copy formulas
• Absolute and relative references
• How to insert and delete ranges, rows, and columns

Unit 4 covers functions

• Entering functions
• AutoSum
• Other useful Excel functions

Unit 5 goes over formatting worksheets

• How to format text
• How to format rows and columns
• How to format numbers
• Conditional formatting
• Copying formats
• Applying table formats

Unit 6 covers printing

• Preparing to print a worksheet
• Page Setup options
• Printing worksheets

Unit 7 discusses creating charts

• Chart basics
• How to modify charts
• How to print charts

Unit 8 covers managing large workbooks

• Viewing large worksheets
• How to print large worksheets
• Working with multiple worksheets