3 things we’re covering today:

• The Pivot Table revolution 💪
• How to generate complex reports with 1 click 🤯
• Use Dynamic Arrays to get your Power Query data

🎬 Create Pivot Tables Like NEVER Seen Before!​

​

Exciting news! Excel Pivot Tables just got a major upgrade, and I cover it all in my latest video.

You can now include images in Excel PivotTables. But that's not all.

In the video I also show you how to make PivotTables more visually appealing using Excel data types like stocks, currencies, and geography. Plus, you can insert custom data types.

This means you get clickable cards for some fields, with more information condensed INSIDE the card. It's a game-changer for organizing and presenting data effectively.

The possibilities are endless:

1. Compress competitor data into data types and add them to your pivots.
2. Enhance competitor analysis reports by adding company logos.
3. Impress clients by including their logos in your reports.
4. Make your product analysis more engaging with images.

​Watch the video now and unlock the full potential of Excel Pivot Tables!

🦓 Zebra BI - Unlock the Power of Data Visualization​

I’ve been really impressed with Zebra BI.

My team and I had a meeting with them last week and they presented their chart add-in for Excel and PowerPoint. I was skeptical at the beginning because I’m quite picky with templates: They usually have too many restrictions, I waste a lot of time trying to overcome them and then I end up creating the charts from scratch.

But 10 minutes into the meeting I realized this tool is different. Every time we asked them “but can it also do this?” or “what if my data is like that?” - they would show us the solution with just a few clicks. Everything had been accounted for. You get to create stunning reports without the hassle of designing them yourself.

They have dozens of premade templates for Excel and PowerPoint. You can easily create IBCS-compliant charts with integrated comments, variance and custom calculations. All giving you additional context & explanations of your data.

Use THIS LINK to get a bundle of my favorite Zebra BI templates for FREE. 💚

🤓 Geeky News

📊 Excel - Get Power Query Data from Dynamic Arrays (rolled out to Office current channel)

You can now get your data in Excel Power Query from Dynamic Arrays ranges, which means you can send the result of your FILTER or UNIQUE functions to Power Query! This gives you a third way of sending Excel data from your current workbook into Power Query (the other two are via tables and named ranges).

📋 Microsoft Forms - Save and Edit Survey Responses
​Sometimes, you need to review and change your answers to a form or survey after submission. Microsoft Forms has you covered - you can now review and edit your responses, so long as the form creator enabled "Allow respondents to save their responses”.

🤖 Bing AI - Voice Chat on Desktop
​Bing chat now lets you ask questions on desktop using just your voice. And it’ll respond with its own voice! This should speed up your AI workflows.

🚀 Power Stories

Thank you to Catharina for this lovely review of my new Automate with Power Query course! We worked really hard on it, so this means a lot 💚

Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇

See you next week,

Leila

Want more?

▶️ Subscribe on YouTube​

🖇️ Follow me on LinkedIn​

🥇 Join 400,000+ students in our courses​

📣 Want to sponsor XelPlus Weekly? Get in touch here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run XelPlus Weekly and bring you updates like this. Thank you for your support!

​