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.
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.
You can use the menu at the top to filter by a category or use the links at the bottom of the post summary. You will also find page navigation buttons at the bottom.
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.
We’re living in an interconnected world which offers a lot of conveniences. We can use Google, Facebook, OAuth to connect us to online services and apps. The downside is that there are more “bad actors” trying to trick us and gain access to our info.
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.
One of my favorite quotes comes from Yogi Berra who said “You can observe a lot by just watching”. In this case, I was watching someone work with Excel and doing various tips to make the spreadsheet more usable. In fact, I’ve written about many of those tips. I suggested to my co-worker that he could reduce steps by using Excel Tables. And no, I’m not talking about pivot tables but something simpler and equally powerful. (Includes sample Excel file.)
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.
Excel allows you to sort you sheet 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.