- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
Used Trade Paper
Ships in 1 to 3 days
This title in other editions
Other titles in the Go! with Microsoft series:
Go! with Microsoft Excel Briefby Shelley Gaskin
Synopses & Reviews
The GO! System: Designed for Student Success!
The goal of the GO! Series is to provide you with the skills to solve business problems using the computer as a tool, for both yourself and the organization for which you might be employed. When you use the GO! Series in one of your courses, you use a “system” that includes a textbook, CD, and Companion Website with tools like videos and self-study aides.
Student CD Package
The Student CD package that comes with your book includes a CD to help you complete every project faster!
• Student Videos help you visually learn the skills in each chapter.
• Student Data Files needed to complete the projects in the textbook.
• Project-based so you learn by creating real world projects, not by reading long pages of text or simply practicing features of an application.
• Very clear instruction directs you first where to go, then what to do, when completing steps of the projects to help ensure you don’t get lost.
• Visual Summary shows you up front what your completed project will look like, and a File Guide clearly shows you which files are needed for each project and how to save the document.
• Lots of large screen shots allow you to check your work and make sure you are on the right track at numerous points in the project.
Student Companion Web Site: www.pearsonhighered.com/go
An interactive web site featuring self-study tools to help you succeed in this course!
• Online Study Guide provides practice of the chapter material by answering auto-graded objective questions.
• Glossary of key terms reinforces terminology as you learn the language of computing.
• Student Data Files needed to complete the projects in the book are downloadable from this site.
For introductory computer courses on Microsoft Excel 2010 or courses in computer concepts with a lab component on Excel.
Teach the course YOU want in LESS TIME!
The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.
The primary goal of the GO Series is to provide you with the skills to solve business problems using the computer as a tool as you practice and learn the features of Microsoft Office. This approach is based on clearly defined projects for readers in a way that's easy to understand. Coverage of Microsoft Word, Microsoft Excel, Microsoft Access, and Microsoft PowerPoint. MARKET: For professionals seeking to learn and understand Microsoft Office 2010.
About the Author
Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.
Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College. She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
Table of Contents
GO! with Excel 2010 Brief Table of Contents
Common Features Chapter 1 Using the Common Features of Office 2010 Scenario: Oceana Palm Grill Project 1A: Menu Plan
Objective 1 Use Windows Explorer to Locate Files and Folder Activity 1.01 Using Windows Explorer to Locate Files and Folders
Objective 2 Locate and Start a Microsoft Office 2010 Program Activity 1.02 Locating and Starting a Microsoft Office 2010 Program
Objective 3 Enter and Edit Text in an Office Program Activity 1.03 Entering and Editing Text in an Office Program
Objective 4 Perform Commands From a Dialog Box Activity 1.04 Performing Commands From a Dialog Box
Objective 5 Create a Folder, Save a File, and Close a Program Activity 1.05 Creating a Folder, Saving a File, and Closing a Program
Objective 6 Print a File Activity 1.06 Printing a File
Project 1B: Memo
Objective 7 Open an Existing File and Save it With a New Name Activity 1.07 Opening an Existing File and Saving it With a New Name
Objective 8 Explore Application Options Activity 1.08 Viewing Application Options
Objective 9 Perform Commands from the Ribbon Activity 1.09 Performing Commands from the Ribbon Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon
Objective 10 Apply Formatting in Office Programs Activity 1.11 Formatting and Viewing Pages Activity 1.12 Formatting Text Activity 1.13 Using the Office Clipboard to Cut, Copy, and Paste
Objective 11 Use the Microsoft Office 2010 Help System Activity 1.14 Using the Microsoft Office 2010 Help System in Excel
Objective 12 Compress Files Activity 1.15 Compressing Files
Chapter 1 Creating a Worksheet and Charting Data Scenario: Texas Spectrum Wireless Project 1A: Quarterly Sales Report with Embedded Column Chart
Objective 1 Create, Save, and Navigate an Excel Workbook Activity 1.01 Starting Excel and Naming and Saving a Workbook Activity 1.02 Navigating a Worksheet and a Workbook
Objective 2 Enter Data in a Worksheet Activity 1.03 Entering Text and Using AutoComplete Activity 1.04 Filling a Series with Auto Fill and Using Excel Keyboard Shortcuts Activity 1.05 Aligning Text and Adjusting the Size of Columns Activity 1.06 Entering Numbers
Objective 3 Construct and Copy Formulas and Use the Sum Function Activity 1.07 Constructing a Formula and Using the Sum Function Activity 1.08 Copying a Formula by Using the Fill Handle
Objective 4 Format Cells with Merge & Center and Cell Styles Activity 1.09 Using Merge & Center and Applying Cell Styles Activity 1.10 Formatting Financial Numbers
Objective 5 Chart Data in a Column Chart Activity 1.11 Charting Data in a Column Chart
Objective 6 Prepare a Worksheet for Printing and Close Excel Activity 1.12 Changing Views, Creating a Footer, and Using Print Preview Activity 1.13 Deleting Unused Sheets in a Workbook Activity 1.14 Printing a Worksheet Activity 1.15 Displaying, Printing, and Hiding Formulas
Project 1B: Inventory Valuation
Objective 7 Check Spelling in a Worksheet Activity 1.16 Checking Spelling in a Worksheet
Objective 8 Enter Data by Range Activity 1.17 Entering Data by Range
Objective 9 Construct Formulas for Mathematical Operations Activity 1.18 Using Arithmetic Operators Activity 1.19 Copying Formulas Containing Absolute Cell References
Objective 10 Edit Values in a Worksheet Activity 1.20 Editing Values in a Worksheet Activity 1.21 Formatting Cells with the Percent Style
Objective 11 Format a Worksheet Activity 1.22 Inserting and Deleting Rows and Columns Activity 1.23 Adjusting Column Widths and Wrapping Text
Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks Scenario: Laurales Herbs and Spices
Project 2A: Inventory Status Report
Objective 1 Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions Activity 2.01 Using the SUM and AVERAGE Functions Activity 2.02 Using the MEDIAN Function Activity 2.03 Using the MIN and MAX Functions
Objective 2 Move Data, Resolve Error Messages, and Rotate Text Activity 2.04 Moving Data and Resolving a # # # # Error Message Activity 2.05 Rotating Text
Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting Activity 2.06 Using the COUNTIF Function Activity 2.07 Using the IF Function Activity 2.08 Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars Activity 2.09 Using Find and Replace
Objective 4 Use Date & Time Functions and Freeze Panes Activity 2.10 Using the NOW Function to Display a System Date Activity 2.11 Freezing and Unvreezing Panes
Objective 5 Create, Sort, and Filter an Excel Table Activity 2.12 Creating an Excel Table Activity 2.13 Sorting and Filtering an Excel Table Activity 2.14 Converting a Table to a Range of Data
Objective 6 Format and Print a Large Worksheet Activity 2.15 Printing Titles and Scaling to Fit
Project 2B: Weekly Sales Summary
Objective 7 Navigate a Workbook and Rename Worksheets Activity 2.16 Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color Worksheets
Objective 8 Enter Dates, Clear Contents, and Clear Formats Activity 2.17 Entering and Formatting Dates Activity 2.18 Clearing Cell Contents and Formats
Objective 9 Copy and Paste Cell Contents Activity 2.19 Copying and Pasting Cell Contents
Objective 10 Edit and Format Multiple Worksheets at the Same Time Activity 2.20 Grouping Worksheets for Editing Activity 2.21 Formatting and Constructing Formulas on Grouped Worksheets
Objective 11 Create a Summary Sheet Activity 2.22 Constructing Formulas that Refer to Cells in Another Worksheet Activity 2.23 Changing Values in a Detail Worksheet to Update a Summary Worksheet
Objective 12 Format and Print Multiple Worksheets in a Workbook Activity 2.24 Moving and Formatting Worksheets in a Workbook Activity 2.25 Printing All the Worksheets in a Workbook
Chapter 3 Charting Data Scenario: City of Orange Blossom Beach Project 3A: Pie Chart Objective 1 Create a Pie Chart and a Chart Sheet Activity 3.01 Calculating Percentages Activity 3.02 Using Formula AutoComplete Activity 3.03 Creating a Pie Chart with a Chart Sheet
Objective 2 Format a Pie Chart Activity 3.04 Applying 3-D to a Pie Chart Activity 3.05 Rotating Slices in a Pie Chart Activity 3.06 Exploding and Coloring a Pie Chart Activity 3.07 Formatting the Chart Area of a Pie Chart Activity 3.08 Inserting a Text Box in a Chart
Objective 3 Update a Chart and Insert WordArt Activity 3.09 Updating a Chart Activity 3.10 Inserting WordArt in a Worksheet
Objective 4 Preparing a Chart Sheet for Printing Activity 3.11 Preparing and Printing a Chart Sheet
Project 3B: Line Chart
Objective 5 Design a Worksheet for What-If Analysis Activity 3.12 Using Parentheses in a Formula Activity 3.13 Calculating a Value After an Increase
Objective 6 Perform What-If Analysis Activity 3.14 Performing What-If Analysis Activity 3.15 Using Paste Special
Objective 7 Compare Data with a Line Chart Activity 3.16 Creating a Line Chart to Compare Data
What Our Readers Are Saying
Average customer rating based on 1 comment:
Other books you might like