Of all the work related items I need to do, the one I hate is data entry. It’s mind numbing and given the chance, I’ll make mistakes. One way I found to make the process easier is to use the Excel data form. It’s great when the records span across many cells.
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:
Few people would argue that Microsoft Word is a versatile program. The problem is that the software may not be the best tool to convert your Word documents to HTML. This is true if you need watch file sizes as it adds code that increases page size. It may also include information you don’t expect. If you need to get your Word content to the web, I’ve got some tips and alternatives.
Excel pivot tables are a feature that you should learn. Instead of analyzing countless spreadsheet records, a pivot table can aggregate your information and show a new perspective in a few clicks. You can also move columns to rows or vice versa. The problem is people believe creating a pivot table is difficult to learn. Grab a seat and we’ll guide you through a short tutorial so you can start data crunching. (Includes example worksheet.)
Printed letterhead is nice, but can be costly. If you don’t print a lot of letters, you might be interested in creating your own letterhead. It just takes a few minutes using Microsoft Word to create a template file with your address and logo.
Learn how to use Excel autofilters to make large spreadsheets more manageable. This feature lets you filter columns by specific entry values. Includes sample spreadsheet.
This tutorial shows how to use an input file from Microsoft Excel as the data source to do a mail merge in Microsoft Word.
Excel has a built-in function called LEN that counts the number of characters in a cell. This can be very useful for counting characters and finding problem records.
When I mention Google web history to people, they think of web cookies and the items they typed in Google’s search box. Many people are comfortable with their browser storing this information. If not, they delete their browser cookies and cache. However, Google can capture a …
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.
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.