Synopses & Reviews
ALERT: Before you purchase, check with your instructor or review your course syllabus to ensure that you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, including customized versions for individual schools, and registrations are not transferable. In addition, you may need a CourseID, provided by your instructor, to register for and use Pearson's MyLab & Mastering products.
Packages
Access codes for Pearson's MyLab & Mastering products may not be included when purchasing or renting from companies other than Pearson; check with the seller before completing your purchase.
Used or rental books
If you rent or purchase a used book with an access code, the access code may have been redeemed previously and you may have to purchase a new access code.
Access codes
Access codes that are purchased from sellers other than Pearson carry a higher risk of being either the wrong ISBN or a previously redeemed code. Check with the seller prior to purchase.
--
Ideal for students and individuals seeking an introduction to Microsoft Excel 2013.
The Exploring series charts readers beyond the “point and click,” helping them understand WHY they use Microsoft Office skills along with HOW they perform them. The latest edition provides an easy-to-follow map through each chapter to help readers learn, study, and review efficiently and be successful in this class and beyond. The entire approach allows students to map their way quickly and easily through the book, focusing on the key objectives, and using their own efficient study habits as a model for success.
Teaching and Learning Experience
This program will provide a better teaching and learning experience–for you and your students. Here’s how:
- Personalize Learning: MyITLab delivers proven results in helping students succeed, provides engaging experiences that personalize learning, and comes from a trusted partner with educational expertise and a deep commitment to helping students and instructors achieve their goals.
- Move Beyond the Point and Click: Students can move beyond the basics of the software at a faster pace, without sacrificing coverage of fundamental skills.
- Extend Learning Beyond the Classroom: A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.
Synopsis
The book covers introductory Excel. Move students beyond the point-and-click.
The goal of the
Exploring series is to move students beyond the point and click, to understanding the
why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.
Students go to college now with a different set of skills than they did 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 everyone needs to know.
NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.
Used books, rentals, and purchases made outside of Pearson
If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.
"
Synopsis
The book covers introductory Excel.
Move students beyond the point-and-click.
The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.
Students go to college now with a different set of skills than they did 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 everyone needs to know.
NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.
Used books, rentals, and purchases made outside of Pearson
If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.
Table of Contents
Microsoft Office 2013
Chapter One Office Fundamentals and File Management: Taking the First Step 1
Objectives 1
Case Study: Spotted Begonia Art Gallery 1
Windows 8 Startup 2
Logging In with Your Microsoft Account 2
Identifying the Start Screen Components 3
Interacting with the Start Screen 4
Accessing the Desktop 4
Hands-On Exercise 1:
Windows 8 Startup 6
Files and Folders 10
Using File Explorer 10
Working with Folders and Files 13
Selecting, Copying, and Moving Multiple Files and Folders 15
Hands-On Exercise 2:
Files and Folders 17
Microsoft Office Software 22
Identifying Common Interface Components 22
Getting Office Help 28
Hands-On Exercise 3:
Microsoft Office Software 31
The Backstage View Tasks 36
Opening a File 36
Printing a File 38
Closing a File and Application 39
Hands-On Exercise 4:
The Backstage View Tasks 41
Home Tab Tasks 45
Selecting and Editing Text 45
Using the Clipboard Group Commands 49
Using the Editing Group Commands 52
Hands-On Exercise 5:
Home Tab Tasks 55
Insert Tab Tasks 60
Inserting Objects 60
Review Tab Tasks 62
Reviewing a File 62
Page Layout Tab Tasks 65
Using the Page Setup Dialog Box 66
Hands-On Exercise 6:
Insert Tab Tasks, Page Layout Tab Tasks, and
Review Tab Tasks 68
Chapter Objectives Review 72
Key Terms Matching 73
Multiple Choice 74
Practice Exercises 75
Mid-Level Exercises 79
Beyond the Classroom 81
Capstone Exercise 82
Microsoft Office Excel 2013
Chapter One Introduction to Excel: What Is a Spreadsheet? 83
Objectives 83
Case Study: ok Office Systems 83
Introduction to Spreadsheets 84
Exploring the Excel Window 84
Entering and Editing Cell Data 87
Hands-On Exercise 1:
Introduction to Spreadsheets 91
Mathematics and Formulas 94
Creating Formulas 94
Using Auto Fill 96
Displaying Cell Formulas 97
Hands-On Exercise 2:
Mathematics and Formulas 99
Workbook and Worksheet Management 104
Managing Worksheets 104
Managing Columns and Rows 107
Hands-On Exercise 3:
Workbook and Worksheet Management 111
Clipboard Tasks 116
Selecting, Moving, Copying, and Pasting Data 116
Hands-On Exercise 4:
Clipboard Tasks 121
Formatting 124
Applying Alignment and Font Options 124
Applying Number Formats 126
Hands-On Exercise 5:
Formatting 129
Page Setup and Printing 133
Selecting Page Setup Options 133
Previewing and Printing a Worksheet 137
Hands-On Exercise 6:
Page Setup and Printing 138
Chapter Objectives Review 142
Key Terms Matching 144
Multiple Choice 145
Practice Exercises 146
Mid-Level Exercises 151
Beyond the Classroom 154
Capstone Exercise 155
Chapter Two Formulas and Functions: Performing Quantitative Analysis 157
Objectives 157
Case Study: Townsend Mortgage Company 157
Formula Basics 158
Using Relative, Absolute, and Mixed Cell
References in Formulas 158
Correcting Circular References 160
Hands-On Exercise 1:
Formula Basics 162
Function Basics 166
Inserting a Function 166
Inserting Basic Math and Statistics Functions 168
Using Date Functions 173
Hands-On Exercise 2:
Function Basics 176
Logical, Lookup, and Financial Functions 181
Determining Results with the IF Function 181
Using Lookup Functions 184
Calculating Payments with the PMT Function 187
Hands-On Exercise 3:
Logical, Lookup, and Financial Functions 188
Range Names 192
Creating and Maintaining Range Names 192
Using Range Names in Formulas 194
Hands-On Exercise 4:
Range Names 195
Chapter Objectives Review 198
Key Terms Matching 199
Multiple Choice 200
Practice Exercises 201
Mid-Level Exercises 206
Beyond the Classroom 211
Capstone Exercise 213
Chapter Three Charts: Depicting Data Visually 215
Objectives 215
Case Study: Computer Job Outlook 215
Chart Creation Basics 216
Selecting the Data Source 216
Choosing a Chart Type 217
Moving, Sizing, and Printing a Chart 227
Hands-On Exercise 1:
Chart Creation Basics 230
Chart Elements 235
Adding Chart Elements 235
Formatting Chart Elements 238
Hands-On Exercise 2:
Chart Elements 243
Chart Design and Sparklines 247
Applying a Chart Style and Colors 247
Modifying the Data Source 248
Creating and Customizing Sparklines 249
Hands-On Exercise 3:
Chart Design and Sparklines 251
Chapter Objectives Review 254
Key Terms Matching 255
Multiple Choice 256
Practice Exercises 257
Mid-Level Exercises 260
Beyond the Classroom 263
Capstone Exercise 264
Chapter Four Datasets and Tables: Managing Large Volumes of Data 265
Objectives 265
Case Study: Reid Furniture Store 265
Large Datasets 266
Freezing Rows and Columns 267
Printing Large Datasets 267
Hands-On Exercise 1:
Large Datasets 271
Excel Tables 275
Designing and Creating Tables 275
Applying a Table Style 279
Hands-On Exercise 2:
Excel Tables 281
Table Manipulation 286
Sorting Data 286
Filtering Data 288
Hands-On Exercise 3:
Table Manipulation 292
Table Aggregation 297
Using Structured References and a Total Row 297
Hands-On Exercise 4:
Table Aggregation 300
Conditional Formatting 304
Applying Conditional Formatting 304
Creating a New Rule 308
Hands-On Exercise 5:
Conditional Formatting 311
Chapter Objectives Review 315
Key Terms Matching 316
Multiple Choice 317
Practice Exercises 318
Mid-Level Exercises 322
Beyond the Classroom 324
Capstone Exercise 326
Summarizing and Analyzing Data 327
Application Capstone Exercise
Excel 327
Glossary 329
Index 334