It takes more than technology to be productive.
Most everyone appreciates technology and its promise. The flip side is it can also be a pain. It could be you have the right tools, but you aren’t sure how to use them to your advantage. How many times have you stared at a screen and wondered, “now what?”. I have, and it’s frustrating. The goal of this site is to pass on my learnings.
Whether you’re frustrated or simply trying to level up your skills, we’d like to help. We’ve written many tutorials and informative articles covering everything from Amazon’s Alexa to Microsoft Excel with lots in between. And we’re open to suggestions.
TODAY’S TIP
Hide Excel Cell Data Tip
Ever have a scenario where you want to hide some cell values but still have them show in the formula bar?
- Highlight the data to hide.
- Press Ctrl + ..
- In the Format Cells dialog, select Custom.
- Replace the General in the Type textbox field with ;;;
- Click OK.
FEATURED ARTICLES
-
How to Check Excel Cells for Specific Text
Not long ago, a friend challenged a comment I made. It had to do with word choices and if people use one verb more than others. In this article, I’ll show you how to tell if an Excel cell contains specific text. We’ll test this out using a series of questions people posed to Google.
-
Excel Flash Fill Learns By Example
Learn how to easily manipulate cell entries with Excel Flash Fill. The feature doesn’t rely on formulas or coding. You simply have to find a pattern and Excel’s machine learning does the rest.
EASY TUTORIALS
-
How to Find All Your Chrome Extensions and Folders
Many times when troubleshooting browser issues you need to find out all the extensions. This can be a time-consuming process. In this tutorial, I’ll show you how to find all your browser extensions using net-export. The nice thing about this tool is it also shows the extension ID which is the folder name.
-
How to Separate Names in Excel
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. Includes workaround when you have middle names or initials too.
-
Easy Ways to Bulk Delete Gmail
Are you like me and have a habit of letting your Gmail Inbox get big? Many of my emails are not a priority, such as promotional emails. In this tutorial, I’ll show you how to bulk delete emails on Gmail using email addresses, text patterns, dates, statuses, and search operators.
-
How to Create a Letterhead in Microsoft Word
Printed letterhead stock is nice, but can be costly. If you don’t print a lot of letters, you might want to make your own letterhead in Microsoft Word. It just takes a few minutes to create a template file with your address, logo, and other items you want. This is a great solution for solopreneurs and small businesses.
-
How To View Your Chrome History
When I mention Google web history to people, they think of items they typed in Google’s search box. Many people are comfortable with their browser storing this information. Google and other search engines use that data to refine your future search results. This is all part of Google’s effort to deliver personalized search and faster pages. But sometimes you want to delete that information.
FEATURED VIDEO
-
Video: Create Gmail Distribution List
This short video with captions and transcript shows you how to make a distribution list in Gmail. This works with either the free or paid plans with Google.