Excel 2007 For Dummies

From the Inside Flap
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

From the Back Cover
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
Greg Harvey 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.

Related Articles

Microsoft Office Excel 2007 For Dummies

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 is here!
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.

Excel Workbook For Dummies

Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant’s green sheet, and mastering even the most basic functions can be a challenge.”Excel Workbook For Dummies” is specially designed to give you the hands-on experience you need to start using this great program with confidence and efficiency. This guide is packed with hundreds of exercises that walk you through the ins and outs of Excel at your own pace. You’ll have all the tools you need to: Enter spreadsheet dataFormat, modify, and print your spreadsheetCopy and correct formulasCreate date and time formulasUse math, statistical, lookup, and logical functionsChart spreadsheet dataAdd graphics to the spreadsheetManage and secure your dataPerform what-if analysesGenerate pivot tablesPublish spreadsheets as Web pagesAdd hyperlinks to spreadsheetsTake advantage of Macros and Visual Basic Editor

Included is a bonus CD-ROM full of useful features, including sample files for all exercises in the book, a variety of important Excel tools, worksheets, and templates for financial planning, and a trial version of Crystal Xcelsius to get you started making progress and becoming an Excel expert

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Excel 2007 Workbook For Dummies

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

* Set up, format, and edit basic spreadsheets
* Manage and secure your Excel data
* Create formulas and functions for finance, date and time, math, text, and more
* Master data analysis with pivot tables
* Save and share your spreadsheet data

Quick refresher explanations
Step-by-step procedures
Hands-on practice exercises
Tear-out Cheat Sheet
A dash of humor and fun

All this on the bonus CD-ROM

* Dynamic video walk-throughs demonstrate Excel features and tasks
*Practice files let you work through the exercises in the book

For details and complete system requirements, see the CD-ROM appendix.

Microsoft Office Excel 2007 AIO Desk Reference For Dummies

Master the Ribbon, powerful graphics capabilities, and more!
Your one-stop guide to great-looking spreadsheets that actually mean something

Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!

Discover how to
– Create dynamic spreadsheets with style galleries
– Work with more than 40 new cell styles
– Automate formatting with Live Preview
– Share Excel data with other programs
– Use VBA to write custom Excel functions

Excel 2007 All-In-One Desk Reference for Dummies

Master the Ribbon, powerful graphics capabilities, and more!
Your one-stop guide to great-looking spreadsheets that actually mean something

Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!

Discover how to

Create dynamic spreadsheets with style galleries
Work with more than 40 new cell styles
Automate formatting with Live Preview
Share Excel data with other programs
Use VBA to write custom Excel functions