Greg Harvey - 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 " X" All In One Desk Reference For Dummies will be completely updated to reflect the major changes Microsoft is making to Office which includes notable changes such as a complete redesign of the interface to emphasize tasks, a more graphical interface, emphasis on collaboration, application servers, easier document searching and more! From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, the Excel X All-in-One Desk Reference For Dummies provides the reader with a broad scope of the most common Excel applications and functions - including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. Covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include: worksheet sharing and ...