Exploring Microsoft Office Excel 2010 Comprehensive

For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.   The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series for Office 2010 also enables students to extend the learning beyond the classroom.   Students go to college now with a different set of skills than they did five years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know.  A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere. The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

Table of Contents:
GLOSSARY OFFICE FUNDAMENTALS AND FILE MANAGEMENT CHAPTER ONE ¿ Office Fundamentals and File Management CASE STUDY: RAILS AND TRAILS OBJECTIVES FILES AND FOLDERS Using Windows Explorer Working with Folders and Files Selecting, Copying, and Moving Multiple Files and Folders HANDS-ON EXERCISE 1: Files and Folders MICROSOFT OFFICE SOFTWARE Identifying Common Interface Components Getting Office Help HANDS-ON EXERCISE 2: Microsoft Office Software BACKSTAGE VIEW TASKS Opening a File Printing a File Closing a File and Application HANDS-ON EXERCISE 3: Backstage View Tasks HOME TAB TASKS Selecting and Editing Text Using the Clipboard Group Tasks Using the Editing Group Tasks HANDS-ON EXERCISE 4: Home Tab Tasks INSERT TAB TASKS Inserting Objects REVIEW TAB TASKS Reviewing a File PAGE LAYOUT TAB TASKS Changing Page Settings HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   MICROSOFT OFFICE EXCEL 2010 CHAPTER ONE ¿ Introduction to Excel CASE STUDY: OK OFFICE SYSTEMS OBJECTIVES INTRODUCTION TO SPREADSHEETS Planning for Effective Workbook and Worksheet Design Exploring the Excel Window Entering and Editing Cell Data HANDS-ON EXERCISE 1: Introduction to Spreadsheets MATHEMATICS AND FORMULAS Using Symbols and the Order of Precedence Using Auto Fill Displaying Cell Formulas HANDS-ON EXERCISE 2: Mathematics and Formulas WORKBOOK AND WORKSHEET MANAGEMENT Managing Worksheets Managing Columns and Rows Selecting, Moving, Copying, and Pasting HANDS-ON EXERCISE 3: Workbook and Worksheet Management FORMATTING Applying Alignment and Font Options Applying Number Formats HANDS-ON EXERCISE 4: Formatting PAGE SETUP AND PRINTING Selecting Page Setup Options Printing a Worksheet HANDS-ON EXERCISE 5: Page Setup and Printing CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER TWO ¿ Formulas and Functions CASE STUDY: DENVER MORTGAGE COMPANY OBJECTIVES FORMULA BASICS Using Semi-Selection to Create a Formula Using Relative, Absolute, and Mixed Cell References in Formulas Avoiding Circular References HANDS-ON EXERCISE 1: Formula Basics FUNCTION BASICS Inserting a Function Totaling Values with the SUM Function Inserting Basic Statistical Functions Using Date Functions HANDS-ON EXERCISE 2: Function Basics LOGICAL, LOOKUP, AND FINANCIAL FUNCTIONS Determining Results with the IF Function Using Lookup Functions Calculating Payments with the PMT Function HANDS-ON EXERCISE 3: Logical, Lookup, and Financial Functions RANGE NAMES Creating and Maintaining Range Names Using Range Names in Formulas HANDS-ON EXERCISE 4: Range Names CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER THREE ¿ Charts CASE STUDY: HORT UNIVERSITY MAJORS OBJECTIVES CHART BASICS Deciding Which Chart Type to Create Creating a Chart HANDS-ON EXERCISE 1: Chart Basics CHART DESIGN Changing the Chart Type Changing the Data Source and Structure Applying a Chart Layout and a Chart Style Moving a Chart Printing Charts Inserting and Customizing a Sparkline HANDS-ON EXERCISE 2: Chart Design CHART LAYOUT Selecting and Formatting Chart Elements Customizing Chart Labels Formatting the Axes and Gridlines Adding a Trendline HANDS-ON EXERCISE 3: Chart Layout CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER FOUR ¿ Datasets and Tables CASE STUDY: THE SPA EXPERTS OBJECTIVES LARGE DATASETS Freezing Rows and Columns Printing Large Datasets HANDS-ON EXERCISE 1: Large Datasets EXCEL TABLES Understanding Table Design Creating a Table Applying a Table Style HANDS-ON EXERCISE 2: Excel Tables TABLE MANIPULATION AND AGGREGATION Sorting Data Filtering Data Using Structured References and a Total Row HANDS-ON EXERCISE 3: Table Manipulation and Aggregation CONDITIONAL FORMATTING Applying Conditional Formatting Creating a New Rule Sorting and Filtering Using Conditional Formatting HANDS-ON EXERCISE 3: Conditional Formatting CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER FIVE ¿ Subtotals, PivotTables, and PivotCharts CASE STUDY: IVORY HALLS PUBLISHING COMPANY OBJECTIVES OUTLINES AND SUBTOTALS Grouping and Ungrouping Data Subtotaling Data HANDS-ON EXERCISE 1: Outlines and Subtotals PIVOTTABLE BASICS Creating a PivotTable Changing the Values Field Modifying a PivotTable HANDS-ON EXERCISE 2: PivotTable Basics PIVOTTABLE OPTIONS Sorting, Filtering, and Slicing a PivotTable Creating a Calculated Field HANDS-ON EXERCISE 3: PivotTable Options PIVOTTABLE DESIGN AND PIVOTCHARTS Formatting a PivotTable Creating a PivotChart HANDS-ON EXERCISE 4: PivotTable Design and PivotCharts CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER SIX ¿ What-If Analysis CASE STUDY: PERSONAL FINANCE: BUYING A CAR OBJECTIVES ONE- AND TWO-VARIABLE DATA TABLES Creating a One-Variable Data Table Creating a Two-Variable Data Table HANDS-ON EXERCISE 1: One- and Two-Variable Data Tables GOAL SEEK AND SCENARIO MANAGER Identifying an Input Value with Goal Seek Using Scenario Manager Generating Scenario Summary Reports HANDS-ON EXERCISE 2: Goal Seek and Scenario Manager SOLVER Loading the Solver Add-In Optimizing Results with Solver HANDS-ON EXERCISE 3: Solver CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER SEVEN ¿ Specialized Functions CASE STUDY: STANWORTH, INC. OBJECTIVES MATH AND STATISTICAL FUNCTIONS Using Conditional Math and Statistical Functions Calculating Relative Standing with Statistical Functions HANDS-ON EXERCISE 1: Math and Statistical Functions LOGICAL AND LOOKUP FUNCTIONS Creating a Nested Logical Function Using MATCH and INDEX Lookup Functions HANDS-ON EXERCISE 2: Logical and Lookup Functions DATABASE FILTERING AND FUNCTIONS Using Advanced Filtering Manipulating Data with Database Functions HANDS-ON EXERCISE 3: Database Filtering and Functions FINANCIAL FUNCTIONS Creating a Loan Amortization Table Performing Other Financial Calculations HANDS-ON EXERCISE 4: Financial Functions CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER EIGHT ¿ Multiple-Sheet Workbook Management CASE STUDY: HEARTLAND DEPARTMENT STORE OBJECTIVES MULTIPLE WORKSHEETS Working with Grouped Worksheets Managing Windows and Workspaces Inserting Hyperlinks HANDS-ON EXERCISE 1: Multiple Worksheets 3-D FORMULAS AND LINKED WORKBOOKS Inserting a 3-D Formula Linking Workbooks HANDS-ON EXERCISE 2: 3-D Formulas and Linked Workbooks FORMULA AUDITS AND DATA VALIDATION Auditing Formulas Setting Up a Watch Window Validating Data HANDS-ON EXERCISE 3: Formula Audits and Data Validation CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER NINE ¿ Imports, Web Queries, and XML CASE STUDY: STOCK ANALYSIS OBJECTIVES EXTERNAL DATA Importing Data from External Sources Creating a Web Query Managing Connections HANDS-ON EXERCISE 1: External Data TEXT MANIPULATION Converting Text to Columns Manipulating Text with Functions HANDS-ON EXERCISE 2: Text Manipulation XML Understanding XML Syntax Importing XML Data into Excel HANDS-ON EXERCISE 3: XML CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER TEN ¿ Collaboration and Workbook Distribution CASE STUDY: CULINARY ARTS SCHOLARSHIP DINNER OBJECTIVES CUSTOMIZATION AND PERSONALIZATION Customizing Excel Changing Properties HANDS-ON EXERCISE 1: Customization and Personalization COLLABORATION Sharing and Merging Workbooks Inserting Comments Tracking Changes HANDS-ON EXERCISE 2: Collaboration WORKBOOK INFORMATION Checking for Issues Protecting a Workbook HANDS-ON EXERCISE 3: Workbook Information WORKBOOK DISTRIBUTION Saving a Workbook in Different Formats Sending a Workbook to Others HANDS-ON EXERCISE 3: Workbook Distribution CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   CHAPTER ELEVEN ¿ Templates, Styles, and Macros CASE STUDY: PERSONAL FINANCIAL CONSULTANT OBJECTIVES TEMPLATES, THEMES, AND STYLES Selecting a Template Applying Themes and Backgrounds Applying Cell Styles HANDS-ON EXERCISE 1: Templates, Themes, and Styles CUSTOM TEMPLATES AND WORKBOOK PROTECTION Creating and Using a Template Protecting a Cell, a Worksheet, and a Workbook HANDS-ON EXERCISE 2: Custom Templates and Workbook Protection MACROS Creating a Macro Creating Macro Buttons Setting Macro Security HANDS-ON EXERCISE 3: Macros CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM   INDEX  

