excelisfun
ExcelIsFun's Channel
Alert iconSubscribed
 
 
Sign in or sign up now!
Hello, you either have JavaScript turned off or an old version of Adobe's Flash Player. Get the latest Flash player.
 
Loading...
Loading...
Loading...
Loading...
ExcelIsFun
Alert iconSubscribed
Loading...
Profile
 
Name:
Mike Girvin
Channel Views:
2,246,860
Total Upload Views:
17,479,043
Joined:
Feb 15, 2008
Latest Activity:
21 hours ago
Subscribers:
38,762
Over 1700 Excel How To Videos. This site is intended to show you many Excel Efficiency Tricks so you can work faster, you can help others at work and you can save enough time to have extra vacation!

My 1st Excel book, "Slaying Excel Dragons" is out. Check here: http://www.amazon.com/gp/pr...


FREE HELP @ Mr Excel Message Board (alternative site, not affiliated with excelisfun at YouTube):
http://www.mrexcel.com/forum

Download the Excel workbooks:
http://people.highline.edu/...

To learn Excel from beginning to end watch these two playlists of videos:
1) Excel Basics
2) Highline Excel Class

To learn how to find playlists, search or download videos watch the auto play video above.
About Me:
 
Teach Statistics, Finance, Math, Accounting, Computer Applications at Highline Community College.
Interests:
MrExcel daily Pod Casts are amazing! The Mr Excel Message Board!
Channel Comments
ExcelIsFun (3 hours ago)
nicelikeice , you are welcome!
nicelikeice (14 hours ago)
Thank you so much for providing these quality excel tutorials.
ExcelIsFun (18 hours ago)
appraisal951, are you taking about the Slaying Excel Dragon's DVD, or one the the 1700 videos at this site? If you have the Slaying Excel Dragon DVD, at the beginning of each video it says exactly what worksheet the video works on. If you are reading the Slaying Excel book, as you read each section tells you what worksheet you should be working on. If this doesn't answer your question, be more specific in your question and I will try to help.
ExcelIsFun (18 hours ago)
caekdaemon ,
Try this alternative site (not the same as excelisfun) that is set up specifically to ask Excel questions and have dialog:

mrexcel.com/forum

(mrexcel.com is not affiliate's with excelisfun at YouTube)

This site has many people who can help you get the solutions you want.
appraisal951 (19 hours ago)
Can you tell me what page the first lesson is on.
The work book has the index, set up, key B. None match the first video. Thanks
caekdaemon (21 hours ago)
Hello,

I'm having some trouble with excel, and you seem like the best person for me to ask for assistance on this. I need to create a sort of merged drop down menu and tree view, that is merged directly into the spreadsheet without the use of a userform to do it. I need to be able to simply click a little tree view like button next to say the first column, and then have that display a list of the things that come under the category. So if I had 20 BMW's from 1999, the first line would display information about all the cars inside the tree view, like average price, and overall quantity. Then I could click the button, and it would display all the cars individually bellow, showing information like fittings and the such.

Sadly, I can't remember what that is called, and I can't find it on the internet because of it :(

Thanks in advance if you know :D
ExcelIsFun (1 day ago)
tobietn81, there are many ways to do it. VLOOKUP and DGET are two ways. Here is a video:

YTLE#67: VLOOKUP & DGET functions
http://www.youtube.com/watch?v­=tmDecLpWqbA
tobietn81 (1 day ago)
Hi ExcellsFun,

I like your excel tutorials, very educational and fun to view. I've seen it before where there is a Form and when you type in the information you're looking for such as Social Security # and all the information about the person pulls up. I'm not sure if I use Vlookup or create a form or is it something else I need to do. Any direction would help. Thank you.

Tobs
ExcelIsFun (1 day ago)
agermoune , The book only covers Excel.
ExcelIsFun (1 day ago)
LewiePsMummy , you are welcome! Good luck on the test!
Alert icon
Alert icon
Alert icon
Alert icon
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more