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
The Excel 2007 All-in-One Desk Reference For Dummies brings together plain and simple information on using all aspects of the latest and greatest version of Microsoft Excel. It’s designed to be of help no matter how much or how little experience you have with the program. As the preeminent spreadsheet and data analysis software for the personal computer, Excel offers its users seemingly unlimited capabilities too often masked in technical jargon and obscured by explanations only a software engineer could love. On top of that, many of the publications that purport to give you the lowdown on using Excel are quite clear on how to use particular features without giving you a clue as to why you would go to all the trouble.
The truth is that understanding how to use the abundance of features offered by Excel is only half the battle, at best. The other half of the battle is to understand how these features can benefit you in your work, in other words, “what’s in it for you.” I have endeavored to cover both the “how to” and “so what” aspects in all my discussions of Excel features, being as clear as possible and using as little tech-speak as possible.
Fortunately, Excel is well worth the effort to get to know because it’s definitely one of the best data processing productivity tools that has ever come along. Its all new Ribbon user interface, Live Preview feature, and tons of ready-made galleries make this version of the program the easiest to use ever. In short, Excel 2007 is a blast to use when you know what you’re doing, and my great hope is that this “fun” aspect of using the program comes through on every page (or, at least, every other page).