MrExcel Excel Videos

Today, we have a database of date/time data. You don't care about time or even the day of the month - you just want to create a summary of how many records there are by month. This episode of the podcast offers two solutions - an array formula to count records by month or a pivot table that groups the date information up to month and year.

Today's duel involves evaluating math stored inside a text cell such as "1.35x2MVA+3x1.35MVA". Bill and Mike head off in different directions, with Bill doing a VBA macro to extract the digits from the cell and Mike using an Excel 4 Macro function to EVALUATE. Also - learn why Ctrl+F11 inserts a Macro sheet and how you can use the macro sheet to test your EVALUATE function.

The General number format doesn't get a lot of love in Excel, but it does decide if a decimal point is needed in your numbers. As you had off into Custom Number formats, deciding if a decimal point is needed is somewhat dicey. Luckily, the General steps in to solve the problem in today's Learn Excel Podcast.

Excel is great at formulas, but how do you enter a math equation in Excel? Today's podcast looks at an equation with Square Root, Exponents, Pi, and e that need to be entered in Excel.

Excel has always included a color chooser icon and dropdown for both fill color and font color. In the past, you could open the dropdown to choose a new color, or click the icon to use the previously selected color. Suddenly, you have a new Windows 8 laptop and the behaviour has changed - when you click the icon, it opens the dropdown and forced you to choose the last color again! It turns out that a new default setting on Windows 8 laptops is causing the problem. Learn how to go back to a normal 2-control color chooser.

Bill still has laryngitis, so @TomUrtis offers up a quick tip on how to get help on that Excel function you are entering.

You have a product category in A and then 6 products in B:G. The goal is to get 7 rows for each category, first with the category name, and then 6 rows concatenating the product name with the subproduct. This Dueling Excel podcast solves the problem with some VBA and with a formula.

Erin from California shows an unusual way to enter VLOOKUP in today's episode. At least, MrExcel thinks it is unusual. Have you ever seen anyone enter their VLOOKUP this way?

Center Across Selection is superior to Merge and Center in every way, but is there a keyboard shortcut to apply Center Across Selection? In this episode of the podcast, we visit the Cell Styles dropdown in Excel to see if it can shorten the keystrokes needed to apply Center Across Selection.