FC2Video

Today's question takes us back to Excel 2003. Teresa asks how to do a COUNTIF with 2 conditions in Excel 2003. Today, in Episode #1423, Bill attempts to provide an easy explanation of how SUMPRODUCT actually works. "Learn Excel from MrExcel!"

Today in Episode #1422, a call to Excel-lers! What is the craziest newbie Excel question you've ever heard - or asked!? Send in your questions for a chance to win a prize.

Today, with Learn Excel Episode #1420, Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin create methods to search for and match records in a Workbook. Learn inherent functions of Excel as well as Custom Methods. Learn Excel 2010 from MrExcel!

Ricardo has a chart and wants to show the monthly label for every third month. This leaves a big gap at the end. Today, in Episode #1419, Bill shows us a workaround solution for this problem.

A VLOOKUP to convert State Codes to State Names all in an Array Formula - and no backward compatibility! Today, in Episode #1418, Bill shows us how to get this issue fixed along with a brief, but informative look at a few ways to work with VLOOKUP.

In Episode #1411, Bill showed us how to use Pivot Table Slicers to display images. Today, in Episode #1417, Bill shows us how to set up the Dynamic Images in Excel Using Paste Picture Link with an OFFSET named range.

Last week, in Episode #1411, Bill Challenged the audience to figure out how he was using the Pivot Table Slicer to update images in a Workbook. Today, with Episode #1416, we learn how to employ this technique. Learn Excel 2010 from MrExcel

Adam liked my Filter/Sort by color trick on the recent CFO Magazine webcast. He asks if there is any way to sum by color. In Episode #1415, Bill shows us a macro to do this. "Learn Excel 2007 through Excel 2010 From MrExcel" - by Bill Jelen.

Today, Nick asks how to get the word 'August' in cell B1 from a date in cell A1. In Episode #1414, Bill shows us how to convert a date to a month name or to a weekday name using the TEXT function.

Shawn has to do a four-way lookup: Worksheet, Row, Set of Columns, Column within the Set. To get the correct LOOKUP result, Bill shows a method using INDEX and INDIRECT to solve the problem posed in Episode #1413. Learn Excel 2010 by Bill Jelen

David gets data from SAP that he loads into Excel. Some part numbers in the import data just happen to look like dates and end up being converted to dates by Excel. Today, in Episode #1412, Bill discusses two ways to solve this problem.

Bill returns from a writing hiatus with a new book, one less car, and a good story to tell. Also, how is he using that pivot table slicer to show pictures on a screen? Figure it out and you can win the new book.

I have some writing to get done, so I won't be in the office again until July 11, 2011. The podcast is going on hiatus until then." - Bill Jelen a.k.a. "MrExcel" MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today, in Episode #1409, Bill shows us how to use Data from the Chart itself to Create a Dynamic Chart Title and Mike shows us two (2) variations on the theme. Also, learn a few Shortcuts and a few tips on navigating the Excel 2010 User Interface.

This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data.

This is the third of a Four (4) Part series on the Basics of Charting. We have our Data Set and our Chart created...Today, in Episode #1407, Bill will show us how to change our Chart Scale or Chart Axis settings in Excel.

This is the second of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Yesterday, we set up our Data Set. Today, in Episode #1406, Bill begins creating the Chart. “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen

The Basics of Excel Charting: Part I Today, in Episode #1405, Bill will begin by taking just words in a Word Document, to create a Data Set - the Data Set will become our Chart in Excel. “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen

Another Dueling Excel Podcast with Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen. Today, in Episode #1404, Mike and Bill look at finding the Percent of the Parent Row Total in Excel 2003 to 2010 using Formulas and/or PowerPivot.

The May 2011 MrExcel Challenge of the Month invites you to mash up some data from the Azure Data Market. This episode of the MrExcel Podcast demos getting data from ADM. For more info about the May 2011 Challenge, visit http://bit.ly/mPrDvX

Today, in Episode #1402, Bill takes a look at Calculating a Weighted Average using two (2) SUMIF Functions. This Formula will need to reference Data on another worksheet as well. Learn about "SUMIF"! **The Learn Excel from MrExcel Podcast Series.**

Warren from Australia writes about choosing Lotto numbers, but =RANDBETWEEN(1,45) is giving him duplicates. Today, in Episode #1401, Bill shows us another way to solve the problem and further eliminate the probability of duplicates. "Learn Excel"

Today, In Episode #1400, Bill reviews "Change-Pro for Excel", by Litéra. This high-end tool will locate all of the changes between two versions of the same workbook. Follow along with Bill to see it work!

In Part I of "Top 2 by Industry", Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen showed us how to get the result. Today, in Episode #1399, Mike and Bill revisit the Top 2 method to compare formula methods.

Want to let others know that your Chart Data is current? Add a Live Title to that Chart to show that the Chart represents Data through the current date. In Episode #1398, Bill shows us how this is accomplished. …Learn Excel 97-2007 from MrExcel.

