Workbook Excel Magic Tricks # 23 to 89

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Good question! I actually deleted some of the earlier videos I made over 2.5 years ago because the screen shots were very small and blurry. The videos that I deleted are:

Excel Magic Tricks 23-98

and

YouTubersLoveExcel 1-10

All the content in those videos are replicated in other videos. Before I deleted them I re-did all the videos that had content that was not duplicated somewhere else.

If you are watching the videos from number 1 to 690 in order to learn Excel, the best option is to not watch the Excel Magic Trick Series because it is just random tricks presented in no particular order. If you goal is to learn Excel it is best to watch the playlist of videos that I use in my classes at Highline Community College. The two playlists are:

Excel Basics Series
http://www.youtube.com/view_play_list?p=3FBEE51974F03CCF

then

Highline Excel Class Beg - Adv (Complete Class - 59 videos)
http://www.youtube.com/view_play_list?p=D8EEA7196D943ED5

Workbooks at same site you already had:

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

Those two playlists lay a solid foundation for all the other videos.
 
Upvote 0
Dear Mike,

I appreciate your hard work and dedecation for the benifit of the people. We have benefited ourselves with your Excel Workbooks and videos. I have studied many books but invain. When I found your web site and heard your teaching then I learnt what I was not expected in the past. I have no words to express your ability, hard work, sencerity towards the people. But can you please tell me where can I find the videos of "VLOOKUP "Shark" Week Downloadable Workbooks"?

Good question! I actually deleted some of the earlier videos I made over 2.5 years ago because the screen shots were very small and blurry. The videos that I deleted are:

Excel Magic Tricks 23-98

and

YouTubersLoveExcel 1-10

All the content in those videos are replicated in other videos. Before I deleted them I re-did all the videos that had content that was not duplicated somewhere else.

If you are watching the videos from number 1 to 690 in order to learn Excel, the best option is to not watch the Excel Magic Trick Series because it is just random tricks presented in no particular order. If you goal is to learn Excel it is best to watch the playlist of videos that I use in my classes at Highline Community College. The two playlists are:

Excel Basics Series
http://www.youtube.com/view_play_list?p=3FBEE51974F03CCF

then

Highline Excel Class Beg - Adv (Complete Class - 59 videos)
http://www.youtube.com/view_play_list?p=D8EEA7196D943ED5

Workbooks at same site you already had:

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

Those two playlists lay a solid foundation for all the other videos.
 
Upvote 0
Thanks sir for your help. I found the videos in the link you sent but if you don't mind I request to send me links of the following videos.

1 Excel & Law Excersize
2 Formula inputs, Cell Reference and Assumption.
3 ReinemerGregoryPhysicsClassHighlineCommunityCollege.xlsx
4 START Excel Workbook

Best Regards
_____________
Shafiullah

Opps, sorry, I forgot the link to the actual videos...

The videos are here:

http://www.youtube.com/playlist?list=PL856071E833250503
 
Upvote 0
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

Your request:

1) The simple Excel law examples for Jessica's Highline Computer Applications class:
http://www.youtube.com/playlist?list=PL51EAFEA2860DB108

2) Formula inputs, cell references, etc:
http://www.youtube.com/watch?v=mgtZ6o2Owjk
and
http://www.youtube.com/watch?v=_PBPU_5jTUA

3) The simple Excel Physics examples for Gregory's Highline Physics Class:
http://www.youtube.com/playlist?list=PL3FF7197CFD3667EC&feature=view_all

4) I do not know what you are looking for with this request.
 
Upvote 0
Good question! I actually deleted some of the earlier videos I made over 2.5 years ago because the screen shots were very small and blurry. The videos that I deleted are:

Excel Magic Tricks 23-98

and

YouTubersLoveExcel 1-10

All the content in those videos are replicated in other videos. Before I deleted them I re-did all the videos that had content that was not duplicated somewhere else.

If you are watching the videos from number 1 to 690 in order to learn Excel, the best option is to not watch the Excel Magic Trick Series because it is just random tricks presented in no particular order. If you goal is to learn Excel it is best to watch the playlist of videos that I use in my classes at Highline Community College. The two playlists are:

Excel Basics Series
http://www.youtube.com/view_play_list?p=3FBEE51974F03CCF

then

Highline Excel Class Beg - Adv (Complete Class - 59 videos)
http://www.youtube.com/view_play_list?p=D8EEA7196D943ED5

Workbooks at same site you already had:

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

Those two playlists lay a solid foundation for all the other videos.


Hi Girvin,

I have been watching Your videos and its most helpful for us ..just to say Thanks Im posting this.. Thanks to share your knowledge & your efforts without expecting anything from Us


One more thing is:
I couldnt find videos about Form
control so If you dont mind Can you send a link where we can learn about form control also to use in dashboards.


Thanks once again!
 
Last edited:
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,320
Messages
6,171,433
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top