MrExcel Excel Videos

Bill 'MrExcel' Jelen was Live in New York City to Judge the ModelOff Worldwide Excel Championship! And With 16 Excel Rock Stars, from around the Globe, in NYC -- and Bill having access to them all -- why not do some Podcasting On-Site! Bill says. "OK... you caught me. I was completely thrown off yesterday when Mack Wilk started using the Grouping Function in Excel. Today, I get him to explain Grouping again." Follow along with Bill and Mack Wilk in Episode #1617 as they go deeper into the elasticity of Grouping in Microsoft Excel. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/ ...This blog is...

Bill 'MrExcel' Jelen: [Almost] Live From New York City to Judge the ModelOff Worldwide Excel Championship! With 16 Excel Rock Stars, from around the Globe, in NYC -- and Bill having access to them all -- why not do some Podcasting On-Site! When pondering the word 'Elasticity' Microsoft Excel seldom seems a logical connection - that is, unless, you are Mack Wilk, from Poland. Bill states that, "I find that the only time I actually use the Group feature is as a result of using the Subtotal command." However, Today - in Episode #1616, Mack Wilk shows us how to add Elasticity to a Worksheet by using the Group feature. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on...

Bill 'MrExcel' Jelen: [Almost] Live From New York City to judge the ModelOff Worldwide Excel Championship! With 16 Excel Rock Stars, from around the Globe, in NYC - and Bill having access to them all - why not do some Podcasting On-Site! Our Dilemma: When we try to Sort with a Formula, the VLOOKUP will fail when there is a tie for the Sales Amount... But today, in Episode #1615, Martijn Reekers comes aboard The Learn Excel Podcast with a trick for getting all of the tied Values. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/ ...This blog is the video podcast companion to the book, Learn Excel...

Bill 'MrExcel' Jelen: [Almost] Live From New York City to judge the ModelOff Worldwide Excel Championship! With 16 Excel Rock Stars, from around the Globe, in NYC - and Bill having access to them all - why not do some Podcasting OnSite! Today, Multiple Criteria Testing the easy way from JP Maltais! Find the Records that meet the given criteria; in Episode #1614 JP Maltais shows us how its done. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/ ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday...

As Bill started recording the ModelOff Finalists for this week's podcast series, he'd noticed something rather unusual: one Finalist would constantly hit F2 and Escape in order to Toggle the Formula and Value in the Cell... Why? Because it takes too long to move your line of sight up to the Formula Bar and back. When Bill asked about this, it lead to a new discussion about the danger of the F1 key and how to resolve that issue. Follow along with Bill in Episode #1613 to gain a better understanding, as an Excel User, of the dangers involving the F1 Key, Scroll Lock, Cap Lock and More. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit...

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! In Today's Episode, Bill shows us trick that he picked up from Lead Judge, Professor Simon Benninga. Now, in the past, Bill has shown us how to create a 2 Variable Data Table to run scenarios. In today's Episode #1612 we will learn how to model a Penny Pitching competition, a Random Walk, and then a Data Table based on... a blank cell! Bill also looks at the New Paintbrush Icon in Excel 2013 Charts. A very full Episode today! So, get your keyboard, open Excel and Learn Excel from MrExcel and Simon Benninga! ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition...

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! Today, Bill looks at "Dates To Quarters" with Devin Rochford. Working with Years and need to bring those dates to Quarters? Follow along with Episode #1611, Devin Rochford shows us a clear-cut method to work this out painlessly. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/ ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the...

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! Today he investigates: "Does anyone really simulate the shuffling of a deck of cards with Microsoft Excel?" Yes! Today, in Episode #1610, Dan Mayoh shows us how to replicate this action - without producing any duplicates. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! Today, he gets a cool tip from finalist Martijn Reekers on how to quickly 'Copy Row Heights'. Follow along with Episode #1609 to learn how its done! ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/ ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn...