Create Pivot Tables Like NEVER Seen Before! (include images and data types)

Discover how to add images and use data types in Excel PivotTables in this tutorial. Perfect for visually enhancing your Excel reports, this guide is a must-watch for anyone looking to elevate their data presentation skills. Here's what you'll learn:

🖼️ Adding Images to PivotTables
▪️ Learn how to insert images directly into Excel cells using the new 'Place in Cell' feature.
▪️ See how images can be included in PivotTables, with the ability to adjust their size for better visualization.

🌍 Incorporating Data Types in PivotTables
▪️ Understand how to convert data to geographical data types, offering rich information about countries right in Excel.
▪️ Discover how to add flags and other country-specific details to your PivotTables for a more informative report.

Excel Pivot Tables just got a major upgrade: You can now include IMAGES in Excel PivotTables!
I'll also show you how you can make PivotTables more visually appealing by integrating Excel data types like stocks, currencies and geography. I'll also show you how you can even insert your own custom data types.

Availability: Microsoft 365 currently only in Beta Insiders channel.

00:00 How to Use Images and Data Types in Your Excel PivotTables
01:02 Use Images in Pivot Tables
02:35 Using Data Types in Pivot Tables
06:02 How to Use Custom Data Types in Pivot Tables
08:08 Wrap Up

➡️ Join this channel to get access to perks:

🎬 LINKS to related videos:

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[andrewcharlesmoss]

Very much a welcome addition, this!

With regards to data types, I just remembered they removed Wolfram Data Types on 11 June 2023.

[prachidugal]

Excel seems so easy when you teach it step by step

[johnwilson]

Fantastic video! Can’t wait to the view the one on custom data types. Thank you

[maricelascinas]

wow this is exactly we need for our project, thanks a lot for sharing Ms Leila ❤❤❤

[rigobertogarcia]

Wow, awesome Leila. You have left some great ideas that can be turned into others that will give the business potential and a better form of control, in order to increase the efficiency of all its collaborators. Just great.
Thank you very much, Leila, for sharing such valuable information.

[chh]

I don't fly in a jet stream where I need country flags ... but Client logo's might be a clever idea ... rather than displaying a lengthy client name repeatedly.

Which is precisely why "Thursdays With Leila' is always a 'must watch' for me ... ideas ... ideas ... ideas!!! ... 🤔 ... 💡💡💡💡

😍😍😍😍 ... thank you ... thank you ... thank you ...

[Zoe-dmch]

This can be a life saver!👏🏼👏🏼👏🏼 My colleague just requested sth similar…will try when back in the office!🎊🎊🎊

[merwynfernandes]

Excellent. Thanks for keeping us updated with the new features.

[garys]

Thank you for this video. I have traveling and this was one of the first things I looked at. I always enjoy and learn something from your videos. I can't wait until it rolls out to me.

[vijayarjunwadkar]

That's amazing Leila! Really can't wait to have this soon, and as usual you did what you EXCEL at; your way of explaining in the most simple yet effective manner! No wonder, you won an award at Global Excel Summit for all your great work! Keep growing!🙂

[TurnToData]

This was brilliant! Kudos for putting in all the efforts. Thanks

[sarmadpirzada]

Wow Awesome thanks for updating us for new and updating formulas of Excel

[patrickbullesbach]

Thank god this feature is finally coming to excel.

[AndreaUK]

Let me know what I think???? Well, my jaw has dropped on the floor with rest of my brain to start with! Sorry I need to replay this again!!! Tell ya all later!! Ow! Yeah You’re magical!!!

[iditenahui]

This is super helpful and useful as well! Thank you!

[Klarkooi]

Hey Leila, thanks for all the tips! I am wondering do you have a video to show a simple scenario, when we create a pivot table, we want to attach additional columns of info from our original data sheet as companion info without making those data as computational (as we don't need it) or it will just expand into so many columns that is not useful. Appreciate your kind advice as run into such common needs very often. Now i need to use V/Xlookup to map the data column manually to maintain my overall readability of my pivoted details. Thanks~!

[md.mahmudulalamsymon]

Wow!!
Thanks a lot for sharing these nice tricks!

[abdulsaidmkamara]

Excellent video Leila

I will add lot of value with custom DATA TYPES 😀 🎉

[Birthdaysex]

Holy shit, I was just thinking about this yesterday!

[chrism]

So cool, thanks Leila. Can't wait to get this feature!