Page 12 - Excel Workbook for Dummies

02_798452 ftoc.qxp 3/14/06 10:34 AM Page ix

Table of Contents

Introduction .................................................................................1
About This Book.........................................................................................................................1
Conventions Used in This Book ...............................................................................................1
Foolish Assumptions .................................................................................................................2
How This Book Is Organized.....................................................................................................2
Part I: Creating Spreadsheets .........................................................................................3
Part II: Using Formulas and Functions...........................................................................3
Part III: Working with Graphics.......................................................................................3
Part IV: Managing and Securing Data.............................................................................3
Part V: Doing Data Analysis ............................................................................................4
Part VI: Excel and the Web..............................................................................................4
Part VII: Macros and Visual Basic for Applications .....................................................4
Part VIII: The Part of Tens ...............................................................................................4
Using the Practice Material on the CD-ROM...........................................................................4
Icons Used in This Book............................................................................................................5
Where to Go from Here..............................................................................................................6

Part I: Creating Spreadsheets ........................................................7

Chapter 1: Entering the Spreadsheet Data.........................................................................9
Launching Excel .........................................................................................................................9
Opening a New Workbook.......................................................................................................10
Moving around the Workbook................................................................................................12
Moving within the displayed area................................................................................12
Moving to a new area of the worksheet.......................................................................12
Moving to a different sheet in the workbook..............................................................14
Selecting Cell Ranges...............................................................................................................14
Making Cell Entries ..................................................................................................................15
Entering data in a single cell.........................................................................................16
Entering data in a cell range .........................................................................................18
Filling in a data series with the Fill handle..................................................................19
Copying a formula with the Fill handle........................................................................20
Saving the Spreadsheet in a Workbook File..........................................................................20

Chapter 2: Formatting the Spreadsheet............................................................................23
Resizing Columns and Rows...................................................................................................23
Making column widths suit the data............................................................................24
Manipulating the height of certain rows .....................................................................25
Cell Formatting Techniques....................................................................................................26
Formatting cells with the Formatting toolbar ............................................................26
Formatting cells with the Format Cells dialog box ....................................................27
Using Format Painter and AutoFormat........................................................................31
Using Conditional Formatting.......................................................................................33
Hiding Columns and Rows......................................................................................................34