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.
Greg Harvey, PhD, is president of Mind Over Media, Inc. and an experienced trainer and teacher who has written numerous books on Excel.