From the address, in a Data Set, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen compare methods of extracting only the 'State' from each entry. Episode #1276 looks at VBA and Functions to accomplish this task.

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen.

Find yourself bored with the same old column or bar charts? Why not replace the column/bar with a shape - perhaps an Arrow? Its easy to do and in Episode #1275, Bill shows you how in Excel 2010!

...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", 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.

Tweet

Patricia asks how to mark the last record in each category. Episode #1274 shows you how to use 'old-school' Conditional Formatting formulas to solve the problem. So, what do a Database, an Absolute Column Reference and a Relative Cell Reference have in common? Find out in Episode #1274!

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! 

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Today, in Episode #1273, Bill begins a series on Charts and Graphs from his new book, "Charts And Graphs: Microsoft Excel 2010". In today's episode Bill explores changing the Series Order of a chart and a few available tools of the Charting Tab of Excel 2010.

...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", 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.

Tweet

Kim has designed a simple data entry spreadsheet and would like to have a way to paste the form entry data into the next empty row of a database worksheet she has created. In Episode #1272, MrExcel delivers a look at how to finesse the macro recorder to solve this problem along with a few Excel keyboard shortcuts.

…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! 

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

In today's dueling Excel podcast, Mike and Bill compare formulas when you have to do a lookup that matches two values in two columns.

* Also note that this Podcast contains information for an upcoming "Live" Dueling Webinar with Mike 'Excel Is Fun' Girvin and Bill 'MrExcel' Jelen!! *

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen.

 Tweet

Collaborate on your Excel worksheets using the Excel Web Application. Today Bill uses Episode #1270 to show you the finer points of the Excel Web App in Excel 2010.

...This episode is the video podcast companion to the book, "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.

Jim from California is trying to organize his kid's home chores list. He was trying to mark the current weekday's chores with conditional formatting and a cell that contained =NOW(). In Episode 1269, Bill shows us a method to solve this problem.

…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Excel 2007 introduced 'Page Layout View' and it has carried over to Excel 2010 - perhaps you haven't seen it yet? In Episode #1268, Bill demonstrates the attributes of Page Layout View in Excel 2010.

...This episode is the video podcast companion to the book, "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.

Tweet

In this week's dueling Excel podcast (Episode #1267), Mike and Bill take a look at formulas to perform a lookup that requires two key values to be found and displayed.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
AND
"Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

Ray asks how to use Conditional Formatting to compare two worksheets. This feature is "new" in Excel 2010 - compare two sheets using Conditional Formatting. Today, in Episode #1266, Bill shows you how to work with this new feature.

…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

With Episode #1265 of the MrExcel Podcast, Bill takes us on a tour of the Excel 2010 File Menu. In this review of the Backstage View, Bill touches on 'Out Commands' and a few pros and cons of the Excel 2010 File menu.

This episode is the video podcast companion to the book, "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" 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.

Today, in Episode #1264, Bill shows us how to add Subtotals to an Excel Data Set and then copy only the Subtotal rows.

...This episode is the video podcast companion to the book, "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.

Tweet

Ron asks how to count 'how many times each model occurs in a column'. Today, in Episode 1263, Bill uses a Pivot Table to quickly solve the problem and display results.

…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Rick from Alabama sends in today's question: "How can I join two date cells into a single cell?"
While Excel initially won't cooperate, Episode 1262 shows the function that you can use to answer this question.

…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet