Learn Excel from MrExcel Video Podcast

Learn Excel 2013 - "Power View Excel 2013": Podcast #1634

consult@MrExcel.com (Bill Jelen) — Wed, 30 Jan 2013 17:57:00 +0000

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

"Don't Fear The Spreadsheet" - Import Text File to Excel: Podcast #1622

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 20:20:54 +0000

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

Learn Excel 2013 - "Charting in Excel 2013": Podcast #1621

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 20:04:00 +0000

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

MrExcel Says "Try Excel 2013-See Excel 2013 Live! Try It Today!": Podcast #1620

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 19:55:26 +0000

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!

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 right, then 'Try It' to download a trial for up to five PC's!

Get started today!

Learn Excel from MrExcel - "OFFSET for a VLOOKUP Table": Podcast #1619

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 17:14:20 +0000

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

MrExcel At The ModelOff Championships - "Sum / Average Multiple Criteria": Podcast #1618

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 17:01:10 +0000

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, Bill is with Matijn Reekers for our last 'Almost Live from The ModelOff championships" series. In Episode #1618, Bill and Matijn are looking at Summing and Averaging Multiple Criteria in Excel.

"What Does 'Control + R' do?" Find out!"

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 to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More MrExcel At The ModelOff Championships - "More on Grouping & Elasticity": Podcast #1617

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 16:44:14 +0000

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/

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More MrExcel At The ModelOff Championships - "Elasticity in Excel?": Podcast #1616

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 15:04:57 +0000

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 next year’s competition, visit http://www.modeloff.com/modeloff-2013/

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel At The ModelOff Championships - "Automatically Ranking Content": Podcast #1615

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 14:55:19 +0000

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/

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel At The ModelOff Championships - "Multiple Criteria Testing": Podcast #1614

consult@MrExcel.com (Bill Jelen) — Mon, 07 Jan 2013 14:39:11 +0000

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!

Multiple Criteria Testing the easy way! 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/

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel At The ModelOff Championships - "F2 Esc to Toggle Formulas": Podcast #1613

consult@MrExcel.com (Bill Jelen) — Thu, 03 Jan 2013 21:37:00 +0000

As Bill started recording the ModelOff Finalists for this week's podcast series, he'd noticed something rather unusual: one Finalist would constantly hit F2 and Escape in order to Toggle the Formula and Value in the Cell...

Why? Because it takes too long to move your line of sight up to the Formula Bar and back. When Bill asked about this, it led to a new discussion about the danger of the F1 key and how to resolve that issue.

Follow along with Bill in Episode #1613 to gain a better understanding, as an Excel User, of the dangers involving the F1 Key, Scroll Lock, Cap Lock and More.

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 to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel At The ModelOff Championships - "Table from A Blank Cell": Podcast #1612

consult@MrExcel.com (Bill Jelen) — Thu, 03 Jan 2013 20:28:00 +0000

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! In Today’s Episode, Bill shows us trick that he picked up from Lead Judge, Professor Simon Benninga.

Now, in the past, Bill has shown us how to create a 2 Variable Data Table to run scenarios. In today's Episode #1612 we will learn how to model a Penny Pitching competition, a Random Walk, and then a Data Table based on... a blank cell! Bill also looks at the New Paintbrush Icon in Excel 2013 Charts.

A very full Episode today! So, get your keyboard, open Excel and Learn Excel from MrExcel and Simon Benninga!

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/

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel At The ModelOff Championships - "Dates To Quarters": Podcast #1611

consult@MrExcel.com (Bill Jelen) — Thu, 03 Jan 2013 20:12:58 +0000

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! Today, Bill looks at "Dates To Quarters" with Devin Rochford.

Working with Years and need to bring those dates to Quarters? Follow along with Episode #1611, Devin Rochford shows us a clear-cut method to work this out painlessly.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

MrExcel At The ModelOff Championships - "Shuffle A Deck of Cards": Podcast #1610

consult@MrExcel.com (Bill Jelen) — Thu, 03 Jan 2013 15:38:00 +0000

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! Today he investigates: "Does anyone really simulate the shuffling of a deck of cards with Microsoft Excel?"

Yes!

Today, in Episode #1610, Dan Mayoh shows us how to replicate this action - without producing any duplicates.

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

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel At The ModelOff Championships - "Copy Row Heights": Podcast #1609

consult@MrExcel.com (Bill Jelen) — Thu, 03 Jan 2013 15:18:00 +0000

This week, Bill is in New York City to judge the ModelOff Worldwide Excel Championship! Today, he gets a cool tip from finalist Martijn Reekers on how to quickly ‘Copy Row Heights’. Follow along with Episode #1609 to learn 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 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”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

