Excel is a very powerful program, but sometimes it doesn’t act the way we wish. A case in point is importing a CSV file with zip codes. If you’re not careful how you open your file and apply different formats, you could be in for some surprises. Excel may drop your leading zeros. The same problem
Tutorial Listing
These pages include all the 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:
Microsoft Excel
Microsoft Word
Google - (Includes Chrome, Gmail, Docs & Search)
Microsoft Outlook
Terms - Articles about different technologies
This section is several pages long so be sure to use the blue Next Page >> button at the bottom of the search box to the right.
Some reader favorites include:
How to use VLOOKUP
How to clean up your Gmail account
How to remove Chrome Extensions
How to create a Gmail distribution list
How to create a Cornell Notes template in Word
How to Add a Signature in Outlook.Com
Microsoft has several email products. One of the most popular ones is the free version called Outlook.com. However, the feature set is different than the paid counterpart in Microsoft 365 (Previously called Office 365). One difference deals with creating your email signature. Most of the
Quick Guide to Excel Solver
Some time back, I wrote an article about a useful function in Microsoft Excel called Goal Seek. It quickly allows you to solve easy “what-if” scenarios. Although helpful, it comes with limitations. However, Microsoft has a more powerful add-in analysis tool called Excel Solver that overcomes these
Beginners Guide to EXCEL XLOOKUP
One of the more exciting software features to be released in Excel is the XLOOKUP function. Just looking at the name, you might think I did a typo and meant VLOOKUP. No, this is an entirely new spreadsheet function that makes looking up data easier with fewer limitations on your lookup column. In
How to Add Your Outlook HTML Signature
Email signatures can be a great marketing tool. However, I often run into people and business owners who struggle trying to get their HTML versions into Microsoft Outlook. The process to add the code to emails is a bit different. Below are two ways you can add them. For this tutorial, I’m using
Test Before You Import Contacts to Gmail
I was updating a Google article and decided I need to start fresh because the interface changed. I thought it would be faster if I imported a CSV file to Google Contacts. Not really. It took me a couple of tries. The good news is that you can learn from my mistakes. Attempt 1: Total
Simple Ways to Protect Your Online Accounts
I met a friend for dinner who found out that someone broke into his online accounts. Naturally, he was concerned about his data, but also the amount of time it would take to fix the problem. I told him one way to reduce the risk of account breaches is to use something called "two factor
Learn More about Simple Ways to Protect Your Online Accounts
Printing Text in Reverse
Sometimes it’s the little things that trip you up like figuring out how to print text in reverse. I’m not trying to imitate Leonardo Da Vinci and his mirror fonts. Instead, I was trying to help someone do a t-shirt transfer that included a quote. It turns out there are multiple ways to solve this