About the Author :
Dr. Robert T. Grauer, Creator of the Exploring Series Bob Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.     Dr. Keith Mulbery, Consulting Series Editor and Excel Author Dr. Keith Mulbery is the Department Chair and an Associate Professor in the Information Systems and Technology Department at Utah Valley University (UVU), where he teaches computer applications, C# programming, systems analysis and design, and MIS classes. Keith also served as Interim Associate Dean, School of Computing, in the College of Technology and Computing at UVU.   Keith received the Utah Valley State College Board of Trustees Award of Excellence in 2001, School of Technology and Computing Scholar Award in 2007, and School of Technology and Computing Teaching Award in 2008. He has authored more than 15 textbooks, served as Series Editor for the Exploring Office 2007 series, and served as developmental editor on two textbooks.   Keith received his B.S. and M.Ed. in Business Education from Southwestern Oklahoma State University and earned his Ph.D. in Education with an emphasis in Business Information Systems at Utah State University. His dissertation topic was computer-assisted instruction using Prentice Hall’s Train and Assess IT program to supplement traditional instruction in basic computer proficiency courses.     Mary Anne Poatsy, Series Editor Mary Anne is a senior faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. She holds a B.A. in psychology and education from Mount Holyoke College and an M.B.A. in finance from Northwestern University’s Kellogg Graduate School of Management.   Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks County Community College and Muhlenberg College, as well as conducted professional training. Before teaching, she was vice president at Shearson Lehman in the Municipal Bond Investment Banking Department.     Dr. Lynn Hogan, Office Fundamentals and File Management and Windows 7 Author Lynn Hogan has taught in the Computer Information Systems area at Calhoun Community College for 29 years. She is the author of Practical Computing and has contributed chapters for several computer applications textbooks. Primarily teaching in the areas of computer literacy and computer applications, she was named Calhoun’s outstanding instructor in 2006. She received an M.B.A. from the University of North Alabama and a Ph.D. from the University of Alabama. Lynn resides in Alabama with her husband and two daughters.