What is the Offset Function? You can read about the excel offset function here – there are several examples and explanations showing how the different parts of the offset function work. This page is going to show an example of a dynamic print range. Excel Offset Function
Read more →
What is the Offset Function? The offset function is a powerful Excel formula, the purpose of which is to return a single value or a range of values that is a given number of rows or columns from a specified reference (i.e. a specific cell – your
Read more →
Automatically Alternate Row Coloring in Excel Two Ways to Alternate Row Coloring in Excel If you’re using excel 2007 or 2010, probably the quickest and easiest way to get automatically alternate row coloring is by using Excel’s built-in table feature. However, there are several instances when the solution
Read more →
If you spend a lot of time on the keyboard, learning a few tricks will not only speed things up but simplify your life. All of the shortcut keys below are Excel focused. This is a free template for download, and you can easily modify it to
Read more →
Take useful Excel Add-in’s and add them to your Quick Access Toolbar. The Quick Access Toolbar is located at the top of the Ribbon as shown below. Add an Add-in to the Quick Access Toolbar and assign it it’s own unique icon in 4 easy steps. How
Read more →
Install an Excel Add-in with these 5 easy steps. Also, be sure to check out all of our free Excel Add-ins ready to be installed and help you save time. How to Install Add-ins Excel 2007 and 2010 Step 1 Save the add-in to your computer. You
Read more →
There are several instances when having a scroll bar linked to an Excel chart can come in handy – it’s a great way to make your chart dynamic and can really enhance the functionality of an Excel dashboard. On this page, we’ll describe how to add a
Read more →
This add-in converts SSN’s to a more secure format. SSN’s are converted from NNN-NN-NNNN format to XXX-XX-NNNN format. Only those numbers selected will be converted. Keep confidential data confidential and save time doing it with this add-in. Social Security Number Converter
Read more →
This add-in removes spaces at the beginning and end of individual cells in Excel. If you deal with data that needs to be cleaned up, this add-in will save a lot of time. Only spaces at the beginning and end of cells will be removed. All other
Read more →
Compare two loans instantly. Thinking about refinancing? Want to see the impact of making additional payments on your current loan? Looking to buy up? Use this loan amortization comparison spreadsheet to instantly draw a comparison between one loan and another. Three tabs are included. An Inputs tab
Read more →