A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Mike Girvin is known as ExcelIsFun over at his YouTube ExcelIsFun channel where you can find:
1100+ Excel Magic Tricks
161+ Dueling Excel Videos
2200+ Excel videos including 3 videos by his son Isaac
He’s an instructor at Highline Community College near Seattle, WA and in a 2008 interview he’s described as a great mentor and “the king of boomerangs” in the Seattle area.
As I reviewed this Excel TV episode what struck me was the number of times Mike mentioned “hard work.” For someone with the moniker ExcelIsFun, how do we get to this constant reminder of just plain grinding it out? Check out the episode and you might agree that passion is the link between fun and hard work.
Mike is also one for sharing credit for those who’ve helped him along the way. He mentions several folks from the MrExcel.com forum:
Episode 7 starts with Mike explaining that he started posting videos for his students back in 2008 and it was easy to make the videos available on YouTube. Eventually he was contacted by Mr Excel, and that lead to the Dueling Excel videos and authorship of 2 books.
You jump in, you start doing it, you get it.
Mike “ExcelIsFun” Girvin’s life philosophy
(all times refer to the full episode)
12:20 Mike clarifies Data Extraction and distinguishes that from data parsing. Data extraction through use of array formulas is a more sophisticated method of filtering far beyond native Excel’s auto-filter and advanced filter.
15:10 Jordan asks about the “worst error ever” that shows up after you’ve used an array formula and Excel stops you if you try to change part of the array.
Mike then schools us on what an array formula really is and why that error makes sense.
An array formula at its essence makes an array calculation and returns multiple items. When you have those multiple items, you can do an aggregate calculation on them which means the array formula would go into a single cell. Or, you can have the array formula deliver multiple items to multiple cells.
20:30 The discussion touched on something that both Mike and I are intensely concerned about. Too often students leave schools unprepared to work with the #1 business intelligence tool in the world: Excel.
After learning all of the statistics and analysis in school, students often discover that the tools they used in school are too expensive or complicated for a lot of businesses. But they do have Excel.
Mike teaches Basic Statistics, Accounting and Math, and it’s all in Excel.
“As a teacher, your innate duty is the prepare the student to work out in the working world.”
22:07 Dueling Podcasts with Mr Excel and how they came about
47:25 Mike demonstrates and Excel Hot Tip using an array formula to handle: 9 criteria and a mix of ANDs and Ors.
This question was first asked during the Mr Excel episode. And guess who Mike Girvin said would play Mike Girvin in an Excel movie? He said he’d probably have to play himself.
Well ok! I’ll accept that.
Are Your Formulas All Wrapped Up?
If you like this, please share. We’d also like to hear from you and invite your feedback. Is there something you’d like to see or do you have suggestions for guests? Email me: [email protected]
Photo courtesy of INWExcel
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide