The Unofficial Guide to Microsoft Office Excel 2007

The Unofficial Guide to Microsoft Office Excel 2007, 9780470045947 (0470045949), John Wiley & Sons, 2007

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!

About the Author

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.

Comments

Amazing Books

Mastering Financial Accounting Essentials: The Critical Nuts and Bolts (Wiley Finance)

John Wiley & Sons, 2009

An indispensable hands-on guide to financial accounting

In light of recent accounting scandals, it is critical that all financial practitioners understand and play by the rules of the accounting field. Starting from the assumption that the reader is not familiar with any accounting jargon, Mastering Financial Accounting...

OS X Mountain Lion Server For Dummies

For Dummies, 2012

Create a Mac network in your home or office

There's no doubt about it: Macs, iPhones, and iPads have invaded the workplace. But, you don't need an IT department to administer a Mac network in your home or business. This friendly guide explains everything you need to know to set one up yourself using OS X Mountain...

Sharing Expertise: Beyond Knowledge Management

MIT Press, 2002

The field of knowledge management focuses on how organizations can most effectively store, manage, retrieve, and enlarge their intellectual properties. The repository view of knowledge management emphasizes the gathering, providing, and filtering of explicit knowledge. The information in a repository has the advantage of being easily transferable...

Human Centered Design: Second International Conference, HCD 2011, Held as Part of HCI International 2011

Springer, 2011

The 14th International Conference on Human–Computer Interaction, HCI International 2011, was held in Orlando, Florida, USA, July 9–14, 2011, jointly with the Symposium on Human Interface (Japan) 2011, the 9th International Conference on Engineering Psychology and Cognitive Ergonomics, the 6th International Conference on...

$Good Math: A Geek's Guide to the Beauty of Numbers, Logic, and Computation (Pragmatic Programmers)$

Good Math: A Geek's Guide to the Beauty of Numbers, Logic, and Computation (Pragmatic Programmers)

Pragmatic Bookshelf, 2013

Mathematics is beautiful--and it can be fun and exciting as well as practical. Good Math is your guide to some of the most intriguing topics from two thousand years of mathematics: from Egyptian fractions to Turing machines; from the real meaning of numbers to proof trees, group symmetry, and mechanical computation. If you've ever...

Earthbag Building: The Tools, Tricks and Techniques (Natural Building Series)

New Society Publishers, 2004

Over 70 percent of Americans cannot afford to own a code-enforced, contractor-built home. This has led to widespread interest in using natural materials-straw, cob, and earth-for building homes and other buildings that are inexpensive, and that rely largely on labor rather than expensive and often environmentally-damaging outsourced materials....