Tip: Quickly remove spaces from the beginning and end of your data

March 26, 2014 0

Delete leading and trailing spacesSave 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. “Easily trim all leading and trailing spaces” Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or […] Read More

Tip: Easily COUNT or SUM cells based on their Color

March 21, 2014 0

COUNT or SUM cells with a certain colorSave 5 minutes a day by using ASAP Utilities to quickly count or sum cells based on their background color. “Did you ever have to SUM by Color or Count by cell Color?” I have a column that needs summed, but only the cells that are green… Working with cell colors can help to make […] Read More

Make an Excel Calendar

March 14, 2014 1

Welcome to Excel MOOC. Today we are going to learn how to make a dynamic calendar with Microsoft excel. You can use it to plan Read More

Tip: Quickly round the numbers in selected cells

February 21, 2014 0

Save 5 minutes a day by having ASAP Utilities quickly round the numbers for you. “Easily apply rounding to all numbers in your selection” It is a common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with this approach is that it can display totals that […] Read More

Tip: Easily keep only the filtered results

September 12, 2013 0

Keep only filtered results / remove all hidden rows and/or columnsSave 5 minutes a day by using ASAP Utilities to quickly remove all hidden rows and/or columns. “How can I quickly remove all hidden rows?” We were recently asked: “Does ASAP have a feature to convert filtered results ‘in place’ to convert a spreadsheet into just the filtered results? I know I can do it […] Read More

Quickly select or filter by strikethrough formatted text

August 12, 2013 0

Sort by strikethrough formattingSave 5 minutes a day by using ASAP Utilities to quickly select or filter by strikethrough formatted cells. “How can I filter for items that have a ‘Strikethrough’?” Strikethrough formatting (my struck through text) is often used to mark tasks as being completed or items to be ready for removal. The quickest way to apply […] Read More

1 14 15 16 17