Have you ever found a great table of data on the web and then gone through a 90 step process to copy, paste and clean up that data to use in your Excel worksheet? In many cases, you can set up a link to that data that not only keeps the data in the tabular arrangement, but allows you to refresh your data when the web site updates.
There are two view attributes and a shortcut that can make it a snap to navigate around your really large and complex documents. The proper use of heading styles is required for one of these and is always a good idea in complex documents.
While animation can be overdone, when used judiciously, it can add punch to your message. This is one example of how to accomplish that goal in 5 steps.
4 great tips for using Microsoft Word, PowerPoint, Excel and Outlook to help you manage your holiday tasks.
I’m not sure whether it was intentional, but there seems to be something missing from the Create Pivot Table dialog box in Excel 2007 and 2010.
I have the opportunity in my teaching travels to witness many people hunting for the proverbial needle in the haystack, a.k.a. their Outlook® inbox. Like many of you who are technically inclined, I have to resist the urge to grab their mouse and keyboard and “show ‘em how it’s done.” Most of us don’t find that helpful at all, just intrusive. Instead, I thought I’d cover it here on my blog. There are 3 easy ways to quickly find what you’re looking for.
If you work with currency data and percentages, you have likely had an argument with that darned penny! You have flawlessly crafted your worksheet, expertly constructed formulas and can’t reconcile the penny that results when your calculations round up.
Columns are easy in Word 2007 and Word 2010! On the Page Layout tab, in the Page Setup group you’ll find a button called Columns. There are 5 default selections and a More columns selection to customize your column layout.
Start with a simple circle and experiment with the new powerful graphics tools in PowerPoint® 2007/2010. Very soon, you’ll find yourself forgetting all about hours of working in custom graphics packages, painstakingly crafting creative objects to enhance your presentations.
SmartArt is one of the biggest timesavers in the newer versions of Microsoft® Office. Especially useful for PowerPoint® and Word, it is a powerful way to represent ideas in pictures, which is the preferred learning method for between 1/3 and 2/3 of the population, depending upon which expert you ask.
Page 12 of 15«1…101112131415»