Excel - Santa Baby - Excel / Power Pivot Version - Episode 1835A

4,700 views · Published 13 December 2013 · 3:13 · Indexed 22 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial - Santa Baby - Excel / Power Pivot Version.

Welcome to the Excel and Power Pivot version of the classic holiday song, "Santa Baby"! In this festive video, we'll be singing about all things Excel and Power Pivot, from designing dashboards to using SQL and DAX formulas. So grab your Santa hat and get ready to learn some Excel tips and tricks while spreading some holiday cheer!

We'll start off by asking Santa for some Power BI apps on the tree, because what's better than a Christmas tree filled with data visualizations? And while we're at it, we'll also ask for an outer-space, relational database in the 3rd normal form. Because who doesn't love a well-organized database, am I right?

But let's not forget about the fun stuff too! We'll be taking a crazy tour of Office 365 and even meeting up after Power Pivot school for some calculated measures by the swimming pool. And for all you Excel lovers out there, Santa will be bringing us an Excel cabaret on a yacht. Yes, you heard that right. We'll be clicking xy scatter plots and pivoting down the chimney in style.

But it's not all about Excel, we'll also be speaking some Spanish and making DAX formulas with Santa Papi. And let's not forget about the MVP award from Microsoft, because who wouldn't want to hook up with some more chicks at Club XL? So join me, Bill Jelen, and let's spread some holiday cheer with Excel and Power Pivot. Happy holidays and Merry Christmas to all!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Santa Baby! 
(00:31) Outer-Space Database 
(00:44) SQL and the Cloud 
(01:11) Excel Cabaret 
(01:31) Let's Make DAX 
(01:51) Santa Boss-Man 
(02:10) MrExcel and the MVP Award 
(02:42) Club XL 
(02:52) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
3rd normal form database
Calculated measures in power bi
DAX formulas
Designing dashboards with power bi
Excel cabaret on a yacht
Office 365 tour
Outer-space relational database
Power pivot school
Santa baby power bi apps
SQL for data analysis
SUMX and VLOOKUP functions in Excel
XY scatter plot in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153660/

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

Santi papi! Let's vamos a quitar la noche... & we'll make DAX ;)
We'll formulate the MINX() and the MAXX(), oh Santa baby!
I'll hookup that VLOOKUP tonight!

Santa boss-man!
Just fill my stocking with some SUMX() and checks!
Sign Steve B. on the line, Santa baby!
I think he can afford it tonight!

Now that MrExcel - he's all the rage!
I flipped the day he finally liked my Twitter page
He even wrote about me in his book!
Power Pivot for the Data Analyst (take a look... page 57)

Santa baby! About that Microsoft MVP award...
ya think it's time to hook up some more chicks, baby??
cuz Club XL's got plenty o' guys!
So hurry down the chimney tonight (that's right)
Meet me at the Sky Drive... To-nite!!!!!!!

More from this channel