Synopses & Reviews
One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies
If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.
You’ll discover how to:
- Rearrange, delete and insert new information
- Keep track of and organize data in a single worksheet
- Transfer data between the sheets of different workbooks
- Create a chart using the data in a worksheet
- Add hyperlinks and graphics to worksheets
- And more!
Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.
"...the simple guidance in this book will have you excelling at home or in the office in no time." (PQ Magazine, November 2007)
An introduction to the latest version of Microsoft's versatile spreadsheet program showcases the application's updated features and new user interface while explaining how to use Excel 2007 to build and format spreadsheets, sort and analyze data, and integrate spreadsheets with Web documents and other Office applications. Original. (Beginner)
With more than 2.5 million copies in print of previous editions, Excel For Dummies is the one indispensable guide to Excel, and this updated edition has been completely rewritten to reflect extensive changes in Excel 2007 Readers discover the notable changes to Microsoft Office, such as the complete redesign of the interface to emphasize tasks, a more graphical interface, easier document searching, and more Shows how to create and edit worksheets, enter formulas, create and edit charts, insert graphs, design database forms, and use seek-and-find options Demonstrates how to add hyperlinks to worksheets, save worksheets as Web pages, add existing worksheet data to an existing Web page, and send worksheets via e-mail Places a special emphasis on the changes to collaboration and application servers
Navigate Excel with the Ribbon and Office Button
Find out how to create and edit charts, add hyperlinks to worksheets, and more
Here's an excellent way to get the scoop on the cool features of Excel 2007, including the user-friendly interface, Live Preview, and easier collaboration options. You'll soon excel at organizing and maintaining your worksheets, doing "what-if" data analysis, dressing up your charts and graphs, playing with pivot tables, and sharing your stuff. The included four-color insert highlights the Ribbon, new graphics features, and more!
Discover how to
- Create and edit worksheets
- Design database forms
- Save your worksheet as a Web page
- Apply style galleries to spreadsheets
- Work with formulas
- Include graphics in your charts
About the Author
has authored tons of computer books, the most recent being Excel Workbook For Dummies
and Roxio Easy Media Creator 8 For Dummies,
and the most popular being Excel 2003 For Dummies
and Excel 2003 All-In-One Desk Reference For Dummies
. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.
Table of Contents
Part I: Getting In on the Ground Floor.
Chapter 1: The Excel 2007 User Experience.
Chapter 2: Creating a Spreadsheet from Scratch.
Part II: Editing Without Tears.
Chapter 3: Making It All Look Pretty.
Chapter 4: Going through Changes.
Chapter 5: Printing the Masterpiece.
Part III: Getting Organized and Staying That Way.
Chapter 6: Maintaining the Worksheet.
Chapter 7: Maintaining Multiple Worksheets.
Part IV: Digging Data Analysis.
Chapter 8: Doing What-If Analysis.
Chapter 9: Playing with Pivot Tables.
Part V: Life Beyond the Spreadsheet.
Chapter 10: Charming Charts and Gorgeous Graphics.
Chapter 11: Getting on the Data List.
Chapter 12: Hyperlinks and Macros.
Part VI: The Part of Tens.
Chapter 13: Top Ten New Features in Excel 2007.
Chapter 14: Top Ten Beginner Basics.
Chapter 15: The Ten Commandments of Excel 2007.