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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920