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.)
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:
Ever had the situation where you need to go back to a web page you visited but can’t recall the URL or site? This happened to me this week. I knew the site name, but not the specific page. My attempts to find it using the site’s search didn’t work well. I couldn’t recall the right words and got too many results. And then I remembered I could find the page using my browser history.
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.
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.