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

Tip: Quickly re-start the last used tool

May 17, 2013 0

Start the last used utility againSave 5 minutes a day by quickly starting the last tool again that you used from ASAP Utilities. “Easily start again the tool you just used” Sometimes you need to use a tool several times in sequence. Instead of having to go through the (sub)menus to find and start the tool again, we’ve created a […] Read More

1 14 15 16
Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips