MrExcel Excel Videos

ModelOff Finalist Vlad Smirnov works for a bank and is setting up reserves for outstanding debt based on risk class. But, there are some months where the pivot table does not include all risk classes. Since the SUMPRODUCT formulas are counting on all risk classes being there, Vlad shows how to force the pivot table to always show each risk class for each month.

In this video with a ModelOff finalist, Dublin's Paul Kehoe shows us an annoying problem with hyperlinks that break when you change the sheet name and an easy workaround. The video then shows how to select a hyperlink cell without following the hyperlink, and how you can easily create a "Back to Menu" across many worksheets.

In today's podcast, another guest post by Bob Umlas. First, Bob talks about a problem with multi-line formulas in the Formula Bar and suggests that Microsoft needs to solve the problem. Next, an easy way to unwind multiple lines created in one cell using Alt+Enter. To read more about Bob's book: Excel Outside the Box

At the ModelOff Financial Modeling Championships, I captured some live podcasts with the finalists. Mack Wilk from episode 1616 and 1617 is back this year with a cool trick for elasticity in 3D Spearing formulas in Excel.

Santa Monica Excel Consultant Szilvia Juhasz belts out this Power Pivot / Excel version of Santa Baby. Follow Szilvia on Twitter @Xszil Lyrics by Szilvia Juhasz: Santa baby! Some Power BI apps on the tree... for me! Designing dashboards all year... Santa baby! So hurry down the chimney tonight! Santa baby! An outer-space relational dah-tah-base! In the 3rd normal form, Santa baby! I'll speak to you... in SQL tonight!... Then up in the cloud, we'll go for a ride...! We'll take a crazy tour of Office three six five! Meet me after Power Pivot school... for some calculated measures by my swimming pool! Santa baby! An Excel cabaret on a yacht! (Why not??) I'll let you click my XY Scatterplot, Santa baby! So pivot down the chimney...

8 year old Excel is Funner joins Mike and I to show us some math tricks in Excel!

Chess Move at YouTube asks how to search for 423 and count all cells that contain those three digits in any sequence. This episode of the Learn Excel podcast shows how to use a helper column to sort the three digits in sequence.

You need to fill the 15th & last of the month. Excel MVP Bob Umlas shows you a trick from his book, Excel Outside the Box. For more information on his book, see: Excel Outside the Box

To buy Bob's book: Excel Outside the Box Today, a guest appearance by Excel MVP Bob Umlas. Say you have random chunks of data and need to add a total to each chunk. Bob shows off a clever VBA solution that adds the totals in almost one line of code. Bob is the author of Excel Outside the Box. If you want to solve this problem without using VBA, see Kevin Lehrbass's video at