Top
Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Looking to rent a book? Rent Mastering Excel 2010 A Problem-Solving Approach [ISBN: 9781256356769] for the semester, quarter, and short term or search our site for other textbooks by Gips, James. Renting a textbook can save you up to 90% from the cost of buying.
Chapter 1 Introduction 1
What is Excel? • A little history • What is Microsoft Office? • Why learn to use Excel?
Chapter 2 Creating simple worksheets 7
The basic idea • So what? • Getting started with Excel • Changing which cell is active •
The size of the worksheet • Entering information into cells • Correcting typing errors •
Undo and Redo • Simple formulas • Evaluating formulas • You try evaluating a formula •
Using cell addresses in formulas • Saving the workbook • The name of the workbook •
Printing the worksheet • Closing the workbook and starting a new one
Chapter 3 Changing the appearance of cells 31
Column width • Selecting cells • Formatting cells • Alignment • Help! • Formatting
numbers • Borders • Colors • Example • 3-D shading • The Format Painter button •
Displaying the formulas • Finding a look for your worksheets • Minimizing the Ribbon
Chapter 4 Simple functions and the Fill operation 53
Built-in functions save you typing • The variety of functions • Arguments and ranges •
Pointing • A common error: circular reference • Overuse of the SUM function • The
AutoSum button • The Insert Function tool • Nested functions • The Fill operation •
Using the Fill Handle • Filling by double-clicking • Goal Seek • Auto Fill • Using Auto
Fill to fit a straight line • Summary
Chapter 5 Operations on cells
Moving cells • Erasing a range of cells • Deleting rows and columns • Inserting rows and
columns • Sorting • Attaching a comment to a cell • Copy and Paste • Paste Options •
Using the keyboard instead of the mouse • Copying and Pasting from the web • Getting
updated external data from the web • Linking to files and web pages
Chapter 6 Relative vs. absolute addressing 99
An example where the Fill operation seems to fail • Absolute addressing • Peter Minuit •
Splitting the window • Naming cells • Mixed addressing • Panes
Chapter 7 Common operations 123
Validating inputs • Cell protection • Conditional Formatting • Text boxes • Adding
shapes, clip art, pictures, WordArt, and SmartArt
Chapter 8 Workbooks with multiple worksheets 137
Moving between worksheets • Using multiple worksheets • Working with multiple sheets
at the same time • Calculations across worksheets • Viewing multiple sheets and
workbooks • Linking workbooks
Chapter 9 The problem-solving process 149
1. Problem definition • 2. Design • 3. Implementation • 4. Testing • 5. Documentation
Chapter 10 Charts and trendlines 155
Fundamentals of charting • When to use different types of charts • Creating charts •Charting noncontiguous ranges • Multiple sets of data in the same chart • Scatter charts •
Using and printing charts • Trendlines • 3-D charts
Chapter 11 Logical functions 179
The IF function • Another example • Nested IF functions • You try • Logical functions
AND, OR, NOT • Another example • Testing IF functions
Chapter 12 Functions related to IF
The COUNTIF function • The SUMIF function • Using IF functions in extra columns •
The VLOOKUP function • Using VLOOKUP for exact matches • The IFERROR function
• Combining VLOOKUP and Data Validation • Looking up text • Two-dimensional
lookups with INDEX and MATCH • Catching and preventing errors in INDEX and
MATCH • Form Controls
Chapter 13 Dates and times 239
Serial numbers • An error in Excel • A second date system • Entering dates into the
worksheet • Using dates directly in formulas • The TODAY function • The DATE
function • Date formats • Date functions for converting from serial numbers • Example:
How many days until July 1? • Hours, minutes, and seconds • The NOW function • Time
formats • Entering a time into a cell or formula • Example: Testing the engines • Time
functions for converting from serial numbers
Chapter 14 Financial functions 255
Calculating loan payments with the PMT function • Using the Insert Function tool •
Calculating future values using the FV function • The basic idea of these financial functions
• The NPER function • The RATE function • The PV function • Making investment
decisions using IRR • Net present value • Investments with arbitrary dates for cash flows •
Winning the lottery • Other financial functions
Chapter 15 Random numbers and simulation 283
The RAND function • Flipping coins • Queuing problems • Santa Claus’s afternoon •
Generating random integers using RANDBETWEEN • Rolling a pair of dice 100,000 times
Chapter 16 Data management with tables 311
What is a table? • Sorting tables • Finding records with Filters • Adding the Total Row to a table • Pivot tables
Chapter 17 Analyzing data using the Analysis ToolPak 329
Getting access to the Analysis ToolPak • What is in the Analysis ToolPak? • The
Descriptive Statistics tool • Using the Histogram tool • Using the Correlation tool • Using
a t-Test tool • Using the Regression tool
Chapter 18 Solver 347
Solver • Using Solver to maximize profits • Using Solver for a linear programming
problem • Using Solver on a transportation problem
Chapter 19 Macros 365
What are macros? • Enabling macros • Creating and running macros • Absolute Reference
and Relative Reference • Macros for ranges of cells • Using buttons to call macros •
Creating macros by typing • Having a macro run automatically • Using the Shell function
to run programs • Custom functions
Index 381
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 access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
Need Help? Copyright © 1999-2026
