Home  /  Podcast Directory  /  Education & Reference  /  Learn Excel from MrExcel Video Podcast


Last update: 2013-01-30

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

2013-01-30
Length: 9s

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

x

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


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

2013-01-07

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!

x

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


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

2013-01-07
Length: 1s

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!

x

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


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

2013-01-07
Length: 5s

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!

x

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


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

2013-01-07
Length: 3s

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!

x

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


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

2013-01-07
Length: 3s

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!

x

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


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

2013-01-07
Length: 6s

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!

x

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


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

2013-01-07
Length: 5s

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/

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

x

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


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

2013-01-07
Length: 3s

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!

x

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


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

2013-01-07
Length: 3s

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!

x

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


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

2013-01-03
Length: 5s

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

x

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


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

2013-01-03
Length: 5s

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!

x

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


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

2013-01-03
Length: 3s

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!

x

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


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

2013-01-03
Length: 4s

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!

x

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


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

2013-01-03
Length: 2s

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!

x

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


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

2012-10-26
Length: 5s

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!

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!

x

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


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

2012-10-26
Length: 2s

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.

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

x

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


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

2012-10-26
Length: 5s

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.

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

x

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


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

2012-10-15
Length: 4s

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.

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!

x

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


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

2012-10-15
Length: 3s

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.

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

x

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


'Don't Fear The Spreadsheet' - Every Way To Copy a Formula Down: Podcast #1604

2012-10-15
Length: 4s

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

x

Share: 'Don't Fear The Spreadsheet' - Every Way To Copy a Formula Down: Podcast #1604


"Don't Fear The Spreadsheet" - Hide or Unhide Columns: Podcast #1603

2012-10-15
Length: 4s

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

x

Share: "Don't Fear The Spreadsheet" - Hide or Unhide Columns: Podcast #1603


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

2012-10-15
Length: 3s

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.

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!

x

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


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

2012-10-03
Length: 3s

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!

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

x

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


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

2012-10-03
Length: 6s

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!

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

x

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


Learn Excel 2010 - "Why Won't My Userform Launch?": Podcast #1598

2012-09-20
Length: 2s

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

x

Share: Learn Excel 2010 - "Why Won't My Userform Launch?": Podcast #1598


Learn Excel 2010 - "Many Charts but One Pivot Table": Podcast #1596

2012-09-18
Length: 3s

Today, 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.

x

Share: Learn Excel 2010 - "Many Charts but One Pivot Table": Podcast #1596


Don't Fear The Spreadsheet - Do These Cells Match?: Podcast #1597

2012-09-18
Length: 5s

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

x

Share: Don't Fear The Spreadsheet - Do These Cells Match?: Podcast #1597


"Don't Fear The Spreadsheet" - Build A Formula: Podcast #1594

2012-09-06
Length: 6s

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

x

Share: "Don't Fear The Spreadsheet" - Build A Formula: Podcast #1594


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

2012-09-06
Length: 2s

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!

x

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


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

2012-09-06
Length: 2s

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!

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

x

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


Learn Excel 2013 - "Excel With Attitude!": Podcast #1591 Part IV of V

2012-09-06
Length: 4s

It's Thursday and Bill is reviewing the week thus far and he has an interesting discovery - Excel Messagebox messages are sporting 'Attitude'. Take a look at Episode #1591, churn your ideas and then enter the contest! [Bill talks about the contest in the Podcast] This is Part IV of V in the Excel 2013 Review Series.

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

x

Share: Learn Excel 2013 - "Excel With Attitude!": Podcast #1591 Part IV of V


Learn Excel 2013 - "Pivot Tables": Podcast #1590 Part III of V

2012-09-06
Length: 2s

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

x

Share: Learn Excel 2013 - "Pivot Tables": Podcast #1590 Part III of V


Learn Excel 2013 - "Excel 2013 For Rookies": Podcast #1589 -Part II of V

2012-09-06
Length: 5s

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

x

Share: Learn Excel 2013 - "Excel 2013 For Rookies": Podcast #1589 -Part II of V


Learn Excel 2013 - "Sign In": Podcast #1588 Part I of V

2012-09-06
Length: 5s

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

x

Share: Learn Excel 2013 - "Sign In": Podcast #1588 Part I of V


Learn Excel from MrExcel - "Calculator": Podcast #1555

2012-07-18
Length: 2s

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

x

Share: Learn Excel from MrExcel - "Calculator": Podcast #1555


Dueling Excel - "Add Zero and Dash": Podcast #1554

2012-07-03
Length: 7s

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

x

Share: Dueling Excel - "Add Zero and Dash": Podcast #1554


Learn Excel 2010 - "Add 'N' Percent": Podcast #1551

2012-07-03
Length: 2s

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

x

Share: Learn Excel 2010 - "Add 'N' Percent": Podcast #1551


Dueling Excel - "=LOOKUP vs. @LOOKUP": Podcast #1550

2012-07-02
Length: 9s

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

x

Share: Dueling Excel - "=LOOKUP vs. @LOOKUP": Podcast #1550


Learn Excel 2010 - "Print Each Record with a Macro - Part IV of IV": Podcast #1549

2012-07-02
Length: 2s

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

x

Share: Learn Excel 2010 - "Print Each Record with a Macro - Part IV of IV": Podcast #1549


Learn Excel 2010 - "Get Next Record with Offset": Podcast #1548

2012-07-02
Length: 3s

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

x

Share: Learn Excel 2010 - "Get Next Record with Offset": Podcast #1548


Learn Excel 2010 - "Get Next Record - Part II of IV": Podcast #1547

2012-07-02
Length: 3s

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

x

Share: Learn Excel 2010 - "Get Next Record - Part II of IV": Podcast #1547


Learn Excel 2010 - "Print Form from Database - Part I of IV": Podcast #1546

2012-07-02
Length: 2s

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

x

Share: Learn Excel 2010 - "Print Form from Database - Part I of IV": Podcast #1546


Dueling Excel - "Count Between for Total Number": Podcast #1545

2012-06-25
Length: 8s

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

x

Share: Dueling Excel - "Count Between for Total Number": Podcast #1545


Learn Excel 2010 - "Sakai Grade Book Percentage Score To Letter Grade - Part IV of IV": Podcast #1544

2012-06-25
Length: 3s

Today, in the last installment of the Sakai Grade Book series, Bill looks at converting the Percentage Score in the Grade Book to a Letter Grade. Using a baseline, a Named Range and a Formula – which Bill shares with us today – your Dynamic Grade Book Project will be complete. Follow along with Bill in Episode #1544 to learn how to implement the finishing touches!

To learn more about the Sakai System and what it offers, you may wish to visit the Sakai Wiki Site by clicking the following Link: Sakai Wiki Page.

Formulas for the ‘Grade Book Application‘ that Bill Jelen has created are from the book, “Excel For Teachers” published by Holy Macro! Books. Learn more about the book “Excel For Teachers” by clicking here to go to the “Excel For Teachers” information page.

x

Share: Learn Excel 2010 - "Sakai Grade Book Percentage Score To Letter Grade - Part IV of IV": Podcast #1544


Learn Excel 2010 - "Sakai Grade Book Point Extraction - Part II of IV": Podcast #1542

2012-06-25
Length: 4s

