I get asked this one a lot! How do I highlight an entire row when a particular cell contains a certain value? For example, if the total sales for the year are under $2,000, highlight the row in red. The secret is to use a formula to determine which cells to format. In fact, that [...]
What happened to colors in Outlook 2007 and Outlook 2010? If you’re confused about color, you’re not alone. If you went from 2003 to 2007 and 2010, you know they seem to keep moving the simple tools you used to use to color code emails and other Outlook items. Colors are a great tool to [...]
If you’re using Office 2007 and wondering whether it’s worth the trouble to upgrade to Office 2010, take a look at a few new features for each application, then decide. OutlookUnder the heading of “new” and “cool” in Outlook has to be the new conversation cleanup feature. When several people use Reply All in a [...]
7 new features of Office 2010. Some things you have been waiting for for years. Others are just plain cool.
Did you just get Windows 7? Just because you can use Windows 7 in many of the same ways you were using Windows XP does not mean you necessarily should. Here are five new things that you can do in Windows 7. 1. Finding programs is just a matter of typing in the first few [...]
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.
Don’t copy/paste data from the web, use Excel’s external data import tools.
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.
Three techniques to navigate complex Word 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.