Learn Excel from MrExcel Video Podcast
By Bill Jelen
To listen to an audio podcast, mouse over the title and click Play. Open iTunes to download and subscribe to podcasts.
Podcast Description
Learn Excel from Bill Jelen with this daily 2 minute video podcast.
| Name | Description | Released | Price | ||
|---|---|---|---|---|---|
| 1 | CleanVideoLearn Excel 2010 - "Remove Hidden Columns": Podcast #1539 | Your workbook started off with hidden columns...but you got it back, the columns are no longer hidden and that data has been compromised. How can you keep this from happening in the future? Follow along with Episode #1539 as Bill offers solutions to this issue. …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 5/16/12 | Free | View In iTunes |
| 2 | CleanVideoTimeWarp with Bill Jelen: "From 1979 - VisiCalc and LOOKUP!" #1537 | You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back to 1979…VisiCalc and the whole ’20 Functions’ available in that time! There were no IF statements and there was no VLOOKUP…but there was ‘LOOKUP’. Follow along and see where VLOOKUP began! For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots! …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 5/16/12 | Free | View In iTunes |
| 3 | CleanVideoDueling Excel - "ALmost Live looks for Unfinished Projects": Podcast #1536 | MZI1A at YouTube has a column of completed projects; she also needs to show a column of projects that are incomplete.Today in Episode #1536, Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen set out to solve the issue and show the column of incomplete projects. Dueling Excel Podcast #103…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and “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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 4/12/12 | Free | View In iTunes |
| 4 | CleanVideoLearn Excel 2010 - "Compare 2 Lists": Podcast #1534 | In the spirit of "VLOOKUP WEEK 2012" [march 25th - March 31st, 2012], Bill centers on VLookup again today. In theory, I sent my workbook to my manager. I have received the workbook back from my manager and now I need compare the data [the original data with the new data] to find out what was deleted, what was added and what was changed. Today, in Episode #1534, Bill 'MrExcel' Jelen shows us how to work with VLOOKUP to find the answers to our questions. For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots! …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 4/12/12 | Free | View In iTunes |
| 5 | CleanVideoLearn Excel - "VLookup in Plain English": Podcast #1533 | Bill starts from the beginning; why to use a VLOOKUP, when to use a VLOOKUP and how to Use a VLOOKUP. If you are ready to unravel the mystery of VLOOKUP, follow along with Episode #1533 as Bill Starts off VLOOKUP WEEK 2012 with a comprehensive how-to. For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots! …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 4/3/12 | Free | View In iTunes |
| 6 | CleanVideoDueling Excel - "Remove Duplicates If...": Podcast #1532 | Today, in yet another ‘Almost Live’ Dueling Excel with Mike ‘ExcelisFun’ girvin and Bill ‘MrExcel’ Jelen, Mike and Bill offer solutions to: “How can I Remove Duplicates IF the first two words -before the first two commas- are the same? Now…Bill doesn’t believe that this task can be completed with a Formula and Mike says that it can. What is your synopsis? Following along with Episode #1532 to see how to remove those dupes. Dueling Excel Podcast #102…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and “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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 4/3/12 | Free | View In iTunes |
| 7 | CleanVideoLearn Excel 2010 - "Random Chooser":Podcast #1531 | MS Access MVP Crystal Long has a Random name selection workbook that was originally developed in MS Access. Today, in Episode #1531, Bill demonstrates the 'Awesome!' Random Selection workbook that Crystal has developed. Note that the very same workbook is available for download! See the Podcast for details! …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 4/3/12 | Free | View In iTunes |
| 8 | CleanVideoLearn Excel 2010 - "Sort by Substring": Podcast #1530 | Danny wants to enter a value and have all of the like values sort to the top of the list.One way to do this is to use the Filter in Excel 2010, but there are other ways to accomplish this task - and today, in Episode #1530, Bill shows us other methods...but maybe you have an awesome method to share!? To contact Bill with your method to accomplish this task you may email MrExcel [bill "at" mrexcel.com]. …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 4/3/12 | Free | View In iTunes |
| 9 | CleanVideoLearn Excel 2010 - "DAX Calculate": Podcast #1529 | Today's Learn Excel from MrExcel Podcast is Part 2 of the "Percent of Production" Podcast [Episode #1528] from yesterday. So today, in Episode #1529, Bill introduces us to Microsoft PowerPivot combined with Microsoft Excel. Watch how the process becomes more focused toward the objective of finding the percentage of production as Bill demonstrates very practical, real-world uses of the PowerPivot software NOTE: Microsoft PowerPivot is available as a Free Download from Microsoft via: http://www.powerpivot.com/ …This episode 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 be sure to check out the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions. | 3/25/12 | Free | View In iTunes |
| 10 | CleanVideoLearn Excel 2010 - "Percent of Production-Part I": Podcast #1528 | We are looking for the amount of scrap compared to good units - but as a percentage of production and not simply a numberical value. Using a Pivot Table in Microsoft Excel in Episode #1528, Bill produces his first solution to the query. [Be sure to tune in for tomorrow's "Percent of Production - Part II" when Bill employs the use of Microsoft PowerPivot and Microsoft Excel to solve this challenge.] ...This episode is the video podcast companion to the book, "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen and 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! For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions. | 3/22/12 | Free | View In iTunes |
| 11 | CleanVideoDueling Podcast - "Extract Values from a Text & Value Mix": Podcast #1527 | Bill has decided that Mike is going to do all of the work today. In 'Almost Live' Episode #1527, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen work out very interesting solutions for separating numbers and text to extract values...I think...? Follow along with Mike and Bill as they produce solutions to whatever is really happening in this Episode. Enjoy! Dueling Excel Podcast #101…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and “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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 3/16/12 | Free | View In iTunes |
| 12 | CleanVideoLearn Excel 2010 - "Excel on iPad": Podcast #1526 | Hold on to your seat… today Bill shows us how to not only view workbooks on the iPad, but also how we can make changes to those workbooks – directly on the iPad! Follow along with Bill, in Episode #1526, to see how it’s done! Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems. “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 3/16/12 | Free | View In iTunes |
| 13 | CleanVideoDueling Excel - "100th Episode!": Podcast #1525 | It’s Duel 100 with Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen! Revisting the topic of their first-ever Dueling Podcast, Mike and Bill up the ante and make the task increasingly difficult in theory…but they manage to pull it off without a hitch. Follow along with Dueling Episode #100 [Learn Excel from MrExcel Podcast #1525] as Mike and Bill remake Excel-lent History! Dueling Excel Podcast #100…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and “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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 3/12/12 | Free | View In iTunes |
| 14 | CleanVideoDueling Excel - "Record Fill Down- Part Due(l)x:"Podcast #1524 | Always love this time of year – when Microsoft is hosting the MVP Summit – because it means that Bill “MrExcel” Jelen gets to go out to Seattle, Washington and hook up with none other than Mike “ExcelisFun” Girvin to do Dueling Excel together in the same room! Today, in Episode #1524, Mike and Bill look at a topic that Bill previously introduced: ’Using The Macro Recorder to Fill Down’ a column. See how both Mike and Bill address this topic – and then stay tuned for the ‘Outtake’ that follows the regular episode. Dueling Excel Podcast #99…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and “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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 3/2/12 | Free | View In iTunes |
| 15 | CleanVideoLearn Excel 2010 - "Comparative Histogram Part II": Podcast #1523 | In Episode #1522, Bill showed us how to set up a Comparative Histogram Chart. Today, in Episode #1523, Bill shows us alternative ways to set up a visual Comparative Histogram without using a Chart, thus giving us more options to represent our data. …This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel. For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions. | 2/29/12 | Free | View In iTunes |
| 16 | CleanVideoLearn Excel 2010 - "Comparative Histogram": Podcast #1522 | JB asks, "How can I create a Comparative Histogram?" Today, in Episode #1522, Bill shows us how to set up our Data, create Data Lables, and Formatting for creating a Comparative Histogram Chart. Easy-XL From MrExcel adds over 50 time saving data analysis and manipulation features to Excel. Easy-XL enables casual Excel users to summarize, pivot, join, merge, match, query, categorize, combine, split, slice and dice data like a pro. The free version of Easy-XL features all of the Workbook commands while the paid-for version includes all of the Workbook, Worksheet, Row, Column and Cell commands. You can download a Free 30 day trial version. …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com— Your One Stop for Excel Tips and Solutions. Visit us today! | 2/27/12 | Free | View In iTunes |
| 17 | CleanVideoLearn Excel 2010 - "Paste Values with VBA": Podcast #1521 | Bill looks at pasting Values today, in Episode #1521. Using one line of VBA code, Bill shows us how to convert Formulas to Values. Learn how to quickly - and Easily - modify your recorded macro [using the Macro Recorder] to Paste Values with one click. ...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions. “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 2/24/12 | Free | View In iTunes |
| 18 | CleanVideoLearn Excel 2010 - "Separate Dates from Text": Podcast #1520 | Today's episode is a reversal of Episode #1517 [click link to view]. In Episode #1520, Bill looks at two ways to solve the problem where you have text and a date in the same cell and the goal is to isolate only the date. [*Note - Bill mentions Episode #1518 in this podcast, but he is actually referring to Episode #1517*] …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 2/23/12 | Free | View In iTunes |
| 19 | CleanVideoLearn Excel 2010 - "Record Fill Down": Podcast #1519 | Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It isn’t as straight-forward as you might think, but it can be done with only the macro recorder. Follow along with Bill in Episode #1519 to learn how. ...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions. “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 2/23/12 | Free | View In iTunes |
| 20 | CleanVideoLearn Excel 2010 - "MAXIF": Podcast #1518 | With a list of Products and a list of Dates, Bill's mission is to find the last order date for each product in the Dataset.Learn the use of MAXIF, changing Number Formats, and more in Episode #1518. [Previously slated as Episode #1516] Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems. “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 2/21/12 | Free | View In iTunes |
| 21 | CleanVideoLearn Excel 2010 - "Words With Dates": Podcast #1517 | From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to learn how to add Custom text to your Date Field while retaining the actual Date. …This episode 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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 2/21/12 | Free | View In iTunes |
| 22 | CleanVideoDueling Excel - "Any of These in Those?": Podcast #1516 | Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures exist in both columns, by row. Bill goes the VBA Route and Mike chooses to use an Amazing Array Formula to get the query solved. Watch Episode #1516 to learn a wide variety of uses for Excel VBA and Excel Functions. Dueling Excel Podcast #98…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and “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! “The Learn Excel from MrExcel Podcast Series” MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! | 2/17/12 | Free | View In iTunes |
| Total: 22 Episodes |
Customer Reviews
Perfect length and style
Excellent. Thank you.
Viewers also subscribed to
- Methods In Excel
- Methods In Excel
- View In iTunes
- OnHome&Office
- OnPodcast Network
- View In iTunes
![iPhone & iPad Live [Video]](http://a4.mzstatic.com/us/r30/Podcasts/36/15/14/ps.nqmcmpka.100x100-75.jpg)
