MrExcel Excel Videos

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

Rob asks for tips on entering Nested IF functions in Excel. Today's episode shows how to use the Function Arguments dialog box to assist. Check out this link to a video that shows how to use the Name box for the second IF:

Haizen has to arrange transport for N employees where N can be 1 to 500. There are three types of vehicles available with different capacity and different cost. He wants a formula for the lowest cost combination of vehicles for any number N passengers. This long episode walks through exploring a brute-force method, then moving to Solver, then using VBA with Solver to solve for all 476 non-trivial cases. Since the video is fairly long, jump to any part of the video: Table of Contents (0:00) Welcome to Use Solver with VBA in Excel (0:15) Defining the Problem - Transport N employees using lowest cost combination of cars, vans, and bus (0:50) Filling numbers from 1 to 500 using Fill Series Dialog (1:38) Using formulas to figure out total...

It was the Saturday before Thanksgiving in 1998 when I opened Notepad and launched the first tip of the week at MrExcel.com. Using the Wayback Machine, see how the tip for converting daily dates to months holds up 15 years later.