An alternate method to extract the Heading Values of your Sakai Grade Book - a method that does not use VBA Macros. Follow along with Bill Jelen as he provides a Formula solution to extracting those bracketed Values in Episode #1542.  ‘Livening’ up your Grade Book. This is Part II of IV.

To learn more about the Sakai System and what it offers, you may wish to visit the Sakai Wiki Site by clicking the following Link: Sakai Wiki Page.

Formulas for the ‘Grade Book Application‘ that Bill Jelen has created are from the book, “Excel For Teachers” published by Holy Macro! Books. Learn more about the book “Excel For Teachers” by clicking here to go to the “Excel For Teachers” information page.

x

Share: Learn Excel 2010 - "Sakai Grade Book Point Extraction - Part II of IV": Podcast #1542


Dueling Excel - "100th Episode!": Podcast #1525

2012-03-12
Length: 8s

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!

x

Share: Dueling Excel - "100th Episode!": Podcast #1525


Dueling Excel - "Record Fill Down- Part Due(l)x:"Podcast #1524

2012-03-02
Length: 5s

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!

x

Share: Dueling Excel - "Record Fill Down- Part Due(l)x:"Podcast #1524


Learn Excel 2010 - "Comparative Histogram Part II": Podcast #1523

2012-02-29
Length: 2s

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.

x

Share: Learn Excel 2010 - "Comparative Histogram Part II": Podcast #1523


Learn Excel 2010 - "Comparative Histogram": Podcast #1522

2012-02-27
Length: 2s

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!

x

Share: Learn Excel 2010 - "Comparative Histogram": Podcast #1522


Learn Excel 2010 - "Paste Values with VBA": Podcast #1521

2012-02-24
Length: 2s

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!

x

Share: Learn Excel 2010 - "Paste Values with VBA": Podcast #1521


Learn Excel 2010 - "Separate Dates from Text": Podcast #1520

2012-02-23
Length: 2s

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!

x

Share: Learn Excel 2010 - "Separate Dates from Text": Podcast #1520


Learn Excel 2010 - "Record Fill Down": Podcast #1519

2012-02-23
Length: 4s

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!

x

Share: Learn Excel 2010 - "Record Fill Down": Podcast #1519


Learn Excel 2010 - "MAXIF": Podcast #1518

2012-02-21
Length: 2s

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!

x

Share: Learn Excel 2010 - "MAXIF": Podcast #1518


Learn Excel 2010 - "Words With Dates": Podcast #1517

2012-02-21
Length: 2s

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!

x

Share: Learn Excel 2010 - "Words With Dates": Podcast #1517


Dueling Excel - "Any of These in Those?": Podcast #1516

2012-02-17
Length: 8s

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!

x

Share: Dueling Excel - "Any of These in Those?": Podcast #1516


Dueling Excel - "Quarters": Podcast #1515

2012-02-10
Length: 5s

Today in Episode #1515 we have a series of Dates. We want to show quarters for the year 2012. Bill 'MrExcel' Jelen goes Old School on this one while Mike 'ExcelisFun' Girvin goes for a more Functionally 'stream-lined' approach. Mike and Bill look at the =CEILING, =MONTH, VLOOKUP functions and more.

Dueling Excel Podcast #97…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!

x

Share: Dueling Excel - "Quarters": Podcast #1515


Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514

2012-01-30
Length: 3s

VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the entry and 'Stop Speaking Cells' -on the Quick Access Toobar- is not making it stop. Why? Follow along with Bill in Episode #1514 to learn why the cells won't stop speaking and then learn how to turn off the 'Speak On Enter' function.

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!

x

Share: Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514


Dueling Excel - "Total All Lookups": Podcast #1513

2012-01-27
Length: 8s

Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn more about the LOOKUP function, how to use SUM and SUMPRODUCT and Array Formulas in Episode #1513.

Dueling Excel Podcast #95…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!

x

Share: Dueling Excel - "Total All Lookups": Podcast #1513


Learn Excel 2010 - " Move Entire Rows ": Podcast #1512

2012-01-26
Length: 2s

Charlie -who admits he is relatively new to Microsoft Excel-  needs to rearrange the rows of his spreadsheet. Today, in Episode #1512, Bill shows us several methods to accomplish this task.

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!

x

Share: Learn Excel 2010 - " Move Entire Rows ": Podcast #1512


Learn Excel 2010 - "Chart An Extra Series": Podcast #1510

2012-01-23
Length: 1s

Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the Chart is giving three (3) Series instead of two (2). With a few simple clicks in Episode #1510, Bill "MrExcel" Jelen solves the additional series issue.

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 - Visit Us Today!

x

Share: Learn Excel 2010 - "Chart An Extra Series": Podcast #1510


Dueling Excel - "Conditional Format +/- 15%": Podcast #1509

2012-01-20
Length: 7s

Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by 15%"

Initially, it appears that there is only one way to accomplish this task, but Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen find another way to tackle and solve this challenge. Follow along with Episode #1509 to see how its done!

Dueling Excel Podcast #95…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!

x

Share: Dueling Excel - "Conditional Format +/- 15%": Podcast #1509


Learn Excel 2010 - "Count Between A Range": Podcast #1508

2012-01-19
Length: 2s

The Question: "I have a =COUNTIF to count values less than 10 and another to count values less than 20; but how do I count the values that fall between 10 and 20?" In 2007 and newer, there is a New Function called '=COUNTIFS". Follow along with Bill in Episode #1508 to learn how to solve this question - even if you are using Excel 2003 or earlier!

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

x

Share: Learn Excel 2010 - "Count Between A Range": Podcast #1508


Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507

2012-01-12
Length: 3s

Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Deviation?" =RANDBETWEEN won't do it, but a clever use of =RAND and =NORM.INV ["Normal Inverse"] will do it. In Episode #1507, Bill shows us how to generate Random Numbers with this method.

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

x

Share: Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507


Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506

2012-01-11
Length: 3s

Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the " N-NN-NNNN " Format to Dates, by Excel. Today, how to prevent this from happening is the subject Bill works with in Episode #1506.

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

x

Share: Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506


Learn Excel 2010 - "Next Invoice Number": Podcast #1505

2012-01-10
Length: 6s

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button.

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

x

Share: Learn Excel 2010 - "Next Invoice Number": Podcast #1505


Learn Excel 2010 - "Saving Form to Database": Podcast #1504

2012-01-09
Length: 1s

John from New Zealand offers an improvement to Thursday's podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine!

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

x

Share: Learn Excel 2010 - "Saving Form to Database": Podcast #1504


Learn Excel 2010 - "Saving Form to Database": Podcast #1503

2012-01-05
Length: 4s

Today, Bill shows off some of the truly dynamic functionability of Microsoft Excel. Oz wants to use a worksheet as a data entry form and then post the record to a database. In Episode #1503 - the first of a two part tutorial series - Bill shows us how to use some VBA to make this happen.

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

x

Share: Learn Excel 2010 - "Saving Form to Database": Podcast #1503


Learn Excel 2010 - "Running Total AutoFill": Podcast #1502

2012-01-04
Length: 2s

Mally wants a simple Spreadsheet - Two (2) Columns; she asks how to enter a Value in Column A and have the Running Total over in Column B automatically fill down. Episode #1502 shows you how to use the new Table functionality to solve this. Also, in reference to the Learn Excel from MrExcel Podcast Episode #1482, Bill readdresses a few more Table Topics, such as: 'Control-T' to define your Data Set as a Table or going to 'File > Options > Formulas > 'Working With Formulas' area and deselecting "Use Table Names in Formulas"

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

