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 the … [Read more...] about See Excel Filter Criteria Above Your Column Titles
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 … [Read more...] about What is USB – Universal Serial Bus?
Of all the work-related items I need to do, the one I hate is inputting data. It’s mind numbing and given the chance, I’ll make mistakes. One way I found to make the process easier is to use Excel forms. These data entry forms are especially beneficial when your records span across many columns. … [Read more...] about These Excel Forms Make Data Entry Easy
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 Word 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 … [Read more...] about What to Consider When Converting Word to HTML
Excel pivot tables are a feature that you should learn how to use. Instead of analyzing countless spreadsheet records, these tables 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 … [Read more...] about How to Use Excel Pivot Tables to Organize Data