The inside scoop.for when you want more than the official line!
Microsoft Office Excel 2007 may be just what you need to crunch numbers, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from two experts.
Unbiased coverage of how to get the most out of Excel 2007, from creating workbooks and writing formulas to comparing data
Savvy, real-world advice to help you set up, enter, format, and organize your data
Time-saving techniques and practical guidance on creating custom macros with VBA and using PivotTables and PivotCharts
Tips and hacks with practical ways to save time, avoid pitfalls, and increase your output
Sidebars, tables, and illustrations featuring toolbar buttons and more ways to be productive in Excel
Watch for these graphic icons in every chapter to guide you to specific practicalinformation. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 22.8 cm
Breite: 15.4 cm
Dicke: 2.7 cm
Gewicht
ISBN-13
978-0-470-04594-7 (9780470045947)
Schweitzer Klassifikation
Julia Kelly lives in rural north Idaho with horses, cats, small garden dogs, assorted wild animals, free-range chickens, and bird dogs who've finally learned not to "retrieve" the free-range chickens.
Curt Simmons lives in Saint Jo, Texas, with his wife and two daughters. The author of more than 50 computing books on a wide range of topics, he primarily writes about Microsoft products. When he is not writing, Curt enjoys gardening and working on his 107-year-old home.
I Starting Out with Excel 2007.
1 Getting In and Out.
2 All About Worksheets.
II Crunching Numbers.
3 Entering and Editing Data.
4 Working Data Magic with Calculations.
5 Excel Functions.
III Dressing Up Your Data.
6 Formatting Cells.
7 Formatting Numbers and Using Styles.
IV Organizing Data.
8 Organizing Data.
9 Finding and Comparing Answers.
10 Summarizing Data Dynamically with PivotTables.
11 Displaying PivotTables Graphically with PivotCharts.
V Presenting Your Data.
12 Presenting Data Visually with Charts.
13 Formatting Charts.
14 Adding Pictures and Graphic Objects.
VI Sharing Excel Data.
15 Printing Just What You Need.
16 Formatting the Printed Page.
17 Sharing a Workbook with Other Users.
18 Sharing a Workbook Between Programs.
VII Making Excel Your Own.
19 Customizing Your Workspace.
20 Adding Controls to a Worksheet.
21 Using Macros to Automate Repetitive Work.
VIII Appendixes.
Appendix A: Build Creative Worksheets.
Appendix B: Recommended Resources.
Glossary.
Index.
