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