Table of Contents

Introduction. Part I: Creating Spreadsheets.

Chapter 1: Getting Familiar with the Excel 2007 Interface.

Chapter 2: Entering the Spreadsheet Data.

Chapter 3: Formatting the Spreadsheet.

Chapter 4: Printing Spreadsheet Reports.

Chapter 5: Modifying the Spreadsheet.

Part II: Using Formulas and Functions.

Chapter 6: Building Formulas.

Chapter 7: Copying and Correcting Formulas.

Chapter 8: Creating Date and Time Formulas.

Chapter 9: Financial Formulas and Functions.

Chapter 10: Using Math Functions.

Chapter 11: Using Common Statistical Functions.

Chapter 12: Using Lookup Functions.

Chapter 13: Using Logical Functions.

Chapter 14: Text Formulas and Functions.

Part III: Working with Graphics.

Chapter 15: Charting Spreadsheet Data.

Chapter 16: Adding Graphics to Spreadsheets.

Part IV: Managing and Securing Data.

Chapter 17: Building and Maintaining Data Lists.

Chapter 18: Protecting the Spreadsheet.

Part V: Doing Data Analysis.

Chapter 19: Performing What-If Analysis.

Chapter 20: Generating Pivot Tables.

Part VI: Macros and Visual Basic for Applications.

Chapter 21: Using Macros.

Chapter 22: Using the Visual Basic Editor.

Part VII: The Part of Tens.

Chapter 23: Top Ten Features in Excel 2007.

Chapter 24: Top Ten Tips for Using Excel Like a Pro.

Appendix: About the CD.

Index.

About the Author

Greg Harvey, PhD, is president of Mind Over Media, Inc. and an experienced trainer and teacher who has written numerous books on Excel.