x

Share: Learn Excel 2010 - "Running Total AutoFill": Podcast #1502


Learn Excel 2010 - "Will The Globetrotters Lose?": Podcast #1501

2012-01-03
Length: 2s

"I am going out on a limb to predict that the four-point shot will lead to an accidental Washington Generals win this season", Bill said. Episode #1501 shows off a couple of dueling Win/Loss sparklines with my prediction. I don't know when, but sometime soon, the Harlem Globetrotters will fall to the Washington Generals.

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

x

Share: Learn Excel 2010 - "Will The Globetrotters Lose?": Podcast #1501


Learn Excel 2010 - "Column B is now Column 2?": Podcast #1467

2011-11-10
Length: 1m 1s

Every few months Bill receives a call or an email from someone stating that their Formulas are 'changed' and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? "R1C1" is the answer. Follow …

x

Share: Learn Excel 2010 - "Column B is now Column 2?": Podcast #1467


Learn Excel 2010 - "Embed a PDF in Excel": Podcast #1466

2011-11-09
Length: 1m 26s

Can you embed a PDF in a worksheet? Yes - Using the 'Insert Object' Menu Tab. Follow along with Bill, in Episode #1466, as he shows us how to embed a PDF in our Worksheet.

Share this episode

x

Share: Learn Excel 2010 - "Embed a PDF in Excel": Podcast #1466


Learn Excel 2010 - "Remove Spaces with VBA": Podcast #1465

2011-11-08
Length: 2m 24s

Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the worksheet; the spaces in the middle remain after running the Macro. Bill shows us, In Episode #1465, how to solve thi…

x

Share: Learn Excel 2010 - "Remove Spaces with VBA": Podcast #1465


Dueling Excel - "Keep The Last Duplicate": Podcast #1464

2011-11-07
Length: 5m 50s

Tony needs to keep the last duplicate record and throw out the earlier ones. In Episode #1464 Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen demonstrate competing methods to get this issue solved.…

x

Share: Dueling Excel - "Keep The Last Duplicate": Podcast #1464


Learn Excel 2010 - "Left 26 Even if Only 10": Podcast #1463

2011-11-04
Length: 2m 2s

Shrikant needs to join the left 26 characters of column A with column B. But...even if A2 only has 10 characters, he needs it to fill with spaces so that the value from B starts in character position 27 each and every time.…

x

Share: Learn Excel 2010 - "Left 26 Even if Only 10": Podcast #1463


Learn Excel 2010 - "Word Count from Word": Podcast #1462

2011-11-03
Length: 1m 51s