"Don't Fear The Spreadsheet" - Getting Excel Data into A Chart: Podcast #1608

consult@MrExcel.com (Bill Jelen) — Fri, 26 Oct 2012 13:56:12 +0000

Today, Tyler is preparing for a presentation and rather than presenting her Data as strings of hard to read numbers and text she would like to create a Chart. If you've never created a Chart with Microsoft Excel then today is your lucky day! Today in Episode #1608 Bill shows us how to quickly create a Chart from our Data Set!

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Learn Excel 2010 - "Truly Unnecessary Validation": Podcast #1607

consult@MrExcel.com (Bill Jelen) — Fri, 26 Oct 2012 13:41:06 +0000

Part Two of our Validation follow-up [Episodes #1583 and #1606], Bill continues to explain and demonstrate the Validation for selecting client Data including how Duplicate are handled and why they will remain in tact in the Excel Database.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel from MrExcel - "Truly Dependent Validation": Podcast #1606

consult@MrExcel.com (Bill Jelen) — Fri, 26 Oct 2012 13:36:07 +0000

Today's episode is a follow-up from Episode #1583 [available here].

After following the instructions from that earlier Episode, a viewer could not get the Validation setup to work for him. Today in Episode #1606, Bill re-addresses the Validation setup to tweak it for this viewer to use.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

"Don't Fear The Spreadsheet" - Read Only and More: Podcast #1605

consult@MrExcel.com (Bill Jelen) — Mon, 15 Oct 2012 15:17:41 +0000

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

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Learn Excel 2010 - "Conditional Format Largest Column in Chart": Podcast #1602

consult@MrExcel.com (Bill Jelen) — Mon, 15 Oct 2012 14:29:46 +0000

Mike has a Chart and wants to use Conditional Formatting to make the Data Present more clearly. Today, in Episode #1602, Bill "MrExcel" Jelen addresses this Conditional Formatting for Chart Graphic Presentation.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

"Don't Fear The Spreadsheet" - Selecting -Or Not Selecting- Hyperlinks in Excel: Podcast #1601

consult@MrExcel.com (Bill Jelen) — Mon, 15 Oct 2012 14:18:40 +0000

How can I click inside of a Cell of a Worksheet that contains a Hyperlink without actually following that Hyperlink? I need to work within these cells... Today, in Episode #1601, Bill explains how to more easily and more manageably work with Hyperlinks in an Excel Workbook.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Learn Excel 2013 - "FilterXML and xPath": Podcast #1600

consult@MrExcel.com (Bill Jelen) — Wed, 03 Oct 2012 20:37:42 +0000

Today Bill takes a closer look at =FilterXML and xPATH, how it works and how to manipulate the retrieved data to reflect the results you are looking for. Using Weather.Yahoo.com, Bill works out a fine example of these functions in use. Follow along with Episode 1600 to see these tools in action and begin to build your ideas!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2013 - "=ENCODEURL, =WEBSERVICE, =FILTERXML": Podcast #1599

consult@MrExcel.com (Bill Jelen) — Wed, 03 Oct 2012 19:34:29 +0000

Ever wonder how you could easily strip 'illegal' characters from a URL? How about return the contents of an entire webpage to a Single Cell in Excel? Are you familiar with 'xPAth'? Today, in Episode #1599, Bill continues his review of Excel 2013 by looking at new ways to find, filter and work with Web-Based Data. Follow along with Bill as his review of Microsoft Excel 2013 continues today!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Chart Legend Gaps": Podcast #1593

consult@MrExcel.com (Bill Jelen) — Thu, 06 Sep 2012 21:03:27 +0000

Today, Bill reviews an earlier podcast that focused on moving Chart Legends to the top. However, after trying this, a viewer noticed that there was a large space between items in the Legend. Today, in Episode #1593, Bill looks at why this might be happening and how to correct it.

…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel...

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!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2013 - "The Excel App Store": Podcast #1592 Part V of V

consult@MrExcel.com (Bill Jelen) — Thu, 06 Sep 2012 14:47:19 +0000

Well… all this week Bill has been reviewing and highlighting some interesting features that are available in Excel 2013: Ease of access to utilities and web services; Ease of use for First Time Excel Users; More developed Pivot Tables and Data Manipulation; Changes in Notifications and Message Box dialog...and now Apps. Follow Bill in Episode #1592 as he demonstrates the ability to reach outside of your office to get stuff on the internet including Apps Designed for use in Excel 2013! This is a great feature to see!

This Concludes Bill's first set of Review Podcasts for Excel 2013, but there will be more in the very near future detailing even more exciting features and abilities in the New Excel as well as more in-depth looks at single features new or improved for Excel 2013!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!