|
| |
Ever since I began training corporate users back in 1984, spreadsheet
software was (and still remains) my favorite type of application. After many
years of corporate training and college teaching in all kinds of spreadsheet
software including SuperCalc, Multiplan, Lotus 1-2-3, and Microsoft Excel, I had
the fantastic opportunity to write Excel For Dummies for IDG Books in
1994, the latest edition of which is Excel
2003 For Dummies.
This was followed by the Excel 2002 All-In-One Desk Reference For Dummies
for Wiley Publishing in 2003, the latest edition of which is the
Excel 2003 All-In-One Desk Reference For
Dummies.
My newest Excel work is the
Excel Workbook For Dummies for Wiley Publishing in 2006.
For a glossary of commonly used spreadsheet terms, click the Excel Glossary
link in the pane on the left.
Title: Excel Workbook For Dummies
Pub Date: April, 2006
Publisher: Wiley Publishing, Inc. ISBN:
0-4707-9845-2
Errata: Corrections for Exercise 1-9
and 1-11 on pages 17-18 and 19 in Chapter 1.
Table of Contents at a Glance (click on any bullet to expand or
condense its Part):
 | Introduction |
| Part I: Creating Spreadsheets
|
| Part II: Using Formulas and Functions
|
| Part III: Working with Graphics
|
| Part IV: Managing and Securing Data
|
| Part V: Doing Data Analysis
|
| Part VI: Excel and the Web
|
| Part VII: Macros and Visual Basic for Applications
|
| Part VIII: The Part of Tens
 | Chapter 24: Top Ten Tips for Using Excel like a Pro |
