|
|
|
Learn Excel From Mr. Excel Video Podcast
|
|
|
 |
|
Product Details
Description
Learn Excel from Bill Jelen with this daily 2 minute video podcast
People Who Liked Learn Excel From Mr. Excel Video Podcast Also Liked:
Reviews & Ratings
User Reviews Rate this title
Podcast Episodes
If this Podcast isn't working, please let us know by emailing us and we will try to fix it ASAP:
 Podcast Feed URL: |
Podcast Website:
http://mrexcel.libsyn.com/ Learn Excel 2013 - "Power View Excel 2013": Podcast #1634
consult@MrExcel.com (Bill Jelen)
Wed, Jan 30, 2013
The Preview is Ending! Free Stuff! And Something New that you may not have seen in Excel 2013."
This is Bill's First Podcast about "Power View" - a New Feature in Excel 2013! This is very powerful dashboarding tool that is new to Excel for 2013. Note that Today's podcast stretches to 9 minutes because of the cool stuff we have to talk about today!
Also, The free preview download of Office365 is about to end. This is your 'Last' chance to try for FREE. Bill said early this morning that he is seeing the news stories on the Network news showing Office 2013, so it is here.
Finally, a Giveaway! Download your FREE Trial Version of Office365 today or tomorrow and send Bill a screenshot of the download.
First Prizes: $99 one-year subscription to Office 2013. There will be four first prizes, or 18 first prizes if I have the most downloads. These will be awarded by =RAND() on Feb 2 from all entries received by midnight Jan 31
Watch today's Podcast, Episode #1634, get all of the details and go to it!
*Special Note - Bill Says: "Because the First prize is 'so squirrelly'... is it 4 or is it 18?, I will also offer that the first 100 people to send in a download image will receive a FREE copy of Chris 'Smitty' Smith's book, 'Excel 2010 Business Basics & Beyond'. If you are in the USA, you will receive the print book; Outside the USA, the PDF Version."
This is a Win-Win!! Enter now...the Free Trial ends Midnight, January 31st, 2013!!
Download File - 24.1 MB 
Watch This Podcast (Streaming Video)
"Don't Fear The Spreadsheet" - Import Text File to Excel: Podcast #1622 consult@MrExcel.com (Bill Jelen)
Mon, Jan 07, 2013Today, 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. 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.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Download File - 7.2 MB Watch This Podcast (Streaming Video)
Learn Excel 2013 - "Charting in Excel 2013": Podcast #1621 consult@MrExcel.com (Bill Jelen)
Mon, Jan 07, 2013Instead 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 for a test-drive, 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 right, then ‘Try It’ to download a trial for up to five PC’s! http://tinyurl.com/xl13preview Get started today!
Learn Excel 2013 from MrExcel Right Here on the “Learn Excel from MrExcel” blog!
Be Sure to visit MrExcel.com for All of your Microsoft Excel needs!
Download File - 20.6 MB Watch This Podcast (Streaming Video)
Learn Excel from MrExcel - "OFFSET for a VLOOKUP Table": Podcast #1619 consult@MrExcel.com (Bill Jelen)
Mon, Jan 07, 2013Today'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 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!
Download File - 14.2 MB Watch This Podcast (Streaming Video)
"Don't Fear The Spreadsheet" - Read Only and More: Podcast #1605 consult@MrExcel.com (Bill Jelen)
Mon, Oct 15, 2012Tyler has an Excel Workbook that she needs to share with her coworkers, but she doesn't want anyone to make any changes to the Workbook. What does Microsoft Excel 2010 offer to keep your Workbook intact and unchanged? Watch Episode #1605 to learn about Saving your Workbook as 'Read Only' using the File ‘Properties’ Dialog of Windows Explorer and why saving via 'Mark as Final' in Excel 2010 still leaves your work vulnerable.
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.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Download File - 13.5 MB Watch This Podcast (Streaming Video)
'Don't Fear The Spreadsheet' - Every Way To Copy a Formula Down: Podcast #1604 consult@MrExcel.com (Bill Jelen)
Mon, Oct 15, 2012Have a Manager who thinks that they have the 'ultimate' method to Copy a Formula Down a Column? Let’s find out! Today, Tyler asks Bill how to Copy a Formula Down a Column - in every Formula Copy variation that Bill can produce.
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.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Download File - 15.1 MB Watch This Podcast (Streaming Video)
"Don't Fear The Spreadsheet" - Hide or Unhide Columns: Podcast #1603 consult@MrExcel.com (Bill Jelen)
Mon, Oct 15, 2012Today, Tyler wants to Hide Columns with the option to Unhide them in the future. There are several ways to do this based on ones' need. Today, in Episode #1603, Bill shows us a few ways to Hide and Unhide Columns as well as a sure method to convey data without risking those Hidden Columns being found by the recipient!
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.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Download File - 13.7 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Why Won't My Userform Launch?": Podcast #1598 consult@MrExcel.com (Bill Jelen)
Thu, Sep 20, 2012Tony has skills. He has created a great workbook, done his VBA Coding well and has incorporated a Userform into his work to make things simple and smooth... but the Userform won't launch. Clicking the 'Launch' button on the user side produces a 'Compile Error: Expected Function or Variable'. What is causing the error - it's a single, short line of code!? Follow along with Episode #1598 to find out what the issue is and how to correct it quickly.
…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!
Download File - 6.7 MB Watch This Podcast (Streaming Video)
Don't Fear The Spreadsheet - Do These Cells Match?: Podcast #1597 consult@MrExcel.com (Bill Jelen)
Tue, Sep 18, 2012How do I compare two Ranges of Data? 'Comparison Operators' are the key. Today, in Episode #1597, Bill looks at the need to compare two Ranges of Data to be sure they are Matched - and then he shows us how to do it. Follow along to learn the basics of Comparing Data from two different sources to reconcile for the final True result.
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.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Download File - 14.3 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Many Charts but One Pivot Table": Podcast #1596 consult@MrExcel.com (Bill Jelen)
Tue, Sep 18, 2012Today, Tim wants to know if he can produce several Charts based on one Pivot Table, so that on 'Refresh' all of his Charts will be refreshed. Bill says the key is having only One Pivot Cache. Follow along with Episode #1596 as Bill shows us how to create several Charts based on this One Pivot Cache.
…This blog episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel. For more Excel 2010 knowledge, check out “Learn Excel 2007 through Excel 2010“, by Bill Jelen.
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions.
Download File - 12.4 MB Watch This Podcast (Streaming Video)
"Don't Fear The Spreadsheet" - Build A Formula: Podcast #1594 consult@MrExcel.com (Bill Jelen)
Thu, Sep 06, 2012Well, we've covered some interesting basics already in this 'Don't Fear The Spreadsheet' series, but today Tyler and Bill are really stepping out onto new ground! Today, Bill is going to show the process of creating your first Formula in Microsoft Excel! If you need to learn the way, today is a great start to get you launched!
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.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Download File - 14.7 MB Watch This Podcast (Streaming Video)
Learn Excel 2013 - "Pivot Tables": Podcast #1590 Part III of V consult@MrExcel.com (Bill Jelen)
Thu, Sep 06, 2012Wow...well we all know that Bill's favorite bit in Microsoft Excel is the Pivot Table. Today, in Episode #1590, Bill highlights the changes and increased utility of Pivot Tables in Microsoft Excel 2013! Bill Looks at 'Data Models' Power Pivot, Creating Relationships in your Pivot Table, Power View and many other time saving, efficient functions in Excel 2013.
…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!
Download File - 7.5 MB Watch This Podcast (Streaming Video)
Learn Excel 2013 - "Excel 2013 For Rookies": Podcast #1589 -Part II of V consult@MrExcel.com (Bill Jelen)
Thu, Sep 06, 2012Is Excel 2013 easier for First Time Excel Users? Heads up students, it just may be.
Today Bill moves along with his Excel 2013 Preview by addressing Users New to Excel and Excel 2013. Starting in the Microsoft Excel Preview Pane, Highlighting the availability of features now accessible via Excel. For instance, the New Feature 'Flash Fill' allows you to bypass =PROPER! There are more 'preview' panes, so that you can see what your Chart would look like in a given configuration! Too much to list so... Even if you're an Excel Veteran, you will really appreciate this week's series on Microsoft Excel 2013. So following along with Bill in Episode #1589 let’s see what's New in Excel 2013! This is Part II of V.
…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!
Download File - 16.8 MB Watch This Podcast (Streaming Video)
Learn Excel 2013 - "Sign In": Podcast #1588 Part I of V consult@MrExcel.com (Bill Jelen)
Thu, Sep 06, 2012Excel 2013? Yes - it's different! Really different. You will start out by signing in; but there is so much more to see once you are logged in. Follow along with Bill "MrExcel" Jelen in Episode #1588 as he begins a tour and review of the newest version of Microsoft Excel 2013! Also make note that Bill is currently writing and reviewing for upcoming releases specific to the New Information for Microsoft Excel 2013!
…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!
Download File - 12.4 MB Watch This Podcast (Streaming Video)
Learn Excel from MrExcel - "Calculator": Podcast #1555 consult@MrExcel.com (Bill Jelen)
Wed, Jul 18, 2012No...it's not a Learn Excel Podcast about Excel - it's about the Calculator Utility! Have you ever looked at the Toolbar selections? Did you ever wonder why Microsoft has included a 'Help' button for the Calculator? Check out Episode #1555 to learn a little bit more about Calculator from Microsoft.
“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!
Download File - 7.0 MB Watch This Podcast (Streaming Video)
Dueling Excel - "Add Zero and Dash": Podcast #1554 consult@MrExcel.com (Bill Jelen)
Tue, Jul 03, 2012Today's Duel comes from a YouTube viewer who - depending on the original configuration of digits - would like to add "0"s and " - "s based on the first digit of the Number that has been recorded. Follow along with Episode #1554 as Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen offer their means to the solution.
Dueling Excel Podcast #107…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!
Download File - 18.8 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Add 'N' Percent": Podcast #1551 consult@MrExcel.com (Bill Jelen)
Tue, Jul 03, 2012Mike has a price sheet in Excel. Column A is Product Name, Column B is Current Price and Column C is the Percentage of Increase for Column B. Bill Sets up Column D to reflect the adjusted New Price and then demonstrates how we can carry the New Prices to Column B as the New Current Price. Follow along with Bill in Episode #1551 to learn how to set this project up and how easy it is to do!
…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!
Download File - 7.4 MB Watch This Podcast (Streaming Video)
Dueling Excel - "=LOOKUP vs. @LOOKUP": Podcast #1550 consult@MrExcel.com (Bill Jelen)
Tue, Jul 03, 2012Going back to "VLOOKUP WEEK 2012" 'VLOOKUP Week 2012' Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen look at the 'LOOKUP' Function. Taking cues from an email Bill received from Dan Brinklin [co-founder/inventor of VisiCalc] Bill argues the point that "=LOOKUP" is ambiguous in Microsoft Excel when the Data Set Table is 'square'. Mike, on the other hand, thinks that "=LOOKUP" is not an ambiguous Function; that it is intuitive and dynamic. Follow along with Episode #1550 to hear the debate and decide for yourself.
Dueling Excel Podcast #106…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!
Download File - 25.4 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Print Each Record with a Macro - Part IV of IV": Podcast #1549 consult@MrExcel.com (Bill Jelen)
Mon, Jul 02, 2012Today -in the concluding edition of the 'Print Form from Database' series- Bill introduces a Visual Basic for Applications Macro that handles the work necessary for Mike to print each record in a Data Set [that is pulled from an Excel Database]. Follow along with Bill, in Episode #1549, to learn how to implement the code and find out just how easy it is!
…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!
Download File - 8.2 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Get Next Record with Offset": Podcast #1548 consult@MrExcel.com (Bill Jelen)
Mon, Jul 02, 2012Today Bill looks at using Data -from another Worksheet in the Current Workbook- using the =OFFSET Function to locate and retrieve the Data. Setting a starting point, each individual record in the Database can be printed - all without the use of a Macro. Follow along with Episode #1548 to see how it's done. This is Part III of IV.
…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!
Download File - 10.3 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Get Next Record - Part II of IV": Podcast #1547 consult@MrExcel.com (Bill Jelen)
Mon, Jul 02, 2012Today in Episode #1547, Bill creates a special section in the worksheet to set up a means to move through the individual records in the Database more effectively. Part II of IV.
…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!
Download File - 13.5 MB Watch This Podcast (Streaming Video)
Learn Excel 2010 - "Print Form from Database - Part I of IV": Podcast #1546 consult@MrExcel.com (Bill Jelen)
Mon, Jul 02, 2012From Mike: Each work day, Mike gets a data set -from a database- and from that data set he needs to print a one page report for each record in the data set. Today, in Episode #1546, Bill begins the 'Print Form from Database' series with going over the data, how it is delivered and what the expectations for utilizing the data are. This is Part I or IV.
…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!
Download File - 5.9 MB Watch This Podcast (Streaming Video)
Dueling Excel - "Count Between for Total Number": Podcast #1545 consult@MrExcel.com (Bill Jelen)
Mon, Jun 25, 2012Today, Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen are faced with taking the Data from a 'Data Dump' file and Counting - by category - to find the totals. Follow along with Mike and Bill for Formulas, Shortcuts and more!
Dueling Excel Podcast #105…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!
Download File - 22.0 MB Watch This Podcast (Streaming Video)
More Details
- LearnOutLoud.com Product ID:
L019759