Microsoft Excel 2013: Complete

Cover......Page 1
Title......Page 2
Statement......Page 3
Copyright......Page 4
Contents......Page 5
Preface......Page 11
About Our Covers......Page 14
Textbook Walk-Through......Page 15
Objectives......Page 19
Introduction to the Windows 8 Operating System......Page 20
Introduction to Microsoft Office 2013......Page 27
Running and Using an App......Page 28
Saving and Organizing Files......Page 41
Screen Resolution......Page 54
Additional Common Features of Office Apps......Page 58
Renaming, Moving, and Deleting Files......Page 68
Microsoft Office and Windows Help......Page 71
Chapter Summary......Page 76
Apply Your Knowledge......Page 78
Analyze, Correct, Improve......Page 79
In the Lab 2: Saving Files in Folders......Page 80
Consider This: Your Turn......Page 81
Learn Online......Page 82
Objectives......Page 83
Introduction to Office 365......Page 84
What Is Office 365?......Page 85
First Look at Office 365......Page 88
Synchronization......Page 90
Teams Using Office 365 in Business......Page 91
Consider This: Your Turn......Page 97
Objectives......Page 99
Project — Worksheet and a Chart......Page 100
Entering Text......Page 104
Entering Numbers......Page 110
Calculating a Sum......Page 112
Using the Fill Handle to Copy a Cell to Adjacent Cells......Page 113
Formatting the Worksheet......Page 120
Adding a Pie Chart to the Worksheet......Page 135
Changing the Sheet Tab Names......Page 139
Printing a Worksheet......Page 143
AutoCalculate......Page 146
Correcting Errors......Page 147
Chapter Summary......Page 152
Apply Your Knowledge......Page 153
Extend Your Knowledge......Page 155
Analyze, Correct, Improve......Page 156
In the Lab 1: Fourth Quarter Revenue Analysis Worksheet......Page 157
In the Lab 2: Sales Analysis Worksheet......Page 159
Consider This: Your Turn......Page 161
Learn Online......Page 162
Objectives......Page 163
Project — Worksheet with Formulas and Functions......Page 164
Entering the Titles and Numbers into the Worksheet......Page 168
Entering Formulas......Page 171
Option Buttons......Page 177
Using the AVERAGE, MAX, and MIN Functions......Page 179
Formatting the Worksheet......Page 187
Checking Spelling......Page 205
Printing the Worksheet......Page 208
Displaying and Printing the Formulas Version of the Worksheet......Page 213
Chapter Summary......Page 216
Apply Your Knowledge......Page 217
Extend Your Knowledge......Page 219
Analyze, Correct, Improve......Page 220
In the Lab 1: Loan Balance Worksheet......Page 221
In the Lab 2: Sales Summary Worksheet......Page 223
Consider This: Your Turn......Page 225
Learn Online......Page 226
Objectives......Page 227
Project — Financial Projection Worksheet with What-If Analysis and Chart......Page 228
Rotating Text and Using the Fill Handle to Create a Series......Page 233
Copying a Range of Cells to a Nonadjacent Destination Area......Page 239
Inserting and Deleting Cells in a Worksheet......Page 242
Absolute Versus Relative Addressing......Page 249
Making Decisions — The IF Function......Page 252
Adding and Formatting Sparkline Charts......Page 258
Formatting the Worksheet......Page 261
Adding a Clustered Column Chart to the Workbook......Page 268
Organizing the Workbook......Page 277
Changing the View of the Worksheet......Page 280
What-If Analysis......Page 285
Chapter Summary......Page 290
Apply Your Knowledge......Page 291
Extend Your Knowledge......Page 293
Analyze, Correct, Improve......Page 294
In the Lab 1: Eight-Year Financial Projection......Page 296
In the Lab 2: Updating a Weekly Payroll Worksheet......Page 300
Consider This: Your Turn......Page 302
Learn Online......Page 305
Objectives......Page 307
Project — Mortgage Payment Calculator with Data Table and Amortization Schedule......Page 308
Creating Cell Names......Page 314
Using a Data Table to Analyze Worksheet Data......Page 322
Creating an Amortization Schedule......Page 328
Printing Sections of the Worksheet......Page 345
Protecting and Hiding Worksheets and Workbooks......Page 350
Formula Checking......Page 356
Chapter Summary......Page 359
Apply Your Knowledge......Page 360
Extend Your Knowledge......Page 361
Analyze, Correct, Improve......Page 363
In the Lab 1: Analyzing Education Savings......Page 364
In the Lab 2: Consumer Debt Analysis and Interest Comparison Table......Page 366
In the Lab 3: Expand Your World: Cloud and Web Technologies......Page 368
Consider This: Your Turn......Page 369
Learn Online......Page 370
Objectives......Page 371
Project — Consolidated Expenses Worksheet......Page 372
Creating the Consolidated Worksheet......Page 376
Formatting the Consolidated Worksheet......Page 384
Working with Multiple Worksheets......Page 394
Adding a Header and Footer, Changing the Margins, and Printing the Workbook......Page 414
Consolidating Data by Linking Workbooks......Page 423
Chapter Summary......Page 430
Apply Your Knowledge......Page 432
Extend Your Knowledge......Page 433
Analyze, Correct, Improve......Page 434
In the Lab 1: Using a Master Sheet to Create a Multiple-Sheet Workbook......Page 435
In the Lab 2: Consolidating Data by Linking Workbooks......Page 437
Consider This: Your Turn......Page 439
Learn Online......Page 441
Objectives......Page 443
Project — Coastal Realty Agent Commission Table......Page 444
Creating a Table......Page 449
Adding Calculated Fields to the Table......Page 456
Using a Lookup Table......Page 458
Conditional Formatting......Page 461
Working with Tables in Excel......Page 463
Sorting a Table......Page 466
Querying a Table Using AutoFilter......Page 471
Using Criteria and Extract Ranges......Page 479
Using Database Functions......Page 483
Using the SUMIF, COUNTIF, MATCH, and INDEX Functions......Page 486
Summarizing Data......Page 489
Chapter Summary......Page 493
Apply Your Knowledge......Page 494
Extend Your Knowledge......Page 496
Analyze, Correct, Improve......Page 498
In the Lab 1: Using Structured References and a Lookup Table......Page 499
In the Lab 2: Querying a Table......Page 501
In the Lab 3: Expand Your World: Cloud and Web Technologies......Page 502
Consider This: Your Turn......Page 503
Learn Online......Page 505
Objectives......Page 507
Project — Clear Pools Sales Analysis......Page 508
Creating Templates......Page 512
Importing Data......Page 520
Using the Quick Analysis Tool......Page 536
Using the Find and Replace Commands......Page 539
Inserting a 3-D Cone Chart......Page 542
Working with SmartArt Graphics......Page 547
Using Screen Shots on a Worksheet......Page 557
Chapter Summary......Page 560
Apply Your Knowledge......Page 561
Extend Your Knowledge......Page 563
Analyze, Correct, Improve......Page 565
In the Lab 1: Creating a 3-D Cone Chart and WordArt Title......Page 566
In the Lab 2: Inserting a Balance Chart and Image on a Worksheet......Page 567
Consider This: Your Turn......Page 569
Learn Online......Page 570
Index......Page 571
Quick Reference Summary......Page 583
Important Notes for Windows 7 Users......Page 593