MrExcel Excel Videos

This follow-up video to episode 1505 shows how to automatically create an invoice register as your are using one of the Invoice Templates from Excel.

Fred set up a workbook in Excel 2010 that uses off-sheet Data Validation. Everything works fine in Windows, but the dropdown arrow is not appearing in Excel:mac and presumably not on Excel 97 either. While Excel now allows for Validation to point to another sheet, it never used to do that. Here is the workaround to let your validation dropdowns work on a mac.

Generate 3 sets of the numbers 1-20 with no repeats in any set.

You have a different rate per category, and half of the categories have a Max but the others do not. Mike and Bill offer different options for calculating the rate in Excel.

A question from YouTube about the Excel RATE function not appearing to work. The function does work, but since it returns the rate per period instead of the annual rate, the answer provided by the function might appear to be wrong.

Fred used Data Validation to select a model from the list. Once you select the model, how do you pull all of the field data forward to Sheet1? There are many approaches you could use. Episode 1803 shows how to use MATCH and INDEX.

Szilvia Juhasz guest hosts today's Learn Excel podcast - how to use fun fonts in your Excel dashboards. Thanks to Szilvia for guest hosting.

You have serial numbers like AA10D, AA11D and want to fill to AA12D, AA13D, and so on. The Excel Fill Handle won't do this. Learn how to solve it with a formula.

Create an average by each category that will work before AVERAGEIF came along in Excel 2007. Bill and Mike offer a pivot table, and two different formulas.