Microsoft Excel 2010 for medical professionals

267 Pages·2012·18.517 MB·English

by  Reding Elizabeth, Wermers Lynn

This is an electronic version of the print textbook. Due to electronic rights
restrictions, some third party content may be suppressed. Editorial
review has deemed that any suppressed content does not materially
a ffect the overall learning experience. The publisher reserves the
right to remove content from this title at any time if subsequent
rights restrictions require it. For valuable information on pricing, previous
editions, changes to current editions, and alternate formats, please visit
w ww.cengage.com/highered to search by ISBN#, author, title, or keyword
for materials in your areas of interest.
Microsoft®
®
Excel 2010
for Medical Professionals
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd ii 1122//77//1100 1100::2299 AAMM
Microsoft® Excel® 2010 for Medical Professionals © 2012 Course Technology, Cengage Learning
Elizabeth Eisner Reding, Lynn Wermers ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be
reproduced, transmitted, stored or used in any form or by any means graphic, electronic,
Vice President, Publisher: Nicole Jones Pinard or mechanical, including but not limited to photocopying, recording, scanning, digitiz-
Executive Editor: Marjorie Hunt ing, taping, Web distribution, information networks, or information storage and retrieval
Associate Acquisitions Editor: Amanda Lyons systems, except as permitted under Section 107 or 108 of the 1976 United States
Copyright Act, without the prior written permission of the publisher.
Senior Product Manager: Christina Kling Garrett
Associate Product Manager: Kim Klasner
For product information and technology assistance, contact us at
Director of Marketing: Cheryl Costantini
Cengage Learning Customer & Sales Support, 1-800-354-9706
Senior Marketing Manager: Ryan DeGrote For permission to use material from this text or product, submit all
Marketing Coordinator: Kristen Panciocco requests online at www.cengage.com/permissions
Further permissions questions can be emailed to
Contributing Author: Carol Cram
[email protected]
Developmental Editor: Karen Stevens
Content Project Manager: Heather Hopkins
Trademarks:
Copy Editor: Mark Goodin
Some of the product names and company names used in this book have been used for
Proofreader: Vicki Zimmer identification purposes only and may be trademarks or registered trademarks of their
Indexer: BIM Indexing and Proofreading Services respective manufacturers and sellers.
QA Manuscript Reviewers: Marianne Snow Microsoft and the Office logo are either registered trademarks or trademarks of
Microsoft Corporation in the United States and/or other countries. Course Technology,
Print Buyer: Fola Orekoya
Cengage Learning is an independent entity from Microsoft Corporation, and not
Cover Designer: GEX Publishing Services affiliated with Microsoft in any manner.
Composition: GEX Publishing Services
ISBN-13: 978-0-538-74845-2
ISBN-10: 0-538-74845-1
Course Technology
20 Channel Center Street
Boston, MA 02210
USA
Cengage Learning is a leading provider of customized learning solutions with office
locations around the globe, including Singapore, the United Kingdom, Australia,
Mexico, Brazil, and Japan. Locate your local office at:
international.cengage.com/region
Cengage Learning products are represented in Canada by Nelson Education, Ltd.
To learn more about Course Technology, visit www.cengage.com/coursetechnology
To learn more about Cengage Learning, visit www.cengage.com
Purchase any of our products at your local college store or at our preferred online store
www.cengagebrain.com

