- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
New Trade Paper
Ships in 1 to 3 days
Available for In-store Pickup
in 7 to 12 days
Other titles in the For Dummies series:
Excel 2007 Workbook for Dummies with CDROM (For Dummies)by Greg Harvey
Synopses & Reviews
< p> From formulas to functions to the latest features & #151; practice and plan Excel tasks with ease< /p> < p> Confused by Excel? Want to make the most of its capabilities? No worries & #151; this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice files and more than 30 walk-throughs of Excel features on the CD-ROM. Plus, you get full coverage of all the new and enhanced features of Excel 2007 < p> See how to < p> < ul> < li> Set up, format, and edit basic spreadsheets< /li> < li> < p> Manage and secure your Excel data< /li> < li> < p> Create formulas and functions for finance, date and time, math, text, and more< /li> < li> < p> Master data analysis with pivot tables< /li> < li> < p> Save and share your spreadsheet data< /li> < /ul> < p> Quick refresher explanations < p> Step-by-step procedures < p> Hands-on practice exercises < p> Tear-out Cheat Sheet < p> A dash of humor and fun < p> All this on the bonus CD-ROM < p> < ul> < li> Dynamic video walk-throughs demonstrate Excel features and tasks< /li> < li> < p> Practice files let you work through the exercises in the book< /li> < /ul> < p> For details and complete system requirements, see the CD-ROM appendix.
"Excel 2007 Workbook For Dummies" is structured like a normal For Dummies title by providing reference information the fun and easy way on how to perform a common or particularly challenging Excel task. The new feature in For Dummies workbooks then include exercises to practice or plan the task. The book includes a section on formulas and functions, creating graphic displays and data analysis with plenty of exercises and space for financial planners. The book focuses on the new and special features in Office 2007.
How This Book Is Organized
Part I: Creating Spreadsheets
Part II: Using Formulas and Functions
Part III: Depicting Data Graphically
Part IV: Managing and Securing Data
Part V: Doing Data Analysis
Part VI: The Part of Tens
Appendix: Using the Practice Material on the CD-ROM
From formulas to functions to the latest features — practice and plan Excel tasks with ease
Confused by Excel? Want to make the most of its capabilities? No worries — this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice files and more than 30 walk-throughs of Excel features on the CD-ROM. Plus, you get full coverage of all the new and enhanced features of Excel 2007!
See how to
Quick refresher explanations
Hands-on practice exercises
Tear-out Cheat Sheet
A dash of humor and fun
All this on the bonus CD-ROM
For details and complete system requirements, see the CD-ROM appendix.
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.
Table of Contents
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.
What Our Readers Are Saying
Other books you might like