Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr.
Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr.
John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.
Inhaltsangabe
Acknowledgments ix
Introduction xxxvii
Is This Book for You? xxxvii
Software Versions xxxvii
Conventions Used in This Book xxxviii
Excel commands xxxviii
Filenames, named ranges, and your input xxxviii
Key names xxxviii
Functions xxxviii
Mouse conventions xxxix
How This Book Is Organized xl
How to Use This Book xl
What's on the Website xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 101
Chapter 6: Worksheet Formatting 119
Chapter 7: Understanding Excel Files 145
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171
Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions 195
Chapter 11: Creating Formulas That Manipulate Text 231
Chapter 12: Working with Dates and Times 251
Chapter 13: Creating Formulas That Count and Sum 285
Chapter 14: Creating Formulas That Look Up Values 313
Chapter 15: Creating Formulas for Financial Applications 333
Chapter 16: Miscellaneous Calculations 359
Chapter 17: Introducing Array Formulas 373
Chapter 18: Performing Magic with Array Formulas 397
Part III: Creating Charts and Graphics 419
Chapter 19: Getting Started Making Charts 421
Chapter 20: Learning Advanced Charting 457
Chapter 21: Visualizing Data Using Conditional Formatting503
Chapter 22: Creating Sparkline Graphics 525
Chapter 23: Enhancing Your Work with Pictures and Drawings539
Part IV: Using Advanced Excel Features 561
Chapter 24: Customizing the Excel User Interface 563
Chapter 25: Using Custom Number Formats 573
Chapter 26: Using Data Validation 591
Chapter 27: Creating and Using Worksheet Outlines 603
Chapter 28: Linking and Consolidating Worksheets 613
