Workbook Excel Magic Tricks # 23 to 89

[vaavad]

Appreciate if you could let me know, how can I download Workbooks of Excel Magic Tricks # 23 to 89 which was available earlier on the following site:

http://flightline.highline.edu/mgirvin/excelisfun.htm


Thanks and regards
Jitendra

 

[mmmarks]

What you need is power: the power to find any playlist of videos and any of the downloadable workbooks. To this end, wacth this video which shows how to search for videos or playlists of videos and how to download workbooks:

http://www.youtube.com/user/ExcelIsFun

The above link will show you how to serach for Form button and dashbaords.

Here is video about form buttons:

http://www.youtube.com/watch?v=vv0IPfSEHTQ
and
http://www.youtube.com/watch?v=Jm7zfy6TH2I

I do not have any dashboard videos, but I do have a series of videos on Dynamic Charts:

http://www.youtube.com/playlist?list=PL549569B6FB84DB5A

Thanks a lot girvin!

 

[mgirvin]

You are welcome!

 

[Shafiullah]

Dear Mike Girven,
I wish to ask about the “Highline Excel Class 7: VLOOKUP function formula 7 Examples”. In the first vlookup example there is an exact mach. In the second example there is an approximate match and I know it but in regards to the third one I don’t know why it is omitted. But the result is the same if it is an approximate match or omitted.
Regards

 

[mgirvin]

Yes, the MATCH function is programmed to assume 1 (approximate match - find position of largest value that is less than or equal to the lookup value) if you omit the 3rd argument. VLOOKUP is the same for its 4th argument.

In the future, you may want to just post your question below the video in the comment section.

 

[Shafiullah Shafi]

Appreciate if you could let me know, how can I download Workbooks of Excel Magic Tricks # 23 to 89 which was available earlier on the following site:

http://flightline.highline.edu/mgirvin/excelisfun.htm


Thanks and regards
Jitendra

Hi Sir
Sir, I don’t understand the difference between B$2*$B$8 and B$2*(1+$B$2). Please help me.
Best Regards