MCS

We just started the Colorado Excel Users Group. Join us in Twitter, Facebook, Linkedin, or Google Groups for Tips and Tricks on Microsoft Excel. Everyone is welcome, from Power users to novices. Join now!

Microsoft Excel can figure Mortgage payments with a quick built in function. Learn more with this quick tip.

Can Microsoft Excel count the number of days between events? You Bet! Click on the tip to see how.

In Microsoft Excel, there are 2 ways your grid lines can dissapear. Learn how to display your Excel Grid lines with this tip.

I want to show more or fewer decimal places then what Excel shows by default. How do I determine the number of decimal places visible?

Have you ever tried to calculate a column of dollar amounts in Excel but noticed that it’s a few cents off? That is because Excel calculates all of the decimal places, even those that are hidden. The “displayed” total looks incorrect, because the actual calculation is being done by Excel on the underlying numbers, but the result is being rounded.

MCS can customize existing classes to an organization’s specific needs and applications. In this case study, we talk about a successful project we completed for APL, a large business with offices in Littleton Colorado. Our customized Excel class was a hit. Click on the title to read more.

Compound interest is used in mortgages, loans, investments, and anything else that pays interest multiple times. It basically means that interest is paid on both the principal AND the past interest. Microsoft Excel can run these computations for you.
When a percentage rate compounds a set number of times per year (for instance monthly or quarterly), [...]

Any word or image in a Microsoft Outlook e-mail can hyperlink to a document or webpage just like on the internet. E-mail addresses and Web addresses automatically do this (just type the address including the www or @ sign for e-mail and hit Enter or the Space Bar), but you can link words or phrases [...]

Transposing Data allows you to re-arrange a table so the rows become the columns or vice versa – basically interchanging the two.

Select and copy a range of cells that you want to transpose
Select the cell where you want the new transposed table to start
On the Home tab, in the Clipboard group, click the drop-down arrow [...]