MrExcel Excel Videos

Mrs. Schleuter's seventh grade computer apps class wanted to figure out how many columns there are between A and XFD. In an effort to find the answer and to introduce her students to the Best Excel Resource available, Mrs. Schleuter went to the "MrExcel Message Board"! Today, in Episode #1391, Bill re-introduces the MrExcel Message Board as a source for answers concerning all things Excel - plus an answer as to how to calculate the number of columns between A and XFD!

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.