What is Excel? • A little history • What is Microsoft Office? • Why learn to use Excel?

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

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

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 

Solver • Using Solver to maximize profits • Using Solver for a linear programming

problem • Using Solver on a transportation problem

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

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.