Learn Excel from MrExcel Video Podcast
Learn Excel from Bill Jelen with this daily 2 minute video podcast!Education
Video Episodes:
7 Views
16:30:22 05/16/12
Learn Excel 2010 - "Remove Hidden Columns": Podcast #1539
[LESS INFO] 7 VIEWS | ADDED 16:30:22 05/16/12
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.
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
0 Views
16:17:00 05/16/12
TimeWarp with Bill Jelen: "From 1979 - VisiCalc and LOOKUP!" #1537
[LESS INFO] 0 VIEWS | ADDED 16:17:00 05/16/12
You read correctly %ndash 1979. In Bill%rsquos last installment for VLOOKUP WEEK 2012, we go back to 1979%hellipVisiCalc and the whole %rsquo20 Functions%rsquo available in that time! There were no IF statements and there was no VLOOKUP%hellipbut there was %lsquoLOOKUP%rsquo. 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 %rdquo An Enhanced E-Book for iPad by Bill %lsquoMrExcel%rsquo Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
1 Views
17:35:25 04/12/12
Dueling Excel - "ALmost Live looks for Unfinished Projects": Podcast #1536
[LESS INFO] 1 VIEWS | ADDED 17:35:25 04/12/12
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%hellipThis episode is the video podcast companion to the book, %ldquo Slaying Excel Dragons: A Beginners Guide to Conquering Excel%rsquos Frustrations and Making Excel Fun %ldquo, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]
and
%ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
21 Views
17:09:32 04/12/12
Learn Excel 2010 - "Compare 2 Lists": Podcast #1534
[LESS INFO] 21 VIEWS | ADDED 17:09:32 04/12/12
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 %rdquo An Enhanced E-Book for iPad by Bill %lsquoMrExcel%rsquo Jelen. " VLOOKUP Awesome Quick " is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
30 Views
17:47:00 04/03/12
Learn Excel - "VLookup in Plain English": Podcast #1533
[LESS INFO] 30 VIEWS | ADDED 17:47:00 04/03/12
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 %rdquo An Enhanced E-Book for iPad by Bill %lsquoMrExcel%rsquo Jelen. " VLOOKUP Awesome Quick " is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
23 Views
17:32:16 04/03/12
Dueling Excel - "Remove Duplicates If...": Podcast #1532
[LESS INFO] 23 VIEWS | ADDED 17:32:16 04/03/12
Today, in yet another %lsquoAlmost Live%rsquo Dueling Excel with Mike %lsquoExcelisFun%rsquo girvin and Bill %lsquoMrExcel%rsquo Jelen, Mike and Bill offer solutions to: %ldquoHow can I Remove Duplicates IF the first two words -before the first two commas- are the same? Now%hellipBill doesn%rsquot 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%hellipThis episode is the video podcast companion to the book, %ldquo Slaying Excel Dragons: A Beginners Guide to Conquering Excel%rsquos Frustrations and Making Excel Fun %ldquo, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]
and
%ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
11 Views
17:12:12 04/03/12
Learn Excel 2010 - "Random Chooser":Podcast #1531
[LESS INFO] 11 VIEWS | ADDED 17:12:12 04/03/12
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!
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
14 Views
17:03:21 04/03/12
Learn Excel 2010 - "Sort by Substring": Podcast #1530
[LESS INFO] 14 VIEWS | ADDED 17:03:21 04/03/12
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].
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
21 Views
19:27:31 03/25/12
Learn Excel 2010 - "DAX Calculate": Podcast #1529
[LESS INFO] 21 VIEWS | ADDED 19:27:31 03/25/12
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/
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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, %ldquo PowerPivot For The Data Analyst: Microsoft Excel 2010 %ldquo, from Bill Jelen a.k.a. MrExcel.
For all of your Microsoft Excel needs visit MrExcel.com %ndash Your One Stop for Excel Tips and Solutions.
14 Views
01:28:36 03/23/12
Learn Excel 2010 - "Percent of Production-Part I": Podcast #1528
[LESS INFO] 14 VIEWS | ADDED 01:28:36 03/23/12
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, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.
25 Views
14:08:00 03/16/12
Dueling Podcast - "Extract Values from a Text & Value Mix": Podcast #1527
[LESS INFO] 25 VIEWS | ADDED 14:08:00 03/16/12
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%hellipThis episode is the video podcast companion to the book, %ldquo Slaying Excel Dragons: A Beginners Guide to Conquering Excel%rsquos Frustrations and Making Excel Fun %ldquo, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]
and
%ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
22 Views
14:03:00 03/16/12
Learn Excel 2010 - "Excel on iPad": Podcast #1526
[LESS INFO] 22 VIEWS | ADDED 14:03:00 03/16/12
Hold on to your seat%hellip today Bill shows us how to not only view workbooks on the iPad, but also how we can make changes to those workbooks %ndash directly on the iPad! Follow along with Bill, in Episode #1526, to see how it%rsquos done!
Today%rsquos Episode is brought to you by%hellip New for 2012! %ldquo CFO EXCEL PRO %ldquo: a New, weekly e-Newsletter Publication from CFO.com featuring Bill %ldquoMrExcel%rdquo Jelen! CFO Excel Pro offers, %ldquo%hellip clear, concise illustrated articles written by Microsoft MVP Bill %ldquoMr. Excel%rdquo Jelen that provide readers with step-by-step solutions to nagging %ldquoreal-world%rdquo Excel problems.
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today !
21 Views
21:27:19 03/12/12
Dueling Excel - "100th Episode!": Podcast #1525
[LESS INFO] 21 VIEWS | ADDED 21:27:19 03/12/12
It%rsquos Duel 100 with Mike %ldquoExcelisFun%rdquo Girvin and Bill %ldquoMrExcel%rdquo Jelen! Revisting the topic of their first-ever Dueling Podcast, Mike and Bill up the ante and make the task increasingly difficult in theory%hellipbut 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%hellipThis episode is the video podcast companion to the book, %ldquo Slaying Excel Dragons: A Beginners Guide to Conquering Excel%rsquos Frustrations and Making Excel Fun %ldquo, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]
and
%ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
30 Views
16:36:00 03/02/12
Dueling Excel - "Record Fill Down- Part Due(l)x:"Podcast #1524
[LESS INFO] 30 VIEWS | ADDED 16:36:00 03/02/12
Always love this time of year %ndash when Microsoft is hosting the MVP Summit %ndash because it means that Bill %ldquoMrExcel%rdquo Jelen gets to go out to Seattle, Washington and hook up with none other than Mike %ldquoExcelisFun%rdquo 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: %rsquoUsing The Macro Recorder to Fill Down%rsquo a column. See how both Mike and Bill address this topic %ndash and then stay tuned for the %lsquoOuttake%rsquo that follows the regular episode.
Dueling Excel Podcast #99%hellipThis episode is the video podcast companion to the book, %ldquo Slaying Excel Dragons: A Beginners Guide to Conquering Excel%rsquos Frustrations and Making Excel Fun %ldquo, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]
and
%ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
24 Views
17:16:00 02/29/12
Learn Excel 2010 - "Comparative Histogram Part II": Podcast #1523
[LESS INFO] 24 VIEWS | ADDED 17:16:00 02/29/12
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.
%hellipThis episode is the video podcast companion to the book, %ldquo Charts And Graphs: Microsoft Excel 2010 %ldquo, by Bill Jelen a.k.a. MrExcel.
For more Excel 2010 knowledge, check out %ldquo Excel 2010 In Depth %ldquo, by Bill Jelen a.k.a. MrExcel.
For all of your Microsoft Excel needs visit MrExcel.com %ndash Your One Stop for Excel Tips and Solutions.
28 Views
18:09:00 02/27/12
Learn Excel 2010 - "Comparative Histogram": Podcast #1522
[LESS INFO] 28 VIEWS | ADDED 18:09:00 02/27/12
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 .
%hellipThis episode is the video podcast companion to the book, %ldquoLearn Excel 2007 through Excel 2010 from MrExcel%rdquo . 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%rsquos book!
%ldquoThe Learn Excel from MrExcel Podcast Series%rdquo
MrExcel.com %mdash Your One Stop for Excel Tips and Solutions. Visit us today!
05/03/11