CART

(0) items

Exploring Microsoft Excel 2013, Introductory,9780133412178
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Exploring Microsoft Excel 2013, Introductory

by ; ;
Edition:
1st
ISBN13:

9780133412178

ISBN10:
0133412172
Format:
Package
Pub. Date:
7/2/2013
Publisher(s):
Prentice Hall
List Price: $92.80

Rent Textbook

(Recommended)
 
Term
Due
Price
$74.24

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours
N9780133412178
$90.48

eTextbook

Downloadable Offline Access
  • Apple Devices
  • Android Devices
  • Kindle Fire
  • Windows Devices
  • Mac Devices

 
Duration
Price
$41.38

Used Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $61.35
See Prices

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 1st edition with a publication date of 7/2/2013.
What is included with this book?
  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Summary

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.

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

 



Please wait while the item is added to your cart...