MCS

Copy Excel Formulas

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

Fractions are easy to use in Microsoft Excel. With a couple of clicks you can transform your decimal places to fractions. 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.

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.

You can quickly calculate a formula based on a group cells without actually putting the formula into your spreadsheet.  You can quickly see the results of an Average, Count, Numerical Count, Min, Max, and Sum, etc. for a range of cells without writing the formula using a tool called AutoCalculate.

1. Select a range of cells [...]

You can name ranges of cells in Excel, like a column of information in a table, and then write formulas that use the names rather than cell references.  This makes formulas easier to understand when looking at them, so that you don’t have to refer to the specific cells. 

1. Select a range of cells
2. [...]

There is a quick key function that will allow you to toggle between displaying all formulas in a spreadsheet to displaying all values (the default normal view).  This is helpful if you want to print out a sheet so that all formulas rather than values are visible, or it you simply want to note where [...]