| Chapter 25: Ten (More or Less) Shortcut Keys for Entering Data |
| Chapter 26: Ten (More or Less) Shortcut Keys for Formatting the
Worksheet |
| Chapter 27: Ten (More or Less) Shortcut Keys for Editing Data |
| Chapter 28: Ten (More or Less) Miscellaneous Shortcut Keys |
|
| Appendix: Using the Workbook CD-ROM |
| Index |
The Excel Workbook For Dummies is my latest work on Excel. This book
is designed for those of you who learn better by doing and want an opportunity
to get your hands dirty with the various and sundry features that I discuss in
my other reference-based books on Excel. The core of the workbook consists of
its exercises that run the gamut from learning how to create a new spreadsheet
and chart all the way to converting your spreadsheets to interactive Web pages
that you can share with co-workers and clients on the Internet. Here's a complete list of
all 131 exercises included in the
Excel Workbook For Dummies:
|
Chapter 1: Entering the Spreadsheet Data
|
Exercise 1-1: Launching Excel |
|
Exercise 1-2: Opening a New Workbook |
|
Exercise 1-3: Opening a New Workbook from a Template |
|
Exercise 1-4: Moving the Cell Cursor within the
Displayed Area |
|
Exercise 1-5: Moving the Cell Cursor to Distant Parts
of the Worksheet |
|
Exercise 1-6: Moving the Cell Cursor from Entry to
Entry |
|
Exercise 1-7: Moving to Different Worksheets |
|
Exercise 1-8: Selecting Various Cell Ranges |
|
Exercise 1-9: Making Simple Data Entries |
|
Exercise 1-10: Entering the Same Entry and Using
AutoFill |
|
Exercise 1-11: Copying a Formula with AutoFill |
|
Exercise 1-12: Saving a Spreadsheet |
|
|
Chapter 2: Formatting the Spreadsheet
|
Exercise 2-1: Modifying Column Widths in a Spreadsheet |
|
Exercise 2-2: Modifying Row Heights in a Spreadsheet |
|
Exercise 2-3: Formatting Cells from the Format Toolbar |
|
Exercise 2-4: Formatting Cells with Number Tab on the
Format Cells Dialog Box |
|
Exercise 2-5: Formatting Cells with the Alignment Tab
on the Format Cells Dialog Box |
|
Exercise 2-6: Formatting Cells with the Format Painter |
|
Exercise 2-7: Formatting a Table with AutoFormat |
|
Exercise 2-8: Formatting Cells with Conditional
Formatting |
|
Exercise 2-9: Hiding Columns and Rows in a Worksheet |
|
|
Chapter 3: Printing Spreadsheet Reports
|
Exercise 3-1: Previewing a Printed Report |
|
Exercise 3-2: Paging a Report with Page Break Preview |
|
Exercise 3-3: Creating a Custom Header and Footer for a
Report |
|
Exercise 3-4: Adding Print Titles to a Report |
|
Exercise 3-5: Changing the Print Settings for a Report |
|
Exercise 3-6: Printing a Particular Range of Worksheet
Data |
|
Exercise 3-7: Printing the Entire Workbook |
|
Exercise 3-8: Printing a Chart in a Report |
|
Exercise 3-9: Printing the Formulas in a Spreadsheet |
|
|
Chapter
4: Modifying the Spreadsheet
|
Exercise 4-1: Adding Summary Information to a Workbook |
|
Exercise 4-2: Searching for the Workbook to Edit |
|
Exercise 4-3: Using the Various Options for Opening a
Workbook |
|
Exercise 4-4: Using Zoom, Freeze Panes, and Custom
Views |
|
Exercise 4-5: Selecting the Range of Cells for Editing |
|
Exercise 4-6: Editing Cell Entries |
|
Exercise 4-7: Verifying Data Entries with Text to
Speech |
|
Exercise 4-8: Deleting and Inserting Cells in the
Spreadsheet |
|
Exercise 4-9: Moving and Copying Cells in the
Spreadsheet |
|
Exercise 4-10: Adding Comments to the Spreadsheet |
|
Exercise 4-11: Editing with Find and Replace and Spell
Checking |
|
Exercise 4-12: Editing Different Worksheets as a Group |
|
|
Chapter 5:
Building Formulas
|
Exercise 5-1: Building Arithmetic Formulas |
|
Exercise 5-2: Building Comparative Formulas |
|
Exercise 5-3: Working with Error Values in Formulas |
|
Exercise 5-4: Building Formulas with AutoSum |
|
Exercise 5-5: Editing Formulas in the Spreadsheet |
|
Exercise 5-6: Changing the Order in Which Formulas Are
Calculated |
|
Exercise 5-7: Building Formulas with External Links |
|
Exercise 5-8: Controlling When Formulas Are
Recalculated |
|
|
Chapter 6: Copying and Correcting Formulas
|
Exercise 6-1: Copying Formulas in the R1C1 Reference
Style |
|
Exercise 6-2: Copying a Formula with Absolute Cell
References |
|
Exercise 6-3: Creating a Loan Table with Mixed Cell
References |
|
Exercise 6-4: Creating Range Names for Formulas |
|
Exercise 6-5: Constructing Array Formulas |
|
Exercise 6-6: Finding the Source of Error Values in a
Spreadsheet |
|
Exercise 6-7: Solving a Circular Reference in a Formula |
|
|
Chapter 7: Creating Date and Time Formulas
|
Exercise 7-1: Building Formulas that Calculate Elapsed
Dates and Times |
|
Exercise 7-2: Building Formulas with Common Date
Functions |
|
Exercise 7-3: Building Formulas with Date Functions in
the Analysis ToolPak |
|
Exercise 7-4: Building Formulas with Common Time
Functions |
|
|
Chapter 8: Financial Formulas and Functions
|
Exercise 8-1: Building Formulas with the FV, PV, PMT,
RATE, and NPER Functions |
|
Exercise 8-2: Building Formulas with the IRR and NPV
Functions |
|
Exercise 8-3: Building Formulas with the SLN, SYD, DB,
and DDB Depreciation Functions |
|
|
Chapter 9:
Using Math Functions
|
Exercise 9-1: Building Formulas the ROUND, ROUNDUP, and
ROUNDDOWN Functions |
|
Exercise 9-2: Building Formulas with the PRODUCT,
POWER, and SQRT Functions |
|
Exercise 9-3: Building Formulas with the SUMPRODUCT,
SUMSQ, and SUMX2PY2 Functions |
|
|
Chapter 10: Using
Common Statistical Functions
|
Exercise 10-1: Building Formulas with the AVERAGE and
MEDIAN Functions |
|
Exercise 10-2: Building Formulas with the MAX and MIN
Functions |
|
Exercise 10-3: Building Formulas with the COUNT,
COUNTBLANK, COUNTA, and COUNTIF Functions |
|
|
Chapter 11: Using the Lookup Functions
|
Exercise 11-1: Building Formulas that Perform
Horizontal Lookups in a Table |
|
Exercise 11-2: Building Formulas that Perform Vertical
Lookups in a Table |
|
Exercise 11-3: Using the Lookup Wizard to Build
Formulas that Perform Two-Way Lookups in a Table |
|
|
Chapter 12: Using the Logical Functions
|
Exercise 12-1: Using the IF Function to Build Formulas
that Select Alternate Values |
|
Exercise 12-2: Using the IF Function to Build Formulas
that Perform Alternate Calculations |
|
Exercise 12-3: Building Formulas with Nested IF
Functions |
|
Exercise 12-4: Building Formulas that Trap Error Values
|
|
|
Chapter 13: Text Formulas and Functions
|
Exercise 13-1: Building Simple Text Formulas that Join
Data Entries |
|
Exercise 13-2: Building Formulas with Text Functions
that Join Data Entries and Change Their Case |
|
|
Chapter 14:
Charting Spreadsheet Data
|
Exercise 14-1: Changing the Location of Existing Charts |
|
Exercise 14-2: Creating a New Embedded Chart |
|
Exercise 14-3: Making Formatting Changes to a Chart |
|
Exercise 14-4: Editing the Structure, Contents, and
Location of a Chart |
|
|
Chapter 15:
Adding Graphics to Spreadsheets
|
Exercise 15-1: Resizing and Grouping Graphic Objects |
|
Exercise 15-2: Adding Clip Art to a Spreadsheet |
|
Exercise 15-3: Importing Images from Graphics Files
into a Spreadsheet |
|
Exercise 15-4: Creating and Adding Graphics with the
Drawing Toolbar |
|
Exercise 15-5: Adding Text Boxes to a Spreadsheet |
|
Exercise 15-6: Constructing WordArt in a Spreadsheet |
|
|
Chapter 16: Building
and Maintaining Data Lists
|
Exercise 16-1: Constructing a New Data List and Adding
Records with the Data Form |
|
Exercise 16-2: Finding and Editing Records with the
Data Form |
|
Exercise 16-3: Sorting the Records in a Data List |
|
Exercise 16-4: Sorting the Records in a Data List on
More Than Three Keys |
|
Exercise 16-5: Sorting the Fields in a Data List |
|
Exercise 16-6: Subtotaling the Records in a Data List |
|
Exercise 16-7: Filtering the Records in a Data List |
|
Exercise 16-8: Querying an External Data Table |
|
|
Chapter 17:
Protecting the Spreadsheet
|
Exercise 17-1: Assigning a Password for Opening and
Editing a Workbook |
|
Exercise 17-2: Protecting a Worksheet |
|
Exercise 17-3: Doing Data Entry in a Protected
Worksheet |
|
Exercise 17-4: Protecting the Entire Workbook |
|
|
Chapter 18:
Doing What-If Analysis
|
Exercise 18-1: Constructing a One-Variable Data Table
in a Spreadsheet |
|
Exercise 18-2: Constructing a Two-Variable Data Table
in a Spreadsheet |
|
Exercise 18-3: Constructing Various Scenarios for the
Spreadsheet |
|
Exercise 18-4: Doing Goal Seeking in a Spreadsheet |
|
Exercise 18-5: Using Solver to Modify Multiple Input
Values in a Spreadsheet |
|
|
Chapter 19:
Generating Pivot Tables
|
Exercise 19-1: Modifying an Existing Pivot Table |
|
Exercise 19-2: Creating a New Pivot Table |
|
Exercise 19-3: Modifying the Formatting in a Pivot
Table |
|
Exercise 19-4: Modifying the Structure of a Pivot Table |
|
Exercise 19-5: Modifying the Summary Functions and
Adding a Calculated Field to a Pivot Table |
|
Exercise 19-6: Creating a Pivot Chart |
|
|
Chapter 20:
Publishing Spreadsheets as Web Pages
|
Exercise 20-1: Saving a Spreadsheet as a Static Web
Page |
|
Exercise 20-2: Creating a Web Page with an Interactive
Data Table |
|
Exercise 20-3: Creating a Web Page with an Interactive
Data List |
|
Exercise 20-4: Creating a Web Page with an Interactive
Pivot Table |
|
Exercise 20-5: Creating a Web Page with an Interactive
Chart |
|
Exercise 20-6: Exporting the Spreadsheet Data in a Web
Page Back to Excel |
|
Exercise 20-7: Importing Web Data into Excel with a Web
Query |
|
|
Chapter 21: Adding
Hyperlinks to Spreadsheets
|
Exercise 21-1: Adding Hyperlinks to Other Sheets in a
Workbook |
|
Exercise 21-2: Adding Hyperlinks to Other Documents |
|
Exercise 21-3: Adding Hyperlinks to Web Pages and
E-mail Addresses |
|
Exercise 21-4: Assigning Hyperlinks to Custom Menus and
Toolbars |
|
|
Chapter 22: Using
Macros
|
Exercise 22-1: Recording a New Macro |
|
Exercise 22-2: Recording a Macro Using Relative Cell
References |
|
Exercise 22-3: Assigning Macros to Custom Menus and
Toolbars |
|
|
Chapter 23: Using the Visual Basic Editor
|
Exercise 23-1: Editing a Recorded Macro in the Visual
Basic Editor |
|
Exercise 23-2: Making a Recorded Macro Interactive by
Adding an Input Dialog Box |
|
Exercise 23-3: Constructing a Custom Function in the
Visual Basic Editor |
|
Exercise 23-4: Building Spreadsheet Formulas with a
Custom Function |
|
Exercise 23-5: Saving a Custom Function as an Excel
Add-In |
|
Title: Excel 2003 For Dummies
Pub Date: September, 2003
Publisher: Wiley Publishing, Inc. ISBN:
0-7645-3756-3
Table of Contents at a Glance (click on any bullet to expand or
condense its Part):
| Introduction |
| Part
I: Getting In on the Ground Floor
| Chapter 1: What Is All This
Stuff? |
| Chapter 2: Creating a Spreadsheet from Scratch |
|
| Part
II: Editing Without Tears
| Chapter 3: Making It All Look Pretty |
| Chapter 4: Going Through
Changes |
| Chapter 5: Printing the
Masterpiece |
|
| Part
III: Getting Organized and Staying That Way
| Chapter 6: Oh, What a Tangled Worksheet We Weave! |
| Chapter 7: Maintaining Multiple Worksheets |
|
| Part
IV: Life Beyond the Spreadsheet
| Chapter 8: The Simple Art of Making Charts |
| Chapter 9: How to Face a
Database |
| Chapter 10: Of Hyperlinks and Web Pages |
|
| Part
V: The Part of Tens
| Chapter 11: Top Ten Features in Excel 2003 |
| Chapter 12: Top Ten Beginner
Basics |
| Chapter 13: The Ten Commandments of Excel |
|
| Index |
Originally conceived and written for the fourth generation of Microsoft
Excel, Excel 2003 For Dummies, composed for the eleventh generation,
marks the book's seventh revision. And with Microsoft's announcement of
Microsoft Office 2007, the twelfth version (see
The Future of
Microsoft Office for details), slated for release late next year, it looks
as though this will not be its last (see the News page on
this site for more on Office Excel 2007).
Excel 2003 All-In-One
Title: Excel 2003 All-In-One Desk Reference For
Dummies
Pub Date: September, 2003
Publisher: Wiley Publishing, Inc. ISBN:
0-7645-3758-X
Table of Contents at a Glance (click on any bullet to expand or
condense its Part):
| Introduction |
| Book
I: Excel Basics
| Chapter 1: Getting Acquainted with Excel |
| Chapter 2: Getting Help |
| Chapter 3: Customizing Excel |
|
| Book
II: Worksheet Design
| Chapter 1: Building
Worksheets |
| Chapter 2: Formatting
Worksheets |
| Chapter 3: Editing
Worksheets |
| Chapter 4: Managing
Worksheets |
| Chapter 5: Printing
Worksheets |
|
| Book
III: Formulas and Functions
| Chapter 1: Building Basic Worksheets |
| Chapter 2: Logical Functions and Error Trapping |
| Chapter 3: Date and Time
Formulas |
| Chapter 4: Financial
Formulas |
| Chapter 5: Math and Statistical Formulas |
| Chapter 6: Lookup, Information, and Text Formulas |
|
| Book
IV: Worksheet Collaboration
| Chapter 1: Sharing and Reviewing Workbooks |
| Chapter 2: Protecting
Worksheets |
| Chapter 3: Sharing Data with Other Programs |
| Chapter 4: Sharing Data via a SharePoint Team
Services Web Site |
|
| Book
V: Charts and Graphics
| Chapter 1: Charting Worksheet
Data |
| Chapter 2: Adding Graphic
Objects |
|
| Book
VI: Data Management
| Chapter 1: Building and Maintaining Data Lists |
| Chapter 2: Filtering and Querying a Data List |
|
| Book
VII: Data Analysis
| Chapter 1: Performing What-If Scenarios |
| Chapter 2: Generating Pivot
Tables |
|
| Book
VIII: Excel and the Web
| Chapter 1: Worksheets As Web
Pages |
| Chapter 2: Adding Hyperlinks to Worksheets |
|
| Book
IX: Excel and Visual Basic for Applications
| Chapter 1: Building and Running Macros |
| Chapter 2: VBA Programming |
|
| Index |
The Excel 2003 All-In-One Desk Reference For Dummies (which I
originally wrote for 2002 release of Microsoft Excel) takes up where my Excel
2003 For Dummies leaves off. In this much bigger book, I get a chance to
familiarize you with all the types of functions built into Excel as well as
introduce you to the many what-if analysis tools, including the incredibly
powerful Pivot Tables, in Excel 2003. I also get a chance to present important
information on collaborating and sharing worksheets, including as part of
SharePoint team sites, a new Microsoft technology that is just now becoming more
widely adopted by businesses both large and small.
|
