New Perspectives on Microsoft Excel 2010, Brief: Brief

Cover Page......Page 1
Title Page......Page 3
Copyright Page......Page 5
Preface......Page 6
TABLE OF CONTENTS......Page 10
GETTING STARTED WITH MICROSOFT OFFICE 2010 Preparing a Meeting Agenda......Page 12
Exploring Microsoft Office 2010......Page 15
Starting Office Programs......Page 16
Switching Between Open Programs and Files......Page 18
Resizing the Program Window and Workspace......Page 19
Zooming and Scrolling......Page 20
Using the Ribbon......Page 22
Clicking Buttons......Page 23
Opening Dialog Boxes and Task Panes......Page 25
Accessing the Mini Toolbar......Page 27
Opening Shortcut Menus......Page 28
Working with Files......Page 29
Saving a File......Page 30
Opening a File......Page 33
Sharing Files Using Windows Live SkyDrive......Page 35
Viewing ScreenTips......Page 36
Using the Help Window......Page 37
Printing a File......Page 39
Exiting Programs......Page 41
SAM: Skills Assessment Manager......Page 42
ProSkills: Team Work......Page 43
Tutorial 1: Getting Started with Excel......Page 44
SESSION 1.1......Page 45
Exploring the Excel Window......Page 47
Navigating Between Worksheets......Page 48
Navigating Within a Worksheet......Page 49
Planning a Workbook......Page 51
Entering Text......Page 52
Entering Multiple Lines of Text Within a Cell......Page 54
Entering Dates......Page 55
Entering Numbers......Page 56
Setting Column Widths......Page 58
Setting Row Heights......Page 60
Inserting a Column or Row......Page 61
Deleting and Clearing a Row or Column......Page 63
Session 1.1 Quick Check......Page 64
SESSION 1.2......Page 65
Selecting a Range......Page 67
Moving and Copying a Range......Page 69
Inserting and Deleting a Range......Page 71
Entering a Formula......Page 73
Copying and Pasting Formulas......Page 76
Entering a Function......Page 77
Entering Functions with the AutoSum Feature......Page 78
Inserting or Deleting a Worksheet......Page 80
Editing Worksheet Content......Page 81
Using Find and Replace......Page 83
Using the Spelling Checker......Page 84
Changing Worksheet Views......Page 86
Working with Portrait and Landscape Orientation......Page 87
Printing the Workbook......Page 88
Viewing and Printing Worksheet Formulas......Page 89
Session 1.2 Quick Check......Page 91
Review Assignments......Page 92
Case Problem......Page 93
Tutorial 2: Formatting a Workbook......Page 100
SESSION 2.1......Page 101
Formatting Cell Text......Page 103
Applying Fonts and Font Styles......Page 104
Applying a Font Color......Page 105
Formatting Text Selections......Page 106
Changing a Fill Color......Page 107
Adding a Background Image......Page 108
Creating Formulas to Add, Subtract, and Divide Values......Page 109
Applying Number Formats......Page 111
Formatting Dates and Times......Page 114
Aligning Cell Content......Page 115
Indenting Cell Content......Page 116
Merging Cells......Page 117
Rotating Cell Contents......Page 118
Adding Cell Borders......Page 119
Exploring Options in the Format Cells Dialog Box......Page 120
Copying Formats with the Format Painter......Page 122
Copying Formats with the Paste Options Button......Page 123
Session 2.1 Quick Check......Page 124
SESSION 2.2......Page 125
Applying Cell Styles......Page 127
Working with Themes......Page 129
Creating Formulas to Calculate Totals......Page 131
Creating Formulas to Subtract Values......Page 132
Working with Table Styles......Page 134
Selecting Table Style Options......Page 136
Highlighting Cells with Conditional Formats......Page 138
Formatting the Worksheet for Printing......Page 144
Defining the Print Area......Page 145
Inserting Page Breaks......Page 146
Adding Print Titles......Page 147
Creating Page Headers and Footers......Page 148
Session 2.2 Quick Check......Page 150
Review Assignments......Page 151
Case Problem......Page 152
Tutorial 3: Working with Formulas and Functions......Page 158
SESSION 3.1......Page 159
Understanding Cell References......Page 161
Using Relative References......Page 163
Using Absolute References......Page 164
Using Mixed References......Page 168
Understanding Function Syntax......Page 170
Inserting a Function......Page 174
Typing a Function......Page 177
Session 3.1 Quick Check......Page 180
SESSION 3.2......Page 181
Entering Data and Formulas with AutoFill......Page 183
Using the Fill Handle......Page 184
Filling a Series......Page 186
Developing a Savings Plan......Page 190
Using the IF Function......Page 194
Working with Date Functions......Page 198
Working with Financial Functions......Page 199
Using the PMT Function......Page 201
Session 3.2 Quick Check......Page 205
Review Assignments......Page 206
Case Problem......Page 207
Tutorial 4: Enhancing a Workbook with Charts and Graphs......Page 212
SESSION 4.1......Page 213
Creating an Excel Chart......Page 215
Selecting a Chart Type......Page 216
Moving a Chart to a Different Worksheet......Page 218
Moving and Resizing Charts......Page 219
Choosing a Chart Style......Page 220
Choosing a Chart Layout......Page 221
Formatting the Chart Title......Page 222
Formatting the Chart Legend......Page 223
Formatting Data Labels......Page 225
Changing Pie Slice Colors......Page 226
Creating a Column Chart......Page 227
Inserting a Column Chart......Page 228
Formatting a Column Chart Title and Legend......Page 229
Editing the Axis Scale and Text......Page 230
Formatting the Chart Columns......Page 232
Session 4.1 Quick Check......Page 234
SESSION 4.2......Page 235
Creating a Line Chart......Page 237
Formatting Date Label......Page 238
Setting Label Units......Page 241
Overlaying a Chart Legend......Page 242
Adding an Axis Title......Page 244
Changing a Data Value......Page 245
Adding a Data Series to an Existing Chart......Page 246
Creating a Combination Chart......Page 248
Creating a 3-D Chart......Page 252
Creating Sparklines......Page 254
Adding and Formatting Sparkline Markers......Page 257
Creating Data Bars......Page 259
Modifying a Data Bar Rule......Page 260
Creating a Chart Sheet......Page 262
Session 4.2 Quick Check......Page 265
Practice: Review Assignments......Page 266
Case Problem......Page 267
ProSkills Exercise: Decision Making......Page 272
GLOSSARY/INDEX......Page 276
TASK REFERENCE......Page 281