A few weeks ago one of our members, Perrin asked; “Is there a way to force a workbook to always open on a specific sheet? I have a workbook that has a directory and I would like users to always be directed to this sheet first when opening the workbook.” The answer is yes, but [...]
April 2012
No prizes for guessing what the RANK functions do and I’ll cover them in a moment. But first you need to know that RANK.AVG and RANK.EQ are new jazzed up versions of RANK and are only available in Excel 2010 and onwards. RANK plain vanilla is still available in Excel 2010 for backward compatibility with [...]
I received an email from Stacey a few weeks ago asking: “Which formula would I use to find the initial investment amount required to have $15,000 at the end of 5 years, if my bank pays 4.75% interest, compounded monthly?” The answer is the PV Function. =PV(4.75%/12,60,0,-15000,0) =$11,834.50 Excel’s PV Function PV Function Syntax =PV(rate,nper,pmt,[fv],[type]) [...]
I can’t believe I haven’t already written a tutorial about Excel’s Go To Special feature. It is one of my favourite (a.k.a. favorite if you’re in the U.S.) closely behind VLOOKUP. If you import data from other systems you’ll invariably have to manipulate it get it the way you need before you can analyse it. [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
