Bill still has laryngitis, so @TomUrtis offers up a quick tip on how to get help on that Excel function you are entering.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Learn Excel from MrExcel podcast, episode 1766 - Quicker Help on Any Function!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
As you can hear I still have this laryngitis, I'm doing this organic Throat Coat tea for the last week, and I wondered just how much longer can go on.
So I have a short, short tip for you today.
This is from Tom Urtis, Tom is another Excel MVP, if you are on Twitter, follow him @TomUrtis, he has great Excel tips, he manages to Tweet several times a day, and he sent me this.
He saw one of my podcasts, and said there was a better way to do that.
So let's say that you are here in Excel, and you know that you need the PMT function, but you can't remember exactly what all of these rate, nper, pv ,[ fv ], and [ type ] are.
You don't have to go to the function arguments, Ctrl+A, you can just simply hover over the name of the function, right there, in the tooltip, and that will take you directly to Excel help.
A great, fast, fast way to get to help on any function.
You remember the function name, =VLOOKUP, just go to the tooltip, click on the name, and it'll take you directly to help.
What a great tip, I want to thank Tom Urtis for passing that along, and I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Learn Excel from MrExcel podcast, episode 1766 - Quicker Help on Any Function!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
As you can hear I still have this laryngitis, I'm doing this organic Throat Coat tea for the last week, and I wondered just how much longer can go on.
So I have a short, short tip for you today.
This is from Tom Urtis, Tom is another Excel MVP, if you are on Twitter, follow him @TomUrtis, he has great Excel tips, he manages to Tweet several times a day, and he sent me this.
He saw one of my podcasts, and said there was a better way to do that.
So let's say that you are here in Excel, and you know that you need the PMT function, but you can't remember exactly what all of these rate, nper, pv ,[ fv ], and [ type ] are.
You don't have to go to the function arguments, Ctrl+A, you can just simply hover over the name of the function, right there, in the tooltip, and that will take you directly to Excel help.
A great, fast, fast way to get to help on any function.
You remember the function name, =VLOOKUP, just go to the tooltip, click on the name, and it'll take you directly to help.
What a great tip, I want to thank Tom Urtis for passing that along, and I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
