XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
3 things we’re covering today:
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:
Watch the video now and unlock the full potential of Excel Pivot Tables!
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. 💚
📊 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.
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
▶️ 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!
Helping you easily overcome data challenges with Excel & Power BI
XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
Thinking VLOOKUP is dead now that we have XLOOKUP? Think again. It's still used across thousands of spreadsheets. It has some limitations, but if you're aware of them and use it correctly, you'll get the job done quickly. Also, this edition of Between the Sheets includes: Power tools making a difference Better technical answers from ChatGPT Solution for tab hoarders If you were forwarded this message, you can get the free weekly email here. 🎬 Master VLOOKUP for effortless reporting In my...
Today, we're diving deeper into Excel's View tab to show you some lesser-known, yet incredibly handy features that will change the way you manage your workbooks. Also in focus: sharing views in Excel for the web AI writing assist in any online text box OneDrive offline capabilities If you were forwarded this message, you can get the free weekly email here. Master the Window options in Excel's View tab A while ago we covered the magic of Freeze Panes. But there are other buttons in the View...
We’re almost done with our New Excel Business Charts Course and it’s looking great! I'm currently reviewing the final videos. Meanwhile, the team is busy finalizing the cheat sheets, lesson notes, and quick guides. This morning, I reviewed the lecture "How to Pick the Right Chart". And wow! It took me right back to my corporate job, staring at the screen, wondering, "How on earth do I make this data tell a story?!". There was SO MUCH to show. Picking the right chart might seem easy, but...