Printed in the United States of America
1 2 3 4 5 6 7 8 9 19 18 17 16 15 14 13 12 11
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd iivv 1122//77//1100 1100::2299 AAMM
Microsoft®
®
Excel 2010
for Medical Professionals
ELIZABETH EISNER REDING
LYNN WERMERS
Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States
Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd iiiiii 1122//77//1100 1100::2299 AAMM
This page intentionally left blank
Brief Contents
Preface ..................................................................................................................................... x
Office 2010
Unit A: Getting Started with Microsoft Office 2010 .......................................................................Office 1
Excel 2010
Unit A: Getting Started with Excel 2010 .........................................................................................Excel 1
Unit B: Working with Formulas and Functions ...............................................................................Excel 25
Unit C: Formatting a Worksheet ...................................................................................................Excel 51
Unit D: Working with Charts ........................................................................................................Excel 79
Unit E: Analyzing Data Using Formulas .......................................................................................Excel 105
Unit F: Managing Workbook Data ..............................................................................................Excel 129
Unit G: Managing Data Using Tables ..........................................................................................Excel 153
Unit H: Analy zing Table Data ......................................................................................................Excel 177
Web Apps
Appendix Web Apps: Working with Windows Live and Of fice Web Apps ..........................Web Apps 1
Glossary ........................................................................................................................Glossary 1
Index .................................................................................................................................Index 6
BRIEF CONTENTS v
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd vv 1122//77//1100 1100::2299 AAMM
Contents
Preface ..................................................................................................................................................................................x
Office 2010
Unit A: Getting Started with Microsoft Office 2010 ...................................................................................................Office 1
Understanding the Office 2010 Suite .......................................................................................................................Office 2
Deciding which program to use
Starting and Exiting an Office Program ...................................................................................................................Office 4
Using shortcut keys to move between Office programs
Windows Live and Microsoft Office Web Apps
Viewing the Office 2010 User Interface ...................................................................................................................Office 6
Using Backstage view
Creating and Saving a File ........................................................................................................................................Office 8
Using the Office Clipboard
Opening a File and Saving it with a New Name ....................................................................................................Office 10
Working in Compatibility Mode
Exploring File Open options
Viewing and Printing your Work ...........................................................................................................................Office 12
Customizing the Quick Access toolbar
Creating a screen capture
Getting Help and Closing a File .............................................................................................................................Office 14
Recovering a document
Practice ....................................................................................................................................................................Office 16
Excel 2010
Unit A: Getting Started with Excel 2010 .......................................................................................................................Excel 1
Understanding Spreadsheet Sof tware .........................................................................................................................Excel 2
Touring the Excel 2010 Window ...............................................................................................................................Excel 4
Windows Live and Microsoft Office Web Apps
Unders t anding Formulas ............................................................................................................................................Excel 6
Entering Labels and Values and Using the Sum But ton ............................................................................................Excel 8
Navigating a worksheet
Editing Cell Entries ...................................................................................................................................................Excel 10
Recovering unsaved changes to a workbook file
Entering and Editing a Simple Formula ..................................................................................................................Excel 12
Understanding named ranges
Switching Wor ksheet Views ....................................................................................................................................Excel 14
Choosing Pr int Op t ions ..........................................................................................................................................Excel 16
Printing worksheet formulas
Scaling to fit
Practice ......................................................................................................................................................................Excel 18
Unit B: Working with Formulas and Functions............................................................................................................Excel 25
Creating a Complex Formula ..................................................................................................................................Excel 26
Reviewing the order of precedence
Inserting a Function ................................................................................................................................................Excel 28
vi CONTENTS
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd vvii 1122//77//1100 1100::2299 AAMM
Typing a Function ....................................................................................................................................................Excel 30
Using the COUNT and COUNTA functions
Copying and Moving Cell Entries ............................................................................................................................Excel 32
Inserting and deleting selected cells
Understanding Relative and Absolute Cell References ............................................................................................Excel 34
Using a mixed reference
Copying Formulas with Relative Cell References .....................................................................................................Excel 36
Using Paste Preview
Using Auto Fill options
Copying Formulas with Absolute Cell References ...................................................................................................Excel 38
Using the fill handle for sequential text or values
Rounding a Value with a Function ..........................................................................................................................Excel 40
Creating a new workbook using a template
Practice ......................................................................................................................................................................Excel 42
Unit C: Formatting a Worksheet ..................................................................................................................................Excel 51
Formatting Values .....................................................................................................................................................Excel 52
Formatting as a table
Changing Font and Font Size ...................................................................................................................................Excel 54
Inserting and adjusting clip art and other images
Changing Fon t St yles and Alignment ......................................................................................................................Excel 56
Rotating and indenting cell entries
Adjusting Column Width .........................................................................................................................................Excel 58
Changing row height
Inserting and Deleting Rows and Columns ............................................................................................................Excel 60
Hiding and unhiding columns and rows
Adding and editing comments
Applying Colors, Patterns, and Borders ..................................................................................................................Excel 62
Working with themes and cell styles
Applying Conditional Formatting ...........................................................................................................................Excel 64
Managing conditional formatting rules
Renaming and Moving a Worksheet ........................................................................................................................Excel 66
Copying worksheets
Checking Spelling .....................................................................................................................................................Excel 68
E-mailing a workbook
Practice ......................................................................................................................................................................Excel 70
Unit D: Working with Charts .......................................................................................................................................Excel 79
Planning a Chart.......................................................................................................................................................Excel 80
Creating a Chart .......................................................................................................................................................Excel 82
Creating sparklines
Moving and Resizing a Chart ..................................................................................................................................Excel 84
Moving an embedded chart to a sheet
Changing the Chart Design .....................................................................................................................................Excel 86
Creating a Combination Chart
Working with a 3-D chart
Changing the Chart Layout ....................................................................................................................................Excel 88
Adding data labels to a chart
Formatting a Chart ..................................................................................................................................................Excel 90
Changing alignment and angle in axis labels and titles
Annotating and Drawing on a Chart ......................................................................................................................Excel 92
Adding SmartArt graphics
CONTENTS vii
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd vviiii 1122//77//1100 1100::2299 AAMM
Creating a Pie Chart .................................................................................................................................................Excel 94
Previewing a chart
Practice ......................................................................................................................................................................Excel 96
Unit E: Analyzing Data Using Formulas ....................................................................................................................Excel 105
Formatting Data Using Text Functions .................................................................................................................Excel 106
Using text functions
Summing a Data Range Based on Conditions ........................................................................................................Excel 108
Consolidating Data Using a Formula .....................................................................................................................Excel 110
Linking data between workbooks
Checking Formulas for Errors ................................................................................................................................Excel 112
Correcting circular references
Constructing Formulas Using Named Ranges ........................................................................................................Excel 114
Consolidating data using named ranges
Managing workbook names
Building a Logical Formula with the IF Function ..................................................................................................Excel 116
Building a Logical Formula with the AND Function .............................................................................................Excel 118
Using the OR and NOT logical functions
Inserting an equation into a worksheet
Calculating Payments with the PMT Function ......................................................................................................Excel 120
Calculating future value with the FV function
Practice ....................................................................................................................................................................Excel 122
Unit F: Managing Workbook Data .............................................................................................................................Excel 129
Viewing and Arranging Worksheets .......................................................................................................................Excel 130
Splitting the worksheet into multiple panes
Protecting Worksheets and Workbooks ..................................................................................................................Excel 132
Freezing rows and columns
Saving Custom Views of a Worksheet ....................................................................................................................Excel 134
Using Page Break Preview
Adding a Worksheet Background ...........................................................................................................................Excel 136
Clipping Screens in Excel
Preparing a Workbook for Distribution ..................................................................................................................Excel 138
Sharing a workbook
Inser ting Hyperlinks ..............................................................................................................................................Excel 140
Returning to your document
Using research tools
Saving a Workbook for Distribution.......................................................................................................................Excel 142
Understanding Excel file formats
Grouping Worksheets .............................................................................................................................................Excel 144
Adding a digital signature to a workbook
Creating a workspace
Practice ....................................................................................................................................................................Excel 146
Unit G: Managing Data Using Tables ........................................................................................................................Excel 153
Planning a Table .....................................................................................................................................................Excel 154
Creating and Formatting a Table.... ........................................................................................................................Excel 156
Changing table style options
Adding Table Data ..................................................................................................................................................Excel 158
Selecting table elements
Finding and Replacing Table Data ..........................................................................................................................Excel 160
Using Find and Select features
viii CONTENTS
AA__4488445511__ffmm__ppttgg0011__hhiirreess..44cc..iinndddd vviiiiii 1122//77//1100 1100::2299 AAMM