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

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!

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!

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!

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!

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

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

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.

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/

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

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/

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

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.

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/

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

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.

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

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!

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!