If you’ve ever wanted to dabble with Excel macros, this tutorial and video on the macro recorder will get you started. Includes a sample workbook link so you can follow along.
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:
One way to make your Excel spreadsheets smarter is to use the IF function. The program will evaluate one field to see if it’s true and enter a new value based on whether the condition was met. This article and sample worksheet shows a simple example of calculating an allowance.
VLOOKUP is one of the most popular spreadsheet functions with spreadsheet wizards. It allows you to lookup needed values and use them elsewhere in your spreadsheet. This tutorial will show you step-by-step how to use the function with the accompanying file.
Many of us have been conditioned to block pop-ups in our web browsers. I do this because most of them are intrusive and hinder me from reading. The problem is sometimes you need pop-ups as they are part of the site. This happened to me when I was going through an online course. Fortunately, Google has a way to selectively allow pop-ups in these cases.
I’m a creature of habit and each Wednesday I go to my local supermarket’s website to see the specials. Certain of these specials are unique to me so I need to log in to see them. This week I couldn’t log in. Each time I got a message saying my session expired and to log in again. I had a pretty good idea that the problem was with some site cookie. The good news is there are multiple ways to clear cookies for one site with Google Chrome.
This Excel tutorial shows you how to build a worksheet using dependent lists. In other words, the selection you make from one list defines the options on the next list. For example, if you select California from one list, the next list filters your selection to just California agents. Includes sample Excel worksheet.
Recently, a friend asked about fixing an Excel spreadsheet where the subscriber name was in 1 column. He wanted the name separated so he could send a personalized mailing. This is not the first time this question has arisen. The key to solving this problem is to parse or split the data using the Text to Columns feature.
Sometimes it’s too easy to rely on built-in proofing tools to catch mistakes. Spellcheckers are great for misspelling, but what if your typo resulted in a word that is spelled correctly? There is a feature in Microsoft Word that can help prevent embarrassing mistakes.
This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.
Excel allows you to sort your columns and rows by lots of ways. One less obvious way is to sort items by color. This is handy if you apply a background color to a cell or different font color. This tutorial explains how to do the sort. You can also filter by color.