Microsoft Office Excel 2007 AIO Desk Reference For Dummies

ABOUT THE AUTHOR
Greg Harvey has authored tons of computer books, the most recent being Excel 2007 For Dummies, Windows Vista For Dummies Quick Reference, and Excel Workbook 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, he went on to teaching 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.

Related Articles

Excel 2007 AIO Desk Reference For Dummies

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 toCreate dynamic spreadsheets with style galleriesWork with more than 40 new cell stylesAutomate formatting with Live PreviewShare Excel data with other programsUse 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

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.

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 Timesaving Techniques For Dummies

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel’s menus and toolbars; modifying Excel’s editing settings; using add-ins, AutoCorrect, AutoFill, AutoFormat, and data validation; copying and moving data between worksheets; encrypting workbook files; creating external database queries; converting worksheet data and charts into Web pages; and much more.
* Written by Greg Harvey, one of the bestselling technology authors of all time, whose books have combined sales of more than four million copies
* A unique, two-column format makes it easy for readers to grasp and apply each technique-and begin working more efficiently