Have you ever received an Excel file and wondered how it was filtered without checking each column’s data filter? Or, maybe you needed to send a file and show your filters. That was a problem I faced recently when I started with a list of 3200 non-profits for the county. I needed a way for […]
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:
USB or universal serial bus has been around since the mid-nineties. Although the technology is ubiquitous, people are still confused by some USB types and limitations. I’ll admit it can be confusing, but I’m glad I no longer have to wrestle with parallel and serial ports. I’ll explain the differences and tell you how to find out which version you’re using.
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.
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 items they typed in Google’s search box. Many people are comfortable with their browser storing this information. Google and other search engines use that data to refine your future search results. This is all part of Google’s effort to deliver personalized search and faster […]