Keyboard shortcuts are a great way to enhance your productivity. The benefits are compounded the more you use a program like Gmail. The problem is learning them and committing them to memory. In the case of Gmail, there are quite a few and some don’t seem intuitive to me. I decided to test the TinyCards system and build a card deck to help me learn them faster. And you can get it too.
People often think Google Docs isn’t full-featured. However, it can handle many of the tasks of commercial programs. But sometimes, you just have to know how to work around the system. In this tutorial, I show how to make a letterhead template with a logo.
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.
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.)