Synopses & Reviews
The Advantage Series presents the Why, What and How of computer application skills to today's students. Each lab in this series is built upon an efficient learning model, which provides students and faculty with complete coverage and enhances critical thinking skills. This text contains Intro level content plus 5 to 6 chapters of advanced level content.
About the Author
Sarah Hutchinson has taught microcomputer applications through her company, Sarah Hutchinson & Associates. She has a BA from the University of California, Santa Barbara.
Table of Contents
Chapter 1: Creating A Worksheet1.1 Getting Started with Excel1.2 Getting Your First Worksheet1.3 Editing Your Work1.4 Managing Files1.5 Chapter Review1.6 Review Questions1.7 Hands-On Projects1.8 Case Problems: Rain Coast AirChapter 2: Modifying A Worksheet2.1 Entering and Reviewing Data 2.2 Copying and Moving Data2.3 Modifying Rows and Columns2.4 Chapter Review2.5 Review Questions2.6 Hands-On Projects2.7 Case Problems: Granby Insurance AgencyChapter 3: Formatting and Printing3.1 Enhancing a Worksheet's Appearance3.2 Applying and Removing Formatting3.3 Printing and Web Publishing3.4 Customizing Print Options3.5 Chapter Review3.6 Review Questions3.7 Hands-On Projects3.8 Case Problems: Marvin's MusicChapter 4: Analizing Your Data4.1 Working with Named Ranges4.2 Using Built-In Functions4.3 Creating an Embedded Chart4.4 Chapter Review4.5 Review Questions4.6 Hands-On Projects4.7 Case Problems: Interior Hockey AssociationChapter 5: Presenting Your Data5.1 Formatting Cells5.2 Using Number Formats and Styles5.3 Working with Draw Objects5.4 Working with Other Media5.5 Creating a Separate Chart Sheet5.6 Customizing Charts5.7 Chapter Review5.8 Review Questions5.9 Hands-On Projects5.10 Case Problems: Ponderosa CanyonChapter 6: Performing Calculations6.1 Working with Formulas and Functions6.2 Using Date and Time Functions6.3 Using Mathematical and Statistical Functions6.4 Using Text Manipulation Functions6.5 Using Financial and Logical Functions6.6 Chapter Review6.7 Review Questions6.8 Hands-On Projects6.9 Case Problems: Synergy Computer Supplies Ltd.Chapter 7: Managing Worksheets and Workbooks7.1 Using Large Worksheets7.2 Manipulating Data in Large Worksheets7.3 Working with Multiple-Sheet Workbooks7.4 Consolidating Your Data7.5 Chapter Review7.6 Review Questions7.7 Hands-On Projects7.8 Case Problems: Home Stretch HardwareChapter 8: Managing Lists8.1 Working with Lists8.2 Manipulating Lists8.3 Analyzing Lists8.4 Using Subtotals and Outlines8.5 Chapter Review8.6 Review Questions8.7 Hands-On Projects8.8 Case ProblemsChapter 9: Analyzing Alternatives9.1 Performing What-If Analysis9.2 Working with Data Tables9.3 Working with PivotTables & Pivot Charts9.4 Managing and Reporting Results9.5 Chapter Review9.6 Review Questions9.7 Hands-On Projects9.8 Case ProblemsChapter 10: Working Smarter10.1 Using Lookup Tables10.2 Documenting Your Work10.3 Protecting Your Work10.4 Working with Templates10.5 Importing and Exporting Data10.6 Chapter Review10.7 Review Questions10.8 Hands-On Projects10.9 Case ProblemsChapter 11: Developing Workbook Applications11.1 Planning a Workbook Application11.2 Validating Data11.3 Auditing a Worksheet11.4 Automating a Workbook11.5 Customizing Menus & Toolbars11.6 Chapter Review11.7 Review Questions11.8 Hands-On Projects11.9 Case ProblemsChapter 12: Working with Visual Basic for Applications12.1 Introducing the VBA Environment12.2 Understanding the VBA Language12.3 Controlling Your Procedures12.4 Interacting with the User12.5 Working with Controls12.6 Chapter Review12.7 Review Questions12.8 Hands-On Projects12.9 Case Problems