Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Win a Trip to New York City to see Monty Python's SPAMALOT!
Excel 2007 Workbook For Dummies

Excel 2007 Workbook For Dummies


By Greg Harvey, PhD

ISBN: 978-0-470-16937-7
Format: Paper
Pages: 408 Pages
Pub. Date: September 2007

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
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.

Related Articles
Getting to Know Basic Data Entry in Excel
Fooling Around with the Excel Format Painter
Creating a New Chart with the Excel Chart Wizard
Using Multiple Headers and Footers in Excel 2007 Reports
Using Time Functions in Excel 2007
Related Titles
Microsoft Office 97 For Windows For Dummies
Microsoft Office 97 For Windows For Dummies : Quick Reference
Microsoft Office 2000 9 in 1 For Dummies Desk Reference
Microsoft Office 2000 For Windows For Dummies
Microsoft Office 2000 for Windows For Dummies: Quick Reference