Title Details

Curt Simmons lives in Saint Jo, Texas, with his wife and two daughters. The author of more than 50 computing books on a wide range of topics, he primarily writes about Microsoft products. When he is not writing, Curt enjoys gardening and working on his 107-year-old home.

1 Getting In and Out.

Starting Excel.

The Excel environment.

Getting help.

Opening workbook files.

Using hyperlinks.

Saving workbook files.

Creating and using templates.

Closing workbook files.

Quitting Excel.

Just the facts.

2 All About Worksheets.

Worksheet basics.

Selecting worksheets.

Naming worksheets.

Color-coding workbook contents.

Rearranging worksheets.

Adding and deleting worksheets.

Moving around in a worksheet.

Multiple windows.

Zooming your view.

Just the facts.

II Crunching Numbers.

3 Entering and Editing Data.

Entering data directly.

Using data entry techniques.

Creating a dynamic list/table.

Validating data during entry.

Editing cell entries.

Finding and replacing data.

Moving and copying data.

Inserting, deleting, and rearranging.

Breaking a column into multiple columns.

Adding worksheet comments.

Checking your spelling.

Just the facts.

4 Working Data Magic with Calculations.

Simple calculations, quick answers.

About cell references.

Writing formulas.

Moving and copying formulas.

Linking worksheets and workbooks.

Using cell names.

Editing formulas.

Tracing a formula.

Locating worksheet errors.

Just the facts.

5 Excel Functions.

Using functions.

Common and useful functions.

Combining functions for more power.

Just the facts.

III Dressing Up Your Data.

6 Formatting Cells.

The Font and Alignment Ribbon groups.

Formatting the font.

Working with borders.

Adding colors.

Fitting the text in the cell.

Copying formatting with Format Painter.

Just the facts.

7 Formatting Numbers and Using Styles.

Applying number formats to cells.

Ribbon buttons for formats.

The Format Cells dialog box.

Formatting dates and times.

Formatting text entries.

Creating custom formats.

Applying conditional number formats.

Converting actual values to displayed values.

Hiding zeroes.

Using styles to streamline formatting.

Just the facts.

IV Organizing Data.

8 Organizing Data.

Sorting lists.

Filtering records.

Calculating filtered records.

The Query Wizard — A better filter.

Query a Web page.

Just the facts.

9 Finding and Comparing Answers.

Consolidating a table.

Subtotaling a table.

Scenarios.

Compare answers with data tables.

Goal seeking for simple answers.

Answering complex questions with Solver.

Just the facts.

10 Summarizing Data Dynamically with PivotTables.

Using PivotTables.

PivotTable terms.

Creating a PivotTable.

The PivotTable Tools tab.

Changing PivotTable arrangement.

Changing PivotTable calculations.

Showing underlying details.

Formatting numbers.

Just the facts.

11 Displaying PivotTables Graphically with PivotCharts.

PivotCharts versus normal charts.

Creating PivotCharts.

Rearranging PivotCharts.

Formatting PivotCharts.

Embedding a PivotChart on a worksheet.

Just the facts.

V Presenting Your Data.

12 Presenting Data Visually with Charts.

Creating a chart.

The Charts group.

Types of charts.

Changing chart data.

Quickly changing chart layout.

Moving and resizing an embedded chart.

Changing the chart location.

Just the facts.

13 Formatting Charts.

Chart formatting possibilities.

Formatting chart elements.

Changing axis scale.

Reordering the series.

Enlarging and exploding a pie chart.

Changing 3-D perspective.

Adding a trendline.

Adding a secondary axis.

Working with data labels.

Creating picture markers.

Saving and reusing your custom chart format.

Just the facts.

14 Adding Pictures and Graphic Objects.

Using the Shapes group.

Drawing basic shapes.

Formatting for all graphic objects.

Creating AutoShapes.

Drawing text boxes.

Creating WordArt.

Inserting pictures and clip art.

Creating SmartArt.

Pasting pictures of cells.

Just the facts.

VI Sharing Excel Data.

15 Printing Just What You Need.

Previewing printed pages.

Printing a quick copy of a worksheet.

Printing part of a worksheet.

Printing a chart.

Printing several worksheets.

Just the facts.

16 Formatting the Printed Page.

Setting page breaks.

Changing the page layout.

Printing a specific number of pages.

Printing row/column labels on every page.

Creating a header or footer.

Printing worksheet gridlines.

Printing in black and white.

Formatting printed charts.

Just the facts.

17 Sharing a Workbook with Other Users.

Sharing a workbook.

Reviewing changes in a shared workbook.

Sending and routing workbooks.

Protecting workbooks and worksheets.

Just the facts.

18 Sharing a Workbook Between Programs.

Shared-data terminology.

Sending data between Excel and Word.

Sending data between Excel and Access.

Pasting Excel data into PowerPoint.

Dragging a hyperlink into Excel.

Saving a worksheet as a Web page.

Just the facts.

VII Making Excel Your Own.

19 Customizing Your Workspace.

Changing your screen display.

Minimizing the Ribbon.

Customizing the Quick Access toolbar.

Personalizing features.

Proofing options.

Setting Advanced options.

Just the facts.

20 Adding Controls to a Worksheet.

What can worksheet controls do?

Forms Controls.

All worksheet controls.

List boxes and combo boxes.

Option buttons and group boxes.

Scroll bars and spinners.

Check boxes.

Button controls.

Labels.

Just the facts.

21 Using Macros to Automate Repetitive Work.

Introducing macros.

Recording a macro.

Running a macro.

Exploring the Visual Basic Editor.

Editing a macro.

Deleting a macro.

Setting macro virus protection.

Just the facts.

VIII Appendixes.

Appendix A: Build Creative Worksheets.

Appendix B: Recommended Resources.

Glossary.

Index.