Product Description
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.

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

[Details]

Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12.


[The rest]

75 tips and tricks for your favorite spreadsheet.


Share Link

Author: John Walkenbach (Mr. Spreadsheet)
Publisher: Wiley
Date: 2007
Pages: 1061

Packed with procedures, tips, tricks, techniques, and ideas, this guide provides comprehensive, coverage of the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features.

Share Link
Share Link Mirror