Go! with Excel 2007 Comprehensive [With CDROM]

Author:: Shelley Gaskin; Karen Jolly
Format:: Spiral bound

Now:	R1,967.95
eBucks:	eB19680

United States of America

Delivery:: Usually within 16 working days.
Seller:: kalahari.com

E-mail

Email this product to a friend

Friend's email address

Your email address

Your name

Message (optional)

Cancel

Short description

The primary goal of the "GO!" Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package. "GO!"'s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features. Ideal for students and individuals seeking an introduction to Internet Explorer.

Long description

For Introductory Computer courses in Microsoft Office 2007 or courses in Computer Concepts with a lab component for Microsoft Office 2007 applications. Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package.

Product details

Publisher:: Pearson Prentice Hall
ISBN:: 9780132255592
Publication date:: November 2007
Additional format:: Contains Spiral bound and CD-ROM
Length:: 281mm
Width:: 239mm
Thickness:: 36mm
Weight:: 2454g
Edition:: 2nd Edition
Pages:: 1158
Illustrations:: Illustrated
Illustrated:: Illustrated

Chapter 1 Creating a Worksheet and Charting Data Project A Objective 1 Start Excel and Navigate a Worksheet Activity 1.1 Starting Excel and Naming and Saving a Workbook Activity 1.2 Navigating a Worksheet Objective 2 Select Parts of a Worksheet Activity 1.3 Selecting Parts of a Worksheet Objective 3 Enter Data, Construct a Formula, and Use the SUM Function Activity 1.4 Opening an Existing Workbook, Entering Text, and Using AutoComplete Activity 1.5 Entering Numbers and Adjusting Column Width Activity 1.6 Entering a Formula and Using the Sum Function Objective 4 Format a Worksheet Activity 1.7 Using Font Styles and Centering Text Activity 1.8 Using Merge and Center Objective 5 Insert a Footer in a Worksheet Activity 1.9 Adding a Footer to a Worksheet Objective 6 Delete Unused Worksheets and Preview and Print a Worksheet Activity 1.10 Deleting Unused Worksheets Activity 1.11 Previewing and Printing a Worksheet Objective 7 Print Formulas, Close a Workbook, and Exit Excel Activity 1.12 Displaying and Printing Formulas, Closing a Workbook, and Exiting Excel Objective 8 Check Spelling and Edit a Worksheet Activity 1.13 Opening and Saving an Existing Workbook Activity 1.14 Using Wrap Text and the Undo Command Activity 1.15 Checking for Spelling Errors in a Worksheet Activity 1.16 Editing Text in a Worksheet Project B Objective 9 Enter Data by Range Activity 1.17 Selecting Cells and Entering Data by Range Objective 10 Create and Copy Formulas Activity 1.18 Using the Point-and-Click Method and Calculation Operators to Create a Formula Activity 1.19 Using the Fill Handle to Copy a Formula Activity 1.20 Determining Percent of Rental Fees for Each Job FairObjective 11 Use Format Painter and Help Activity 1.21 Using Format Painter Activity 1.22 Using Help Objective 12 Chart Data Activity 1.23 Charting Data Activity 1.24 Printing the Worksheet and its Formulas Chapter 2 Using Multiple Sheet Workbooks Project A Objective 1 Use a Multiple-Sheet Workbook Activity 2.1 Inserting a Worksheet Activity 2.2 Changing the Format of Worksheet Tabs and Using the Tab Scrolling Buttons Objective 2 Enter a Series Activity 2.3 Entering a Series and Wrap Text Objective 3 Copy and Paste Cell Contents Activity 2.4 Using Copy and Paste Activity 2.5 Copying Data Between Worksheets Objective 4 Use the Clipboard Activity 2.6 Using the Clipboard to Copy and Paste Between Workbooks Objective 5 Total the Worksheet Range and Enter a Grand Total Activity 2.7 Totaling the Worksheet in One Step and Correcting Formula Errors Activity 2.8 Creating a Grand Total in One Step Objective 6 Format a Multiple-Sheet Workbook Group Activity 2.9 Formatting a Worksheet Group and Using Print Preview Objective 7 Insert Columns and Rows in Multiple Worksheets Activity 2.10 Inserting Columns in a Worksheet Activity 2.11 Inserting Rows that Adjust Relative References and Reviewing Error Alert Messages Project B Objective 8 Copy a Worksheet and Use Repeat Activity 2.12 Copying a Worksheet within a Workbook Activity 2.13 Inserting Columns Using Repeat Objective 9 Use Absolute Cell References and Copy Formats Activity 2.14 Creating a Formula that Uses an Absolute Cell Reference Activity 2.15 Copying Cells and Formats Objective 10 Find and Replace Text and Hide and Unhide Columns Activity 2.16 Using Find and Replace Activity 2.17 Hiding and Unhiding Columns Objective 11 Conduct a What-If Analysis and Use Statistical Functions Activity 2.18 Performing a What-If Analysis Activity 2.19 Using Statistical Functions Workshop: Planning a Worksheet Activity 2.20 Planning and Preparing a Worksheet Objective 12 Use Excel's Accuracy Tools Activity 2.21 Inserting a Worksheet into a Workbook Activity 2.22 Using Undo and Redo Activity 2.23 Clearing a Cell Activity 2.24 Identifying and Correcting Formula Errors Activity 2.25 Adding Footers and Determining Placement on Page to a Multiple-Sheet Workbook Chapter 3 Working with IF Functions and Large Worksheets Project A Objective 1 Use an If Functions Activity 3.1 Preparing a Payroll Report Workshop: How to Prepare a Payroll Activity 3.2 Entering IF Functions to Return Numeric Amounts Objective 2 Use Absolute Cell References Activity 3.3 Entering 3-D references Activity 3.4 Using Absolute Cell References Activity 3.5 Create a Conditional Format on the Results of the IF function Activity 3.6 Creating an IF function that returns text Objective 3 Add Information in Header and Footer Activity 3.7 Introducing Themes Activity 3.8 Changing a Theme Objective 4 Add Information in Header and Footer Activity 3.9 Inserting Page Numbers and other elements in a Header and Footer Activity 3.10 Adding a Picture to the Header Activity 3.11 Formatting the header and footer Project B Objective 5 Create Large Worksheet Activity 3.12 Completing and Formatting Large Worksheet Activity 3.13 Using Find and Replace Objective 6 Change Cell Format Activity 3.14 Changing Cell Alignment Activity 3.15 Changing Cell Formats Objective 7 Work with a Large Worksheet Activity 3.16 Freezing and Unfreezing Panes Activity 3.17 Using the GoTo Command Activity 3.18 Move Cell contents Activity 3.19 Arranging Worksheets and Splitting Worksheets Objective 8 Control Print Options Activity 3.20 Printing Gridlines and Headings Activity 3.21 Scaling, and Paper Size Activity 3.22 Setting Margins Activity 3.23 Previewing and Modifying Page Breaks Activity 3.24 Repeating Columns or Row Headings Activity 3.25 Setting and Clearing the Print Area Activity 3.26 Using Full Worksheet View Chapter 4 Creating Charts and and Lists Project A Objective 1 Create a Column Chart in a Chart Sheet Activity 4.1 Creating a 3-D Column Chart Activity 4.2 Changing Chart Type Workshop: Determine Which Chart to Use Objective 2 Modify a Column Chart Activity 4.3 Editing a Chart Title Activity 4.4 Adding, Axis Titles, Changing the Legend, and Editing Source Data Objective 3 Print a Chart Activity 4.5 Placing the chart in separate sheet Activity 4.6 Previewing and Printing a Chart Sheet Activity 4.7 Printing embedded chart only Objective 4 Create and Modify a 3-D Pie Chart Activity 4.8 Creating Pie Charts Activity 4.9 Inserting a Text box in chart Objective 5 Use Format Tools to Format a Chart Activity 4.10 Changing colors in a Chart Project B Objective 7 Sort Data Activity 4.11 Formatting as Table Activity 4.12 Sorting Data Quickly Activity 4.13 Sorting on multiple fields Activity 4.14 Displaying the table Objective 7 Convert Text to Columns Activity 4.15 Converting Text to Columns Activity 4.16 Converting names to two fields Activity 4.17 Removing Unneeded Spaces Objective 8 Use Conditional Format Activity 4.18 Highlighting Cell Rules Activity 4.19 Using Top/Bottom Rules Activity 4.20 Formatting with Data bars Activity 4.21 Formatting with Color Scales Activity 4.22 Using Icon Sets Activity 4.23 Sorting by Month Objective 9 Filter Data Activity 4.24 Filtering by text and Sorting Tables Activity 4.25 Sorting by color Activity 4.26 Filtering and Sorting by color Activity 4.27 Utilizing Filtered Lists Chapter 5 Using Statistical, Logical, and Financial Functions Project A Objective 1 Create Statistical Functions Activity 5.1 Using the Insert Function Command to Create the MEDIAN Function Activity 5.2 Using the Insert Function Command to Create the COUNT Function Activity 5.3 Using the Insert Function Command to Create the COUNTA Function (counts cells with data and text) Objective 2 Create Date & Time Functions Activity 5.4 Applying the DATE and NOW Functions Objective 3 Use Logical Functions and Comments Activity 5.5 Using an AND function Activity 5.6 Using a