### Learning about the ACCRINTM Function in Excel

April 3, 2014

ACCRINTM Returns the accrued interest for a security that pays interest at maturity.   ACCRINTM(issue; settlement; rate; par; [basis])   The ACCRINTM function Read More

### Using the ACCRINT Function in Excel

April 1, 2014

Now we are going to learn all about formulas and functions. This is the best way to learn them:     ACCRINT Returns Read More

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

March 26, 2014

Save 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

Save 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

### How to Make a Supply and Demand Chart

March 16, 2014

One of the basics concepts in the economic class in the high school and in the university were the supply and demand law Read More

### How to Create a Car Loan Calculator and Amortization Schedule in Excel

March 15, 2014

In this post we are going to explain you, in an easy way, how to create a useful application in Excel to calculate Read More

### Make an Excel Calendar

March 14, 2014

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

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

Save 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

Save 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