Excel, Word, Outlook, PowerPoint… Our Office partners are such familiar friends, but when they prevent us from doing what we need to do, they can turn into mortal enemies.A huge percentage of our readers spend time in Microsoft Office 2010 [for Windows ($499 direct, 4 stars) and Mac ($120, 4.5 stars)] for either professional or personal use, or for both. But even if you use Microsoft programs on a daily basis, there's always something you want to do—and you're certain it can be done!—but you don't know how.
As mature a suite of tools as Microsoft Office is, many of its most powerful features are hidden away, buried several levels deep in a menu (or hidden in sort of plain sight in the ribbon), and it's impossible to learn about them if you don't know Microsoft's terminology and thus are searching for the wrong words. Is it a "line" or a "rule" or a "border?"
We've shaken down the programs and pinpointed 100 tips and tricks to help put you back in command.These tips cover not only the basics, like deleting that infuriating line that appears when you type one too many hyphens in Word, to more advanced tricks, such as connecting your email to social websites and services.
We've also included some tips about features that you might not know to search for at all but which offer a lot of value and are worth knowing. Our tips are separated by program, and some are further parceled out into sections for beginners, intermediate-level users, and advanced users. Each tip is accompanied by a screenshot to further guide you, no matter your comfort level. All of our tips will work in Microsoft Office 2010, and many are also compatible with earlier editions of Office, too.
5 Essential Microsoft Office 2010 Tips for Everyone
The five how-tos in this piece will show you some of the most fundamental things you'll want to do in Microsoft Office, no matter which program you use most.
15 Essential Microsoft Word 2010 Tips for Beginners
If you consider yourself a novice with Microsoft Word, start your Office education by picking up a few of these 15 tricks. You'll soon find that they'll become second-nature actions that you'll be performing with a couple of clicks or keystrokes.
10 Essential Microsoft Excel 2010 Tips for Beginners
Fumbling with spreadsheets can makeanyone feel like a complete dolt. These ten essential functions and tricks will make you feel much more adept at creating and managing charts, lists, and data.
14 Essential Microsoft Outlook 2010 Tips for Beginners
Whether you're brand-new on the job or a 20-year veteran, chances are your company uses Microsoft Outlook and you only know as much as you've ever needed to get by day-to-day. Pick up 14 new ideas, and learn how to implement them, from this list.
14 Essential Microsoft Excel 2010 Tips for Intermediate Users
Comfortable with Microsoft Excel? Good! Let's move up a half-step to the next level of difficulty. Click through the title to find 14 new things you can do with spreadsheets.
10 Essential Microsoft Word 2010 Tips for Advanced Users
Let's say you've mastered the basics of Microsoft Word. These nine tips will expand your horizons to do some advanced tricks with macros, use OpenType typography, export a Word document to your blog, and more.
5 Essential Microsoft Excel 2010 Tips for Advanced Users
Fine tune your Excel skills with a few more masterful tricks. These five tips cover working with transposed tables, how to create Sparkline Microchartsin Excel, and more.
8 Essential Microsoft Outlook 2010 Tips for Intermediate & Advanced Users
After you've gone through our basic Outlook tips, turn to this next batch to make your email life even smoother and more efficient. Outlook can perform a few amazing stunts—don't miss out on any of them.
9 Essential Microsoft PowerPoint 2010 Tips
The last time you saw someone give a dynamite presentation, filled with video clips and text that was actually large enough to read at a distance, you probably made a mental note to teach yourself some new PowerPoint skills. And, lo, that day is finally here. Learn how to check the accessibility of your presentations, integrate videos, use the animation painter, and more.
10 Essential Microsoft Access 2010 Tips for Beginners
This ten-point primer for Microsoft Access users starts out with the basics and moves into slightly more difficult territory. Whether you're totally new to Access or have been struggling for a while to learn it, these ten simple tips will help you on your journey to becoming more proficient with databases.