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?

  1. Highlight the data to hide.
  2. Press Ctrl + ..
  3. In the Format Cells dialog, select Custom.
  4. Replace the General in the Type textbox field with ;;;
  5. Click OK.
Format cell data to hide contents.

  • 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.

    LEARN MORE


  • Excel Flash Fill Learns By Example

    Excel flash fill examples and patterns.

    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.

    LEARN MORE


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.

    LEARN MORE

    Module table showing browser extension info
  • 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.

    LEARN MORE

    Excel formula to parse name
  • 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.

    LEARN MORE

    Filtering for Gmail address to delete
  • 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.

    LEARN MORE

    Header area of Word letterhead
  • 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.

    LEARN MORE

    Tabs from other devices in Chrome history.
  • Video: Create Gmail Distribution List

    Video of how to delete Gmail in blulk

    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.

    LEARN MORE