Most people know how to make a column wider...simple, right? But what happens when someone has turned off column headers-what can I do? Today, in Episode #1397, Bill shows us what to do while discussing a variety of column width adjustment methods.

The question: "Why won't VLOOKUP add up all the matching results?" Today, Episode #1396 will show us how to use the SUMIF function instead of VLOOKUP. Included in today's episode... "Why it is important to lock the rows in your VLOOKUP table range."

Alex asks how to identify the top 2 amounts by industry. Today, in Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen show us how its done.

Wayne from Kentucky points out that you can quickly adjust Column Widths using the Paste Special Column Widths tool. He laments that there is not a tool for copying Row Heights. In Episode #1393, Bill shows us how to copy Row Heights as well.

Using Excel VBA create a macro to add a red font color automatically after editing a cell. In Episode #1392, Bill shows us three techniques for formatting our data.

Kelly wants to display a Range in a Pivot Table. Unfortunately, Calculated Fields in a Pivot Table look at each individual row, so the MAX(B2)-MIN(B2) will always be zero. PowerPivot and the DAX Measure come to the rescue in Episode #1390.

Today, in Episode #1389, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen show us how to make Navigating a Workbook easier using both manual and coded means to create a TOC. Learn a few shortcuts, learn a little VBA and see how easy all of it is!

Episode #1388 comes from contacts on Facebook: A Two condition formula to check if a date is today...another way to select a hyperlink cell without activating the hyperlink...why boolean formulas sometimes return 0 or 1 instead of False or True.

Today, in Episode #1387, Bill H. asks, "How do I change a date/time field from midnight to 6PM?" Excel stores time values as a Fractional portion of a day [where a day is = to 1], so MrExcel shows us how to change our time values using Paste Special.

I showed this a long time ago on an episode of TechTV. The VBA code that I used in Excel 2003 to add the pop-up pictures no longer works in Excel 2010. Today, with Episode #1386, Bill shows us how to update the code for use in Microsoft Excel 2010.

Lon liked the User Defined Function from Episode #1375. He tried to move it to the Personal Macro Workbook and it quit working. There are two workarounds. Today, in Episode #1385, Bill will show us how to create a personal add-in for your UDF's.

"Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?". Using the set up from Episode #1379, today's Duel adds Dynamic Validation and Dynamic VLOOKUP using OFFSET or INDEX. Let Mike and Bill show us how it's done!

Chris R writes in today to ask "Why does Excel sometimes automatically perform Text to Columns when pasting data from another application. In Episode #1383 Bill will explain under what conditions this will happen and how to turn it off or on.

Mike is looking for a faster way to Find. He wants to enter his search term in a Named Cell and have a Macro that will search for that term. Today, in Episode #1382, Bill shows us how to Record a Macro and edit that Macro to do the job we need done.

Episode #1381, Michael asks, "How can I group a Pivot Table up to Quarter Hours?" There is no ideal way to do this in the Pivot Table or in PowerPivot. Bill shows us how to add a Formula to the original Data Set to solve the problem. Learn Excel!

In Episode #1380, Bill looks at =RANK. Excel 2010 makes it easy to Rank a Column in a Pivot Table. Although...the way that Pivot Tables handle ties is different than how the RANK function handles ties. Watch the podcast and learn a bit about =RANK.

Today's Dueling Podcast asks: "Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?" In Episode #1379, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at using Table Nomenclature in Validation and in VLOOKUP.

The Excel Web App now offers a cool little trick that regular Excel can't do; you can embed a portion of your spreadsheet in a blog or other web page. Here is a challenge to try it out.

Jordan from MinusDesign asks "How can I mix two icon sets in the same range?" Jordan wants to combined the green, yellow, red traffic lights with the pink, grey, and black traffic lights. I refer to a 2006 blog post by David Gainer to solve this one.

For today's podcast, Tyler asks the easiest way to produce a report that contains the top 3 values for the most popular names - per each letter of the alphabet in alpha order. In Episode #1376, Bill shows us one method for solving the problem.

Today, in Episode #1375, Why doesn't the =CONCATENATE function accept a range? Why can't you specify a separator character? It is not that hard. Today's episode shows a simple macro using a defined function that would solve the problem.

Thomas asks if there is a better way to calculate Hours Worked. Thomas' data is imported from a web application, as Text. Today, in Episode #1374, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen try alternate formulas to solve the problem.

Hyperlink haters Episode #1371 is for you! I cover the following topics: Deleting one hyperlink; Deleting a range of hyperlinks with Excel 2010 new features; Deleting all hyperlinks with a 1-line macro; How to stop Excel from creating the hyperlinks.

Dave R shared a great hyperlink tip with Bill. Today, in Episode #1370, Build a Hyperlink with an email address; Use the =HYPERLINK Function, Concatenate your information and then click the link! It's simple and Bill shows us how to do it.

Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. in Excel 2010 and earlier versions of Excel. Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.