This week was one where multiple requests converged. I had two friends that needed to send emails to their customers. One had their information in an Excel spreadsheet and the other exported their internal databases to Excel. Both thought there were problems with many email addresses and wanted to know if there was an easy way to find invalid email addresses before sending out the emails.
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:
Sometimes Gmail’s simplicity makes people think it is missing features. A case in point is distribution lists or group lists. Many people think that it’s not possible to send an email to a group of contacts or email addresses. The truth is that you can create personal Gmail distribution lists in a couple of easy steps by using Gmail groups.
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.
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.)