Stefan from Sweden checks in with a much better way to do a word count of all the sentences [referring to the "Word Count from Sentences" Podcast, Episo…

x

Share: Learn Excel 2010 - "Word Count from Word": Podcast #1462


Learn Excel - "Pivot Table Defaults": Podcast #1461

2011-11-02
Length: 6m 24s

  • Why can't we do a Pivot Table Template?
  • Why can't we turn off the annoying Compact Layout?
  • Why do I keep asking these questions when it is so easy to override them with a tiny add-in?

x

Share: Learn Excel - "Pivot Table Defaults": Podcast #1461


Learn Excel 2010 - "Word Count from Sentences": Podcast #1460

2011-11-01
Length: 4m 0s

Today on Learn Excel from MrExcel, Zac has 5000 phrases in column A. He wants to figure out which words are most popular in those phrases. With Episode #1460, Bill shows us a number of steps that will solve…

x

Share: Learn Excel 2010 - "Word Count from Sentences": Podcast #1460


Dueling Excel - "Pivot Table Totals on Left": Podcast #1459

2011-10-31
Length: 9m 9s

Someone in my Michigan seminar posed this question: “Can you get the pivot table grand total column to appear on the left side of the pivot table?” This is handy when you have so many columns that you’re n…

x

Share: Dueling Excel - "Pivot Table Totals on Left": Podcast #1459


Learn Excel - "Scrolling In the Formula Bar": Podcast #1458

2011-10-28
Length: 2m 30s

Jil asks today's question. Jil used to be able to edit a Formula and use the Wheel Mouse to scroll the Spreadsheet while editing the formula. This apparently doesn't work any more, starting in Excel 2007. Today, in

x

Share: Learn Excel - "Scrolling In the Formula Bar": Podcast #1458


Learn Excel 2010 - "Excel Outside The Box": Podcast #1457

2011-10-27
Length: 3m 18s

Bob Umlas’ new book just arrived from the printer – “Excel Outside the Box: Unbelievable Excel Techniques”. Today, Bill takes a look at the new book, tells you where you can buy an advanced copy, and…

x

Share: Learn Excel 2010 - "Excel Outside The Box": Podcast #1457


Learn Excel - "Pivot To Range": Podcast #1456

2011-10-27
Length: 2m 59s

Two Pivot Table questions today from my ‘Power Excel’ Seminar in Detroit, MI yesterday. First, when you drill down on a pivot table in Excel 2007, you are getting the Table Format instead of just a Range. How ca…

x

Share: Learn Excel - "Pivot To Range": Podcast #1456


Learn Excel 2010 - "Drag Formula Reference": Podcast #1455

2011-10-25
Length: 1m 38s

Frank asks if there is a way to rewrite a formula using a scrollbar. While we can’t do it with a scrollbar, I do have a way to rewrite formula with a dragging technique. Following along with Bill in Episode #1…

x

Share: Learn Excel 2010 - "Drag Formula Reference": Podcast #1455


Dueling Excel - "The Top 70%": Podcast #1454

2011-10-24
Length: 7m 54s

Today, Bill “MrExcel” Jelen and Mike “ExcelisFun” Girvin look at a question that asks: “How can I audit 70% of the book value, with samples based on the value?” Conditional Formatting pro…

x

Share: Dueling Excel - "The Top 70%": Podcast #1454


Learn Excel 2010 - "Clear If new Day": Podcast #1453

2011-10-21
Length: 5m 13s

Kevin wants to clear out data for yesterday’s shift worksheet any time someone opens the Workbook. Using the formula from Share this episode

x

Share: Learn Excel 2010 - "Clear If new Day": Podcast #1453


Learn Excel 2010 - "Shift Change?": Podcast #1452

2011-10-20

Bill wants to know: “Did a new shift start between Time 1 and Time 2? It sounds like such an easy formula, and it probably is, but I sure had a tough time puzzling this formula out. Do you have something easier?&rdquo…

x

Share: Learn Excel 2010 - "Shift Change?": Podcast #1452


Learn Excel 2011 - "Mac xlautomatic": Podcast #1451

2011-10-19

Mark this date: October 18th, 2011 – Bill “MrExcel” Jelen’s First-Ever Podcast for MAC Users! [The Title of this Blog Post is NOT a typo.]

Joe has Excel 2011 for …

x

Share: Learn Excel 2011 - "Mac xlautomatic": Podcast #1451


Learn Excel 2010 - "Formulas Not Working": Podcast #1450

2011-10-18

What is ‘Alt+DEF’ good for? Today, in Episode #1450, Christopher and Sheila both wrote in with different problems that required the same solu…

x

Share: Learn Excel 2010 - "Formulas Not Working": Podcast #1450


Dueling Excel - "Positive Subtotals": Podcast #1449

2011-10-17

Today, in Episode #1449, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen address different methods to answer the question: “Is there a way…

x

Share: Dueling Excel - "Positive Subtotals": Podcast #1449


Learn Excel 2010 - "The MrExcel Mailbag": Podcast #1448

2011-10-14

Three miscellaneous “Learn Excel Tips” from MrExcel…

x

Share: Learn Excel 2010 - "The MrExcel Mailbag": Podcast #1448


Learn Excel 2010 - "Add Totals": Podcast #1447

2011-10-13

Add totals to the bottom and right of a large Spreadsheet…

x

Share: Learn Excel 2010 - "Add Totals": Podcast #1447


Dueling Excel - "MODE from Frequency Table": Podcast #1446

2011-10-12

Calculate a MODE or MEDIAN from a Frequency Table in Excel…

x

Share: Dueling Excel - "MODE from Frequency Table": Podcast #1446


Learn Excel 2010 - "Within 25% of Budget": Podcast #1445

2011-10-11

Use Conditional Formatting to warn when expenses are getting too close to budget…

x

Share: Learn Excel 2010 - "Within 25% of Budget": Podcast #1445


Learn Excel 2010 - "Time 1 Hour Ago?": Podcast #1444

2011-10-10

You can flag a cell if it is 1 hour late!…

x

Share: Learn Excel 2010 - "Time 1 Hour Ago?": Podcast #1444


Learn Excel 2010 - "Hide and Protect": Podcast #1442

2011-10-06

Protect your hidden settings – with a formula?…

x

Share: Learn Excel 2010 - "Hide and Protect": Podcast #1442


Learn Excel 2010 - "Conditional Format the Entire Row": Podcast #1441

2011-10-05

Highlight All Columns in your Data Set using Conditional Formatting.…

x

Share: Learn Excel 2010 - "Conditional Format the Entire Row": Podcast #1441


Learn Excel 2010 - "Mixing Chart Themes": Podcast #1440

2011-10-04

Creating Two Charts with Colors from different Themes in Excel!…

x

Share: Learn Excel 2010 - "Mixing Chart Themes": Podcast #1440


Dueling Excel - "Algebra? We don't need Algebra!": Podcast #1439

2011-10-03

Solve an algebra problem using Excel’s Goal Seek or Create an Dynamic Equation (622+x)/12…

x

Share: Dueling Excel - "Algebra? We don't need Algebra!": Podcast #1439


Learn Excel 2010 - "Variable Rate Loan Payment": Podcast #1438

2011-09-30

Using Goal Seek to Calculate Payments…

x

Share: Learn Excel 2010 - "Variable Rate Loan Payment": Podcast #1438


Learn Excel 2010 - "Where's The Spreadsheet?": Podcast #1437

2011-09-29

Learn Excel Mystery Theater at Hartville Hardware: “Where is the Spreadsheet?”…

x

Share: Learn Excel 2010 - "Where's The Spreadsheet?": Podcast #1437


Learn Excel 2010 - "Access Format": Podcast #1436

2011-09-28

Turn a Beautifully Printed Report into a Beautifully Formatted Data Set ready to be imported into Microsoft Access!…

x

Share: Learn Excel 2010 - "Access Format": Podcast #1436


Learn Excel 2010 - "Pivot Table Delta": Podcast #1435

2011-09-27

Making your Pivot Table tell the story that YOU want it to.…

x

Share: Learn Excel 2010 - "Pivot Table Delta": Podcast #1435


Dueling Excel - "Count by Quarter Hour": Podcast #1434

2011-09-26

How many events occurred in 15 minutes? We have the Data; we have the Technology!…

x

Share: Dueling Excel - "Count by Quarter Hour": Podcast #1434


Learn Excel 2010 - "Remove Duplicates": Podcast #1433

2011-09-26

VBA to Remove Duplicates? Not since 2007 – see how!…

x

Share: Learn Excel 2010 - "Remove Duplicates": Podcast #1433


Learn Excel 2010 - "Hosted PowerPivot": Podcast #1432

2011-09-26

Create a Web App using Excel!…

x

Share: Learn Excel 2010 - "Hosted PowerPivot": Podcast #1432


Learn Excel 2010 - "Numbers to Words in Excel": Podcast #1431

2011-09-26

How to use the SpellNumber code, from Microsoft, to spell out numbers in Excel!…

x

Share: Learn Excel 2010 - "Numbers to Words in Excel": Podcast #1431


Learn Excel 2010 - "Waterfall Charts in Excel": Podcast #1430

2011-09-21

Create a Waterfall Chart in Excel – without an Add-in!…

x

Share: Learn Excel 2010 - "Waterfall Charts in Excel": Podcast #1430


Dueling Excel - "Collapse with a Formula": Podcast #1429

2011-09-20

Dealing with a bad data download each day; turning it into a usable report…

x

Share: Dueling Excel - "Collapse with a Formula": Podcast #1429


Learn Excel 2010 - "Rolling Date Data Validation": Podcast #1428

2011-09-19

Excel Data Validation to Plus or Minus time from NOW…

x

Share: Learn Excel 2010 - "Rolling Date Data Validation": Podcast #1428


Learn Excel - "The Read Aloud Method": Podcast #1427

2011-09-15

Read Aloud Method for Totals?…

x

Share: Learn Excel - "The Read Aloud Method": Podcast #1427


Learn Excel 2010 - "Dynamic Chart Labels": Podcast #1426

2011-09-15

Adding formulas to the data labels in an Excel chart…

x

Share: Learn Excel 2010 - "Dynamic Chart Labels": Podcast #1426


Learn Excel 2010 - "More Chart Titles": Podcast #1425

2011-09-13

Add Custom Text or the Current Date to your Chart Title!…

x

Share: Learn Excel 2010 - "More Chart Titles": Podcast #1425


Dueling Excel - "Price Beneath Lookup Value": Podcast #1424

2011-09-12

Conditional Formatting or Data Validation…? Which would work for you?…

x

Share: Dueling Excel - "Price Beneath Lookup Value": Podcast #1424


Learn Excel - "COUNTIF 2 Conditions in Excel 2003": Podcast #1423

2011-09-09

COUNTIF and SUMPRODUCT in *Excel 2003…

x

Share: Learn Excel - "COUNTIF 2 Conditions in Excel 2003": Podcast #1423


Learn Excel 2010 - "Craziest Excel Question Ever?": Podcast #1422

2011-09-08

What is the most ‘unusual’ question or comment that you’ve gotten…?…

x

Share: Learn Excel 2010 - "Craziest Excel Question Ever?": Podcast #1422


Learn Excel 2010 - "Previous Work Day?" Podcast #1421

2011-09-07

How can I calculate the previous work day, excluding weekends and holidays…

x

Share: Learn Excel 2010 - "Previous Work Day?" Podcast #1421


Dueling Excel - "Get Matching Records": Podcast #1420

2011-09-06

Dueling Podcasts are back! Check out Duel #81!…

x

Share: Dueling Excel - "Get Matching Records": Podcast #1420


Learn Excel 2010 - "Month Chart Labels": Podcast #1419

2011-09-02

Showing every Third Month Label on a Chart…

x

Share: Learn Excel 2010 - "Month Chart Labels": Podcast #1419


Learn Excel 2010 - "Unwinding Array": Podcast #1418

2011-09-01

VLOOKUP and no backward compatibility?…

x

Share: Learn Excel 2010 - "Unwinding Array": Podcast #1418


Learn Excel 2010 - "Dynamic Pictures": Podcast #1417

2011-08-31

Change a Picture based on a Cell……

x

Share: Learn Excel 2010 - "Dynamic Pictures": Podcast #1417


Learn Excel 2010 - "Jeff's Slicer Trick": Podcast #1416

2011-08-30

Use a pivot table slicer as a selection control in non-pivot situations…

x

Share: Learn Excel 2010 - "Jeff's Slicer Trick": Podcast #1416


Learn Excel 2010 - "Sum Red": Podcast #1415

2011-08-29

Sum – by color! A Simple Macro will do the trick for you!…

x

Share: Learn Excel 2010 - "Sum Red": Podcast #1415


Learn Excel 2010 - 'August' from 8/25/2011: Podcast #1414

2011-08-26

I want the Month/Weekday Name…not numbers!…

x

Share: Learn Excel 2010 - 'August' from 8/25/2011: Podcast #1414


Learn Excel - "4-Way Lookup" Podcast #1413

2011-08-25

Use INDEX and INDIRECT to create a 4-Way LOOKUP!…

x

Share: Learn Excel - "4-Way Lookup" Podcast #1413


Learn Excel - "Looks Like a Date, Coincidentally": Podcast #1412

2011-08-24

When a CSV field is imported as a date instead of a part number in Excel…

x

Share: Learn Excel - "Looks Like a Date, Coincidentally": Podcast #1412


Learn Excel: "Back" Podcast #1411

2011-08-23

Back from a writing hiatus, Bill starts off with a challenge…

x

Share: Learn Excel: "Back" Podcast #1411


Learn Excel - Hiatus: Podcast #1410

2011-05-23

Going on Hiatus to write a book…

x

Share: Learn Excel - Hiatus: Podcast #1410


Dueling Excel - Chart Titles: Podcast #1409

2011-05-20

Add Dynamic Titles to Charts…

x

Share: Dueling Excel - Chart Titles: Podcast #1409


Learn Excel - Chart Title, Legend, Colors: Podcast #1408

2011-05-19

Add a chart title, move the legend, add data labels and change the colors in an Excel chart…

x

Share: Learn Excel - Chart Title, Legend, Colors: Podcast #1408


Learn Excel - Change The Chart Scale: Podcast #1407

2011-05-18

Change the chart axis settings in Excel…

x

Share: Learn Excel - Change The Chart Scale: Podcast #1407


Learn Excel - Create The Chart: Podcast #1406

2011-05-17

Create A Chart from Data in Excel…

x

Share: Learn Excel - Create The Chart: Podcast #1406


Learn Excel - Set Up Data for Charting: Podcast #1405

2011-05-16

Basic Charting - Part I: Going from just words to a Chart in Excel…

x

Share: Learn Excel - Set Up Data for Charting: Podcast #1405


Dueling Excel - Percent of Parent: Podcast #1404

2011-05-13

Three ways to get a % of Total…

x

Share: Dueling Excel - Percent of Parent: Podcast #1404


Learn Excel - Azure Data Marketplace: Podcast #1403

2011-05-12

Download data from Azure Data Market to Excel…

x

Share: Learn Excel - Azure Data Marketplace: Podcast #1403


Learn Excel - "SUMIF Explained": Podcast #1402

2011-05-11

Build a weighted average using two SUMIF function…

x

Share: Learn Excel - "SUMIF Explained": Podcast #1402


Learn Excel - Change-Pro for Excel: Podcast #1400

2011-05-10

Track changes in Excel using Change-Pro for Excel…

x

Share: Learn Excel - Change-Pro for Excel: Podcast #1400


Learn Excel - A Better Lotto: Podcast #1401

2011-05-10

Choose Lotto Numbers with Excel…

x

Share: Learn Excel - A Better Lotto: Podcast #1401


Dueling Excel - Top 2 Part II: Podcast #1399

2011-05-06

Aggregate function and array formula for finding top 2 by industry…

x

Share: Dueling Excel - Top 2 Part II: Podcast #1399


Learn Excel - Dynamic Chart Date: Podcast #1398

2011-05-05

Add a Formula to a Chart Title…

x

Share: Learn Excel - Dynamic Chart Date: Podcast #1398


Learn Excel - Column wider: Podcast #1397

2011-05-04

Make the column wider when the column headers are turned off…

x

Share: Learn Excel - Column wider: Podcast #1397


Learn Excel - VLOOKUP Total: Podcast #1396

2011-05-03

Return the total from all matching rows in a VLOOKUP…

x

Share: Learn Excel - VLOOKUP Total: Podcast #1396


Learn Excel - XLYourFinances.com: Podcast #1395

2011-05-02

Track your finances in Excel with this handy add-in…

x

Share: Learn Excel - XLYourFinances.com: Podcast #1395


Dueling Excel - Top 2 by Industry: Podcast #1394

2011-05-02

Top 2 by Industry…

x

Share: Dueling Excel - Top 2 by Industry: Podcast #1394


Learn Excel - Column Width and Row Height: Podcast #1393

2011-04-28

Copy column widths or row heights…

x

Share: Learn Excel - Column Width and Row Height: Podcast #1393


Learn Excel - Format Cells after Edit: Podcast #1392

2011-04-27

Change font color of edited cells using a one-line macro…

x

Share: Learn Excel - Format Cells after Edit: Podcast #1392


Learn Excel - The MrExcel Message Board: Podcast #1391

2011-04-26

Get Excel questions answered quickly at the MrExcel Message Board…

x

Share: Learn Excel - The MrExcel Message Board: Podcast #1391


Learn Excel with Max -(minus) Min in a Pivot Table: Podcast #1390

2011-04-25

Calculate a Range of MAX -(minus)MIN in a Pivot Table…

x

Share: Learn Excel with Max -(minus) Min in a Pivot Table: Podcast #1390


Dueling Excel - Add A Hyperlinked TOC: Podcast #1389

2011-04-22

Add a Hyperlink Table of Contents to a Worksheet…

x

Share: Dueling Excel - Add A Hyperlinked TOC: Podcast #1389


Learn Excel - Project Due?: Podcast #1388

2011-04-21

Checking for two conditions in a formula…

x

Share: Learn Excel - Project Due?: Podcast #1388


Learn Excel - It's 6 O'clock Somewhere: Podcast #1387

2011-04-20

Add 18 hours to several cells to make them be 6PM…

x

Share: Learn Excel - It's 6 O'clock Somewhere: Podcast #1387


Learn Excel - VBA Picture Comments: Podcast #1386

2011-04-19

Add pop-up pictures to a cell in Excel 2010 using a Macro…

x

Share: Learn Excel - VBA Picture Comments: Podcast #1386


VBA and Macros 2010 - Marking Duplicates: Podcast #1326

2011-01-19

Formula-based conditional formatting in Excel VBA…

x

Share: VBA and Macros 2010 - Marking Duplicates: Podcast #1326


Pivot Tables - PowerPivot Sort

2011-01-17

PowerPivot sorting…

x

Share: Pivot Tables - PowerPivot Sort


Dueling Excel-Charting Positive and Negative: Podcast #1323

2011-01-16

Charting Positive and Negative Values…

x

Share: Dueling Excel-Charting Positive and Negative: Podcast #1323


Charts and Graphs - Shape Formula: Podcast #1322

2011-01-13

Have the text from a shape come from a formula…

x

Share: Charts and Graphs - Shape Formula: Podcast #1322


Excel Rev Up - Filter Search: Podcast #1321

2011-01-12

Search by Multiple Filters…

x

Share: Excel Rev Up - Filter Search: Podcast #1321


Power Pivot 2010 - "Asymmetric Reporting": Podcast #1320

2011-01-11

Create an asymmetric report with PowerPivot…

x

Share: Power Pivot 2010 - "Asymmetric Reporting": Podcast #1320


Dueling Excel - Address of a Cell: Podcast #1319

2011-01-07

Find the address of a cell with a formula…

x

Share: Dueling Excel - Address of a Cell: Podcast #1319


Charts and Graphs - Create a Visual of Geographic Data: Podcast #1318

2011-01-06

Map your Excel Data…

x

Share: Charts and Graphs - Create a Visual of Geographic Data: Podcast #1318


Excel Rev Up - Sort by Color: Podcast #1317

2011-01-04

Sort data by color…

x

Share: Excel Rev Up - Sort by Color: Podcast #1317


Dueling Excel - Red Over 140: Podcast #1316

2010-12-31

Highlight all cells over a threshold in red.…

x

Share: Dueling Excel - Red Over 140: Podcast #1316


Excel Rev Up - A Better Formula Copy: Podcast #1315

2010-12-30

Copy a Formula to the Bottom of the Data Set using the Fill Handle…

x

Share: Excel Rev Up - A Better Formula Copy: Podcast #1315


Excel In Depth - Easy XL: Podcast #1314

2010-12-28

Waht is Easy-XL and how can it benefit me?…

x

Share: Excel In Depth - Easy XL: Podcast #1314


Dueling Excel - Sort Summary: Podcast #1313

2010-12-24

Count results leaving categories in their original order…

x

Share: Dueling Excel - Sort Summary: Podcast #1313


Excel Rev Up - Tables: Podcast #1312

2010-12-23

Charts based on an Excel 2010 table will grow as the table grows…

x

Share: Excel Rev Up - Tables: Podcast #1312


Pivot Tables - Pivot Tables in a Browser: Podcast #1311

2010-12-22

Pivot tables in a browser…

x

Share: Pivot Tables - Pivot Tables in a Browser: Podcast #1311


Filter Dropdowns: Podcast #1310

2010-12-21

Move the AutoFilter dropdowns from row 1 of your worksheet…

x

Share: Filter Dropdowns: Podcast #1310


Charts and Graphs - Create a Chart without a Chart: Podcast #1309

2010-12-20

In-Cell bar charts with REPT…

x

Share: Charts and Graphs - Create a Chart without a Chart: Podcast #1309


Dueling Excel - "Sort with a Formula": Podcast #1308

2010-12-17

Sorting Data using a Formula…

x

Share: Dueling Excel - "Sort with a Formula": Podcast #1308


Excel Rev Up - AGGREGATE Function: Podcast #1307

2010-12-16

Total a range, ignoring error cells in Excel 2010…

x

Share: Excel Rev Up - AGGREGATE Function: Podcast #1307


PowerPivot 2010 - "More Than 4 charts": Podcast #1306

2010-12-15

Set up five pivot tables in PowerPivot, all tied to the same slicers…

x

Share: PowerPivot 2010 - "More Than 4 charts": Podcast #1306


Learn Excel 2010 - Win/Loss Sparklines: Podcast #1305

2010-12-14

Illustrating a sports season using Excel 2010 Sparklines…

x

Share: Learn Excel 2010 - Win/Loss Sparklines: Podcast #1305


VBA and Macros 2010 - "Group by Week": Podcast #1304

2010-12-13

Use a Macro to Roll-Up Dates in Excel Quickly…

x

Share: VBA and Macros 2010 - "Group by Week": Podcast #1304


Dueling Excel - "Unwind Dates": Podcast #1303

2010-12-10

Break your Dates out to a sequential list with Dueling Excel…

x

Share: Dueling Excel - "Unwind Dates": Podcast #1303


Charts and Graphs - Chart For Each: Podcast #1302

2010-12-09

Create a chart for every customer…

x

Share: Charts and Graphs - Chart For Each: Podcast #1302


Excel Rev Up - Quick Statistics: Podcast #1301

2010-12-09

See total of selected cells in the status bar…

x

Share: Excel Rev Up - Quick Statistics: Podcast #1301


VBA & Macros 2010 - Exact Chart Location: Podcast #1291

2010-11-22

Macro to ensure charts appear in an exact cell range…

x

Share: VBA & Macros 2010 - Exact Chart Location: Podcast #1291


Excel Rev Up - Print Preview: Podcast #1290

2010-11-19

Print Preview in Excel 2010…

x

Share: Excel Rev Up - Print Preview: Podcast #1290


Charts and Graphs - Paired Bar Charts: Podcast #1289

2010-11-18

Side-by-Side Bar Charts…

x

Share: Charts and Graphs - Paired Bar Charts: Podcast #1289


Pivot Tables - Slicers in Excel 2010: Podcast #1288

2010-11-17

Using a Pivot Table Slicer…

x

Share: Pivot Tables - Slicers in Excel 2010: Podcast #1288


Charts and Graphs - Too Many Pie Slices!: Podcast #1287

2010-11-15

Deal with too many slices in a pie chart…

x

Share: Charts and Graphs - Too Many Pie Slices!: Podcast #1287


Dueling Excel - Excused Absence: Podcast #1286

2010-11-12

Calculate a % score, ignoring non-numeric assignments…

x

Share: Dueling Excel - Excused Absence: Podcast #1286


Excel Rev Up - My Favorite Margins: Podcast #1285

2010-11-10

Get quicker access to your favorite margin settings in Excel 2010…

x

Share: Excel Rev Up - My Favorite Margins: Podcast #1285


Charts and Graphs - Converting Text to Dates: Podcast #1284

2010-11-09

Fix Dates in a Chart Data Source…

x

Share: Charts and Graphs - Converting Text to Dates: Podcast #1284


Dueling Excel - Approximate Multi-Lookup: Podcast #1283

2010-11-08

Return all values that contain the word car or truck…

x

Share: Dueling Excel - Approximate Multi-Lookup: Podcast #1283


Excel Rev Up - Paste Options: Podcast #1282

2010-11-05

Convert formulas to values in two keystrokes using the new Paste Options menu…

x

Share: Excel Rev Up - Paste Options: Podcast #1282


Excel In Depth - Easy-XL and Sheet Merging: Podcast #1281

2010-11-04

Use Easy-XL to merge rows from two different lists.…

x

Share: Excel In Depth - Easy-XL and Sheet Merging: Podcast #1281


Pivot Tables - % of Parent Item:Podcast #1280

2010-11-03

Calculate % of parent item in a pivot table…

x

Share: Pivot Tables - % of Parent Item:Podcast #1280


Kill the Button: Podcast #1279

2010-11-02

Delete ActiveX buttons or Form control buttons from your Excel worksheet…

x

Share: Kill the Button: Podcast #1279


Excel Rev Up - The Big Grid: Podcast #1277

2010-11-01

Unlocking the extra million rows in Excel 2010…

x

Share: Excel Rev Up - The Big Grid: Podcast #1277


Dueling Excel - Extract State: Podcast #1276

2010-10-29

Locate the last comma in a cell…

x

Share: Dueling Excel - Extract State: Podcast #1276


Charts and Graphs - Use Shapes for Markers: Podcast #1275

2010-10-28

Create a column chart with arrows for columns…

x

Share: Charts and Graphs - Use Shapes for Markers: Podcast #1275


Mark the Last: Podcast #1274

2010-10-27

Mark the last record in each group using conditional formatting…

x

Share: Mark the Last: Podcast #1274


Charts and Graphs - Series Order: Podcast #1273

2010-10-26

Change the series order in a chart.…

x

Share: Charts and Graphs - Series Order: Podcast #1273


Save a Form in Excel: Podcast #1272

2010-10-25

Record a macro to post a form to the next record in a database…

x

Share: Save a Form in Excel: Podcast #1272


Dueling Excel - Lookup 2 Values: Podcast #1271

2010-10-22

DGET, INDEX, or SUMIFS to to a two-column lookup?…

x

Share: Dueling Excel - Lookup 2 Values: Podcast #1271


Excel in Depth - Excel Web App: Podcast #1270

2010-10-21

Run Excel 2010 in a browser!…

x

Share: Excel in Depth - Excel Web App: Podcast #1270


Highlight Today: Podcast #1269

2010-10-20

Use conditional formatting to mark rows that match today.…

x

Share: Highlight Today: Podcast #1269


Excel in Depth - Page Layout View: Podcast #1268

2010-10-18

Excel 2010 offers the intuitive Page Layout View…

x

Share: Excel in Depth - Page Layout View: Podcast #1268


Dueling Excel - 2 Item VLOOKUP: Podcast #1267

2010-10-15

VLOOKUP when you have to match two columns…

x

Share: Dueling Excel - 2 Item VLOOKUP: Podcast #1267


Comparing Worksheets: Podcast #1266

2010-10-14

Compare two sheets using Conditional Formatting in Excel 2010…

x

Share: Comparing Worksheets: Podcast #1266


Learn Excel 2010 - "Added Times Won't Calculate": Podcasts #1468

0000-00-00
Length: 2s

Shaun has a beautiful spreadsheet to calculate staffing levels and expense.He needs to multiply shift length by the number of staff and the answer that he is getting is . . . immaterial to the task at hand. With a few chang…

x

Share: Learn Excel 2010 - "Added Times Won't Calculate": Podcasts #1468


Dueling Excel - "Rank Ties by Weight": Podcast #1473

0000-00-00
Length: 7s

Dueling Excel looks at Scores and Tie Breaking. In this example, When there is a tie, we want to award the Highest Rank to the Largest Weight. Quite simply, after ranking a column with ties, we want to break the tie based o…

x

Share: Dueling Excel - "Rank Ties by Weight": Podcast #1473


Learn Excel 2010 - "Wrap Cells and Resize": Podcast #1472

0000-00-00
Length: 3s

Herbie has a Calendar spreadsheet being populated by a huge concatination formula. He asks if there is a way to combine Wrap Cells and Shrink to Fit as he works in the calendar. In Episode #1472 Bill shows …

x

Share: Learn Excel 2010 - "Wrap Cells and Resize": Podcast #1472


Learn Excel 2010 - "Random with No Repeats": Podcast #1471

0000-00-00
Length: 2s

Choose random weeks from the Data Set, but do it without repeating a week. In a revisit to Episode #1469, how will Bill assure that there are no repeats in the Random selection? Follow along with Episode #1471

x

Share: Learn Excel 2010 - "Random with No Repeats": Podcast #1471


Learn Excel 2010 - "Copy Totals to Week # Macro": Podcast #1470

0000-00-00
Length: 6s

Patrick has a weekly Expense Ledger Spreadsheet set up; he wants to create a Macro to copy the Totals from Report 1 to a corresponding Week Number Row on the Summary worksheet. This Macro has to use the FIND command in VBA …

x

Share: Learn Excel 2010 - "Copy Totals to Week # Macro": Podcast #1470


Learn Excel 2010 - "Random Weeks Over 6 Months": Podcast #1469

0000-00-00
Length: 2s

A YouTube viewer wants to find a way to generate random weeks over the next 6 months. In Episode #1469, Bill “MrExcel” Jelen – using TODAY, WEEKDAY, and RANDBETWEEN Functions – shows…

x

Share: Learn Excel 2010 - "Random Weeks Over 6 Months": Podcast #1469


The Learn Excel from MrExcel Podcast - "BFSBSCM": Podcast #1477

0000-00-00
Length: 2s

It's the eve of the holiday shopping season. And while we don't hope to have anyone camping out at MrExcel overnight, here are some of the deals that we are running starting Thursday, 24-November-2011 and through Monda…

x

Share: The Learn Excel from MrExcel Podcast - "BFSBSCM": Podcast #1477


Learn Excel 2010 - "Number The Visible Row": Podcast #1476

0000-00-00
Length: 1s

A Challenge from none other than Bob Umlas - author of "Excel Outside The Box: Unbelievable Excel Techniques". Bob wants to Number Rows, but ignore the 'Hidden' Rows. In Episode #1476 Bill looks to a New Function for Excel …

x

Share: Learn Excel 2010 - "Number The Visible Row": Podcast #1476


Learn Excel 2010 - "Lat 12 34.567": Podcast #1475

0000-00-00
Length: 2s

A facebook posting asks how to convert a column of 7 digit numbers (ie, 1234567) into the format of "Lat 12 34.567". The answer is easier than you might think. In Episode #1476, Bill shows us a non-formula way to answer the…

x

Share: Learn Excel 2010 - "Lat 12 34.567": Podcast #1475


Learn Excel 2010 - "Date Stamp Next to a Yes": Podcast #1474

0000-00-00
Length: 3s

Superbeast326 at YouTube asks if there is a way to add the current date to the right of any 'Yes' entries in a spreadsheet; if a cell is marked 'Yes', then I want the cell to the right of that cell to show the date. Using a…

x

Share: Learn Excel 2010 - "Date Stamp Next to a Yes": Podcast #1474


Learn Excel 2010 - "Random Drug Testing": Podcast #1491

0000-00-00
Length: 4s

A small company has decided to start doing Random Drug Testing. They want to randomly select two (2) employees each month. In Episode #1491, Bill builds a handy Workbook for this task. Enter the Employee Names in B2:B101, then pre…

x

Share: Learn Excel 2010 - "Random Drug Testing": Podcast #1491


Dueling Excel - "Find Cubic Feet": Podcast #1492

0000-00-00
Length: 9s

Today's Dueling Excel comes from France... Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen are looking for the words 'Top laod' or 'Front load', and then Cubic Feet. In the process they will also need to change the d…

x

Share: Dueling Excel - "Find Cubic Feet": Podcast #1492


Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490

0000-00-00
Length: 5s

All this week, Bill has been dealing with a Workbook with 31 sheets - one Worksheet per day. Today, in Episode #1490, Bill presents a bizarre Formula to put the Sheet Name in a Cell. Actually, today, I use a MID of the Shee…

x

Share: Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490


Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489

0000-00-00
Length: 2s

Yesterday, in Podcast Episode #1488, Bill showed us a cool way to make 30 copies of a worksheet. However, after creating the worksheets we were left with strange names like Sheet1 (2), Sheet1 (3) and so on. Horrible! Today,…

x

Share: Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489


Learn Excel 2010 - "Worksheet Per Day": Podcast #1488

0000-00-00
Length: 2s

Damia from YouYube has to create 31 copies of a worksheet; one for each day of the month. Right now, Damia is using 'Insert Worksheet' 30 times, copying Sheet1 contents and pasting 30 times; then changing the zoom…

x

Share: Learn Excel 2010 - "Worksheet Per Day": Podcast #1488


Dueling Excel - "Watch Box": Podcast #1487

0000-00-00
Length: 9s

In today's Dueling Excel, Episode #1487,  Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen team up to defend Excel's honor, showing two different methods to create a Watch Box in Excel.

x

Share: Dueling Excel - "Watch Box": Podcast #1487


Learn Excel 2010 - "Zero Point Zero Two": Podcast #1486

0000-00-00
Length: 1s

Today, in Episode #1486, Bill discusses his experience at a recent seminar.

"I was doing a Power Excel Seminar in Miami when I kept typing zero point zero two (0.02) in a formula. Of…

x

Share: Learn Excel 2010 - "Zero Point Zero Two": Podcast #1486


Learn Excel 2010 - "Picture Lookup": Podcast #1485

0000-00-00
Length: 4s

Prince asks if there is a way to return a Picture as the result of a VLOOKUP instead of a Value. In Episode #1485, Bill shows us one way to solve the challenge and deliver the result.

&he…

x

Share: Learn Excel 2010 - "Picture Lookup": Podcast #1485


Learn Excel 2010 - "Labels from Excel Data to Word 2010": Podcast #1484

0000-00-00
Length: 4s

So, You have address information in Excel and you want to produce mailing labels in Word. Should be easy, right? Moslty, Wrong. No venture into Word is easy. In Episode #1484, Bill will show us the hassle-free method to pro…

x

Share: Learn Excel 2010 - "Labels from Excel Data to Word 2010": Podcast #1484


Dueling Excel - "Rounding Invoices": Podcast #1483

0000-00-00
Length: 4s

We don't call it 'Dueling Excel' for No Reason!
 
And at some point one has to stop and ask, "How can two guys possibly disagree about the best way to Round Invoices?"
Well... leave it to Mike and Bill b…

x

Share: Dueling Excel - "Rounding Invoices": Podcast #1483


Learn Excel 2010 - "Table Schmable, I Want Results!": Podcast #1482

0000-00-00
Length: 1s

Today Yari is frustrated that his Formulas pointing into a Table (with a capital T) will not copy across the Columns. Yari wants totals and he isn't getting them. In Episode #1482, Bill explains why Yari isn't getting his t…

x

Share: Learn Excel 2010 - "Table Schmable, I Want Results!": Podcast #1482


Learn Excel - "Repeat Macro for Each Cell in A": Podcast #1481

0000-00-00
Length: 2s

Learn a little about Customizing your VBA. We have a Macro that runs on the current cell; JK wants the macro to run for each cell in Column A. Today, in Episode #1481, Bill shows us how calculate the number of cells we need…

x

Share: Learn Excel - "Repeat Macro for Each Cell in A": Podcast #1481


Learn Excel 2010 - "Sum Over Threshold": Podcast #1480

0000-00-00
Length: 2s

Today, lets consider this question: Someone has a threshold value of $25000 in cell E1. We want to add up all the values in A2:A8 that are over the threshold. But...as a twist, how do we work with only those amounts in exce…

x

Share: Learn Excel 2010 - "Sum Over Threshold": Podcast #1480


Learn Excel - "Differing Column Widths": Podcast #1479

0000-00-00
Length: 2s

YouTube viewer Bill sent in a question: "How can change column widths when I am half way down the column?" Bill is using Mac Office 2008. Though there isn't a way to do what Bill is asking, MrExcel offers up a possible solu…

x

Share: Learn Excel - "Differing Column Widths": Podcast #1479


Learn Excel 2010 - "Rank Ties Redo": "Podcast #1478

0000-00-00
Length: 1s

Last weeks Dueling Excel Episode #1473 looked at Ranking Ties by Weight. Today, in Episode #1478, Bill shows a method using a temporary column.

…This blog is the video podcast companion to the book,

x

Share: Learn Excel 2010 - "Rank Ties Redo": "Podcast #1478


Learn Excel 2010 - "Variable Chart by Dropdown": Podcast #1493

0000-00-00
Length: 3s

Today, in Episode #1493, Mike from Athens, Greece asks how to create a control that would change a chart to show either units or revenue. Bill presents a borrowed solution from Mike Alexander at DataPigTechnologies.com, but…

x

Share: Learn Excel 2010 - "Variable Chart by Dropdown": Podcast #1493


Learn Excel 2010 - "Filter to Unique?": Podcast #1500

0000-00-00
Length: 1s

Today's question... can you use the AutoFilter dropdowns to filter to one row per unique customers? For a solution to this, you can move to the Advanced Filter or use Remove Duplicates on a copy of the data. Follow along wi…

x

Share: Learn Excel 2010 - "Filter to Unique?": Podcast #1500


Learn Excel 2010 - "Improved Excel Help": Podcast #1499

0000-00-00
Length: 2s

I'm sure [like myself] that some viewers will be somewhat confused when viewing this podcast today...I assume that many of us thought Bill "MrExcel" Jelen and the MrExcel Community was the 'Excel He…

x

Share: Learn Excel 2010 - "Improved Excel Help": Podcast #1499


Learn Excel 2010 - "Two Subtotals At Top": Podcast #1498

0000-00-00
Length: 2s

Today, Amelie asks how to add Two sets of Subtotals, with the Subtotals appearing at the top! In Episode #1498 of the Learn Excel from MrExcel Podcast Series, Bill shows us how to get the Subtotals.

Share this episode

x

Share: Learn Excel 2010 - "Two Subtotals At Top": Podcast #1498


Learn Excel 2010 - "Sheets Revisted": Podcast #1497

0000-00-00
Length: 2s

Episodes #1488 and #1489 of the "Learn Excel from MrExcel Podcasts" generated a lot of email from viewers. Today, in Episode #1497, Bill revisits those episodes [that were dealing with making copies of worksheets]. Looking …

x

Share: Learn Excel 2010 - "Sheets Revisted": Podcast #1497


Learn Excel 2010 - "Did Santa bring an iPad?": Podcast #1495

0000-00-00
Length: 3s

Today, Bill offers a quick tip on getting acclimated to your new iPad! Check out QUE Publishing. QUE is offering a free enhanced eBook sampler. This is a great way to show off your new iPad! See Episode #1495 for detai…

x

Share: Learn Excel 2010 - "Did Santa bring an iPad?": Podcast #1495


Learn Excel 2010 - "Holiday Gift Labels": Podcast #1494

0000-00-00
Length: 2s

MrExcel on Word for The Holidays!?

Running short of gift tag labels? They are available for Free, inside Microsoft Word 2007 or newer. Today, in Episode #1494, Bill "MrExcel" Jelen reminds you of the Office Online Te…

x

Share: Learn Excel 2010 - "Holiday Gift Labels": Podcast #1494


Learn Excel from MrExcel Video Podcast

Learn Excel from Bill Jelen with this daily 2 minute video podcast!

Learn Excel from MrExcel Video Podcast


Switch to our mobile site