The problem with many Excel spreadsheets is they make the reader find the key information rather than using Excel to highlight these cells. Fortunately, Excel’s conditional formatting can make your data automatically stand out.
These pages include all the site tutorials regardless of category. These mainly cover Microsoft and Google products. In addition, there are some posts that provide information about key terms. Presently, the categories include:
This section is several pages long so be sure to use the blue Next Page >> button at the bottom or the search box to the right.
Some reader favorites include:
Have you every browsed the web and seen a reference to OPML? If you were to look up the abbreviation, you would see it stands for “outline processor markup language”. It’s used for describing outline-based content like articles and play lists. I think a better representation is “other people’s meaningful lists”.
Wrapping text around images in Microsoft Word can be a little bit tricky. This tutorial shows one way to accomplish the task using the picture toolbar.
Do you ever play the “what-if” game when you see data? For example, how many more widgets would we need to sell to get our 20% bonus. In my case, I was trying to figure out many more voters we needed to win. Excel has a simple feature for these type of questions.
In our earlier article we explained there were several ways to convert Microsoft Word data such as address listings to Microsoft Excel. This next method starts by converting your text to a table. You’ll probably find this method easier.
One item I’ve learned from using computers is that there is usually more than one way to solve a problem. This week two people approached me with a similar problem. They were trying to get a simple, but long address list from Microsoft Word into Microsoft Excel. One tried to use macros and the other resorted to cut and paste. In each case, I thought a simpler solution involved Word’s Search and Replace feature. Here’s Part 1 of a two part tutorial.
Excel has a the ability to set a range of cells and give them a name. You may have seen this when you print a certain area by highlighting the columns and rows. However, that same feature can be used in other areas such formulas. It makes interpreting your worksheet much easier.
One of the popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product number into a product name. One of my favorite Excel functions is the VLOOKUP function and it can help with this task. (Includes example spreadsheet and video.)
An interesting email question came in about MIMO. The reader wanted to know what it was and if these broadband routers could help solve his wireless situation. Defining MIMO is the easier part. The harder part is finding out if all MIMO routers should be considered. MIMO technology is used in broadband routers and cell […]
One problem people face is the proper sharing of sensitive information. The information can be anything from contracts, technical specifications, to resumes. A problem arises when you want to show the information, but not all of it for confidentiality or competitive reasons. In other words, you need to hide or remove text from a document. There are right and wrong ways to do this redaction or “blacklining” in Microsoft Word.