Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean

See how to:
1. Calculate Compounding Rate/Geometric Mean with the new RRI function in Excel 2013

[excelisfun]

Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean 

[ExcelVbaIsFun]

Wow! I've got to get Excel 2013. Thanks for the RRI tutorial. I'm drooling over how you manipulate investment figures. Brilliant! Dan

[MySpreadsheetLab]

Great video Mike. I didn't know about the RRI function.

[k.scottroberts.r.a]

Thanks for teaching this function. 2013 Excel is a super program. And special thanks to you for such a great video selection. As an architect I use Excel all the time, thanks to your instructions, you've saved me countless hours in time. Big Thanks! Scott 

[sndp]

Hey finally i got a simple formula which can serve it very easily, without using big vba code. here is what i want to share you all, just creat a name range with any name say file as name and in refer to field put =files(). now in any cell just write=index(file, row()) press enter and drag it down, voila your done.

[ExploringExcelAmey]

Nice financial function. ..wasnt aware about this function. ...

[ahmadsaker]

Hello and thank you very much, iam trying to design invoice in excel can I transfer data from invoice sheet to the store sheet or customer sheet, the items will decrease from store sheet and the balance of invoice will increase in the customer sheet can I do that with out using vba because itis so hard

[sndp]

Hi, Mike is there any formula in excel which can list the name of all the files of a directory?

[elizabethwright]

Hi,   I've been devouring your videos.  Thank you.  I'm creating a workbook for our Church that maintains a list of tasks for multiple users.  I would like to add a main page where a task owner can select their name from a drop down list and then dynamically populate a table below it with all of their tasks that are due.  Then from that table if they click on a name, populate another table with the persons address and phone number.   Can you suggest one of your videos that will show me how to do this.  I'm using vlookups etc. to poulate a to do list but I want them to be able to look up just their current to dos with all the information they need to complete the task.  If you can direct me I would appreicate it.