MrExcel Excel Videos

Today, in Episode #1622, Tyler needs to get some Text files into Excel. Fortunately, Text files may be imported into Excel and there are options as to how they are formatted as the Data is being introduced to your Spreadsheet. Follow along with Bill today as he shows us different ways to Import Text files into Excel. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Don't Fear the Spreadsheet Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching...

Instead of following the standard marketing techniques, Bill departs the norm to show you what HE has found in Excel 2013 and tells you how you can see it LIVE yourself -- today! http://tinyurl.com/xl13preview Microsoft has improved the Charting process with Excel 2013. today, In Episode #1621, Bill shows us: - Recommended Charts - Combo Charts - New Interface - Cool Chart Styles in the paintbrush icon - Charting unsummarized data - Charting data with extra subtotals using the Filter icon Oh and a side note; while Bill had promised to show us Chart Labels from Formulas today, he ran out of time in this episode. He will tackle that one in the near future. And if you want to get a look at Excel 2013 for yourself and take it...

Bill has been writing for 4 months. What has he been writing about? Excel 2013 Of Course. So instead of following the standard marketing techniques, Bill departs the norm to show you what HE has found and tells you how you can see it LIVE yourself - today! Just by visiting http://tinyurl.com/xl13preview Today, in Episode #1620, Bill reveals the first of his 12 best, "Under-The-Radar" features in Excel 2013: Slicers on a regular Worksheet. Also, a look at the Color Schemes and Backgrounds. ***Special Note To Viewers*** And if you want to get a look for yourself, for a *Limited Time*, try out Office 2013 Home Premium! Visit http://tinyurl.com/xl13preview. Click the 'Excel logo' at the bottom, then Office 365 Home Premium on the...

Today's question comes from Ron and he would like to know, "when would I use OFFSET in conjunction with the VLOOKUP Function?" In Episode #1619, Bill "MrExcel" Jelen explains the use of OFFSET and VLOOKUP together as well as provides us a great example. ...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 Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

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! Bill is with Matijn Reekers for our last 'Almost Live from The ModelOff championships' series. Today, in Episode #1618, Bill and Matijn are looking at Summing and Averaging Multiple Criteria in 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 the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel...

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...