The Unofficial Guide To Microsoft Office Excel 2007

0.0

The Unofficial Guide to Excel 2007 answers the questions users need most and gives reader's insider guidance and valuable tips on how to exploit the capabilities of Excel. They'll find savvy advice on everything from simple tasks like working with data to complicated macros and how they can expedite repetitive or common tasks. This comprehensive, easy-to-follow guide reveals what other sources won't and presents unbiased recommendations to help users get the most out of Excel. This book begins with the basics like formatting cells and takes you through programming with VBA. Aimed primarily at those users looking for more than the conventional wisdom on to how to get the best out of Excel 2007 in the most efficient way, The Unofficial Guides are the answers they are seeking.

0.0

Julia Kelly is a writer, teacher, and consultant for desktop applications, including Excel, Access, Word, Publisher, and Outlook. She's taught classroom courses in Excel at major corporations and Outlook courses on-line for several years, and has authored 17 books on Office applications. In addition, she develops Excel and Access applications for business clients. Curt Simmons is a freelance author and technical trainer. Curt received a BA in English and Communications and a Master's degree in Education, and began his career teaching high school English. After going to work for a software company in 1997, Curt moonlighted as a technical editor before starting his own technical writing career. Curt has written more than thirty computing books on a variety of topics, from high-level networking to friendly computing guides. He also teaches several Internet courses on computing and digital photography. Table of Contents Part I Starting Out with Excel 2007 1 Getting In and Out 2 All about Worksheets Part II Crunching Numbers 3 Entering and Editing Data 4 Working Data Magic with Calculations 5 Excel Functions Part III Dressing Up Your Data 6 Formatting Cells 7 Formatting Numbers and Using Styles Part IV Organizing Data 8 Organizing Data 9 Finding and Comparing Answers 10 Summarizing Data Dynamically with PivotTables 11 Displaying PivotTables Graphically with PivotCharts Part V Presenting Your Data 12 Presenting Data Visually with Charts 13 Formatting Charts 14 Adding Pictures and Graphic Objects Part 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 Part VII Making Excel Your Own 19 Customizing Your Workspace 20 Adding Controls to a Worksheet 21 Using Macros to Automate Repetitive Work Part VIII Appendixes Appendix A: Build Creative Worksheets Appendix B: Recommended Resources Glossary Index