MrExcel Excel Videos

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

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.

View full article »

Learn Excel - VBA Picture Comments: Podcast #1386

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.

View full article »

Learn Excel - UDF in Personal Workbook: Podcast #1385

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.

View full article »

Dueling Excel - Dynamic OFFSET or INDEX?: #1384

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

View full article »

Learn Excel - Stop Auto-Text To Columns: #1383

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.

View full article »

Learn Excel - Macro to Find: Podcast #1382

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.

View full article »

Learn Excel - Quarter Hours: Podcast #1381

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!

View full article »

Learn Excel - Rank Rank: Podcast #1380

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.

View full article »

Dueling Excel - Dynamic Validation VLOOKUP: #1379

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.

View full article »