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,296,726
Total Upload Views:
17,749,705
Joined:
Feb 15, 2008
Latest Activity:
2 days ago
Subscribers:
39,845
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 (1 day ago)
MrWaseequllah, xlsx means "can not have VBA code" and xlsm means "can have VBA code"
MrWaseequllah (1 day ago)
hi can anyone tell me what is the meaning of X in xlsx
ExcelIsFun (1 day ago)
joeyfrattini , No. Sorry.
joeyfrattini (1 day ago)
Do you know the best functions or tables to spot lottery number frequency or lack there of??
ExcelIsFun (1 day ago)
kmsst631 , not dumb, it is Microsoft Dumb for making Windows 7 so unfriendly. See this video for the problem with the ".zip" downloads:

Download Excel File Shows Up As Zip?
http://www.youtube.com/watch?v­=AW2hgjylplM
kmsst631 (1 day ago)
I just discovered your channel today and I'm so impressed. I wanted to download one of the workbooks to follow along, but I've never worked with .xml before. So here is my stupid question, how do I open the files I downloaded? I'm trying to open the Excel Magic Tricks 608-614 file. I'm using Office 2010.
ExcelIsFun (1 day ago)
Phreestyle1, Ctrl + Shift + ~ applies the General Number Format and is used to "clear" or "wipe away" any existing Number Format. It can be used to clear Accounting, Currency, Time, Date, Fraction, Custom, etc. Number Formatting.

I am glad that you liked that one!
ExcelIsFun (1 day ago)
Bsingraj, It depends on how the interest is calculated. Simple interest, compound interest, how interest is calculated for partial periods, etc. Interest calculations are usually defined by the contact. It shouldn't be too hard though. Probably no need for the DATE function.
Phreestyle1 (1 day ago)
Thanks Mike. This is awesome.
That ctrl-shift-tilde shortcut is amazing.
cheers,
ExcelIsFun (1 day ago)
changleeification , I am glad that the vids help!
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