Simple calculator to convert APY to APR or convert APR to APY. Download this calculator here.
There are some simple things you can do in order to reduce the size of a large Excel file and speed up operation. Below are some quick and easy steps to reduce Excel file size. (Note, before you begin it's a good idea to have a backup of your file just encase something goes wrong).
1. File Type - If you're using Excel 2007 or later, ensure your file is saved as .xlsx – not in Excel 97-2003. If that doesn't cut enough into the size of your file save it as an Excel Binary Worksheet (.xlsb). I just had a file that was 12.6 MB in .xlsx cut to 6.72 MB when saved as .xlsb.
The following will need to be done on each tab:
2. Check Unused Cells – frequently "blank" cells aren't really blank and need to be deleted. You can check for the "last used cell" in your workbook by pushing Ctrl + End, this will take you to the last used cell. If that's not the end of your cells with data then you can clean up those unused cells. To do this:
a. Select the first blank column, hold down Ctrl + Shift and push the right arrow (this will highlight all columns). Then, right click and select delete. Do the same for rows; go to the first row after your data, select it, hold down Ctrl + Shift and push the down arrow. Rick click and delete.
b. You can also use the Go to Special Function. Press F5 > Special, then select "Blanks"; after all blanks are selected select "Clear All" from the Editing tool bar under the Home Ribbon.
3. Remove Formatting – Unnecessary formatting can cause a file to be unnecessarily large. Select all (Ctrl + a) and the select "Clear Formats" from the Editing tool bar under the Home Ribbon.
4. Clean Up Formulas – To many formulas will cause Excel to get bogged down, try the following:
a. Set your Excel Options so that workbook calculation is manual. File > Excel Options > Formulas > Manual.
b. Review your formulas to ensure you don't have a lot of unnecessary formulas, or formulas that are considered volatile (i.e., always recalculated, even when precedents remain unchanged). Volatile functions are Randbetween( ), Today ( ), Offset ( ), Index ( ), Info ( ) etc.
Save after each step to see if the file size is improving and ensure there is still a need to continue to improve file size.
Need to know how to add a scroll bar to an Excel chart in 2007?
It's always good to "know your options" – this is especially true when it comes to being efficient executing your day to day responsibilities. Today, we're going to explore the 'Options' button associated with the Find Function in Excel.
Most of us have probably used the Find function in Excel, the binocular icon found under the Home ribbon in Excel 2007. So now it's time to supercharge its use. These tips will increase your efficiency and effectiveness the next time you go to search for something in Excel.
First, get away from the mouse; you can use Ctrl + f to pull-up the Find function. This will save you the time of going to click on the Home ribbon, and then moving your mouse over to the binocular icon. Having to remember this simple shortcut key is well worth the time savings. Download a listing of must know shortcut keys here.
Recently, I was reminded how few people seem to be familiar with the F4 function in Excel... every time I show someone this function, they love it - it's easy, fast, and versatile! If you're not familiar with it, try it out and show a colleague - it is guaranteed to increase your Excel efficiency.
The F4 function is used for one of two tasks: 1) Cycle between absolute and relative references (in a formula) and 2) Repeat the last action. The one people seem to like the most is the repeat functionality, and really this is where the time savings will come into play once you get used to using F4.
Using F4 to repeat tasks: