MrExcel Excel Videos

As we come to the end of 2012 and our "Don't Fear The Spreadsheet" series... the ultimate question appears, as Tyler asks:"What is a Pivot Table?" Let me save you some time -- Watch This! 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. 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 others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen. Don't Fear the Spreadsheet And for more information about Pivot...

Most Popular Functions -#12 =NOW()- and -#13 =TODAY()- Over the summer of 2012 MrExcel started a series called "Most Popular [Excel] Functions"... but book writing and updating editions took the lead and our 'Most Popular Functions' series came to a pause. Today, Bill 'MrExcel' Jelen resumes the Most Popular [Excel] Functions series with the " =NOW " and " =TODAY " Functions. Follow along with Episode #1624 to see the differences between the two -- as well as a brief on " =INT(NOW( " -- and where each can be applied effectively! ...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...

*Note: I told Bill that we were on Podcast #1622...but what I should have said is "The next Podcast will be #1623". Though today's Podcast is labeled as #1622...it is actually #1623. Ok, now... Let's get to Today's Podcast! SJ needs to rearrange Data in her Spreadsheet but, the Data is delivered with Formulas so Paste Special with the Transpose Function is not going to work. In Episode #1623, Bill shows us how to use the =TRANSPOSE Formula with the Data while maintaining the integrity of the Formula Driven results. ...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...

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