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.
My Favorite Pivot Table Hacks 💁♀️
3 things we’re covering today:
- Copilot & Bard Updates 🤖
- Cool Pivot Table Hacks 🥷
- My brand-new Power Query course 🥳
Oh, and apologies if you got 2 versions of this email - we had a technical error!
🎬 Crazy Pivot Table Hacks
In my latest video I share all my secret Excel Pivot Table tips.
These are the ‘hidden’ or lesser-known features turn you into the Pivot Table master of your company 😉
Two of my favorites:
1. The Invisible Pivot Table… 🧐
This lets you use a Pivot Table slicer without actually showing the Pivot Table itself in your workbook, so everything looks nice and clean. Plus you can grab data from other places and show it in the same table. Almost like magic. 🪄
2. Disable View Details ❌
If you’re in a Pivot Table and want to quickly view the details of any fields, you can double-click on a value field to create a separate page with all the details. But this can be annoying - especially if you share the file with colleagues. Here’s how to disable that feature.
🚀 presentaid
Want to work more efficiently in PowerPoint and Excel? In that case, I highly recommend presentaid!
Presentaid helps you create better slides in less time. With this MS Office addin you can create, align, and style your slides and shapes with less clicks than ever before. Sticking to your corporate design with pixel-perfect slides has never been easier.
With their unique feature of providing an interface between Excel and PowerPoint, you can even create entire PowerPoint slides based on your Excel data at the push of a button - fully automated.
Ready to give it a try? Sign up for a free trial at https://landing.presentaid.com/leila and save 33% on your first subscription with coupon code “Leila0523”.
Thank you to presentaid for sponsoring today’s newsletter.
🤓 Geeky News
🌈 Google Bard AI - Public Release
Google just made their ChatGPT competitor Bard AI fully open to the public.
And it works really well!
OpenAI may have had a head start with ChatGPT. But Bard has a stronger dataset, because it can access all of Google’s data: YouTube transcripts, Google Search Index, etc.
This is a big step in the AI arms race.
🤖Microsoft 365 Copilot - Exciting Updates Rolled Out
Microsoft have updated their already very powerful Copilot AI assistant. You can now:
- Get writing coaching in Outlook 📝
- Produce AI ideas and designs in Whiteboard 💡
- Generate DALL-E images inside PowerPoint 🎨
And a lot more!
🌈 Gmail - Will Google Delete Your Old Gmail Account?
Google’s new ‘inactive account’ policy means they’ll delete any account that haven’t been used for two years.
And yes, that includes all emails, documents, Drive storage, and Photos storage associated with the account. So, set a reminder in your calendar to log in every now and then!
The new policy comes into effect on January 1st, 2024.
👥 Teams - New Together Mode
Microsoft has improved the Together mode in Teams by adding reactions, raised hands, and name labels under each user’s image. Now you can tell who’s who, and understand people’s reactions a bit better!
💚 My Favorite Things
💁♀️My New Power Query Course
I’m thrilled to announce that we’re working on a new Power Query Recipe course, set for release in mid-June!
I’ve designed this course to address the common themes and questions that many of you have shared. My current Power Query course is HUGE - you’d have to dedicate lots of time to get through it.
That’s why this recipe course will be the perfect addition. It’ll give practical, immediate solutions to real-world problems (all those Power Query pitfalls 🤦♀️) and even direct you to the right lecture in the main course if you want more background and information.
Registration is set to open at the end of May!
🚀 Power Stories
I got this lovely message from Jeff on LinkedIn, which made my day! 💚
He agreed I could share his success in the newsletter:
I got promoted years back, had to take over a department, and got handed spreadsheets to figure out allocations of 5000+ skus while allocating $millions from vendors over those skus based on run rates…
I had no idea! Many weekends on Google and watching your channel… Fast forward years later, and I hate anyone who tells me I can’t live in excel!
Long winded I know - but wanted to let you know you’re doing great work, and helping people along the way.
- Jeff
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 300,000+ people 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!
Leila Gharani - XelPlus
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.
Since we started unpacking Python in Excel, one theme keeps popping up: “I get that Python's powerful… but what exactly does it do inside Excel?” “And do I really need to learn it?” Fair questions. Especially with all the AI buzz and Copilot updates. So let’s get clear. Python is the same language that powers Instagram algorithms and self-driving cars. But inside Excel, it’s your shortcut to deeper, smarter data analysis: Discover trends Excel charts can’t reveal Run complex forecasting...
You know those annoying problems that waste more time than they should? A report lands in your inbox… but the dates are in some weird format you can't use. You’ve got data in columns that should be flipped to rows. The dataset’s huge. The deadline’s close. And you're still looking for a clear takeaway for your slide. You’ve probably run into one of these. Or all three. And dealing with them? Takes way longer than it should. But what if you could solve each of these in under 30 seconds... with...
✨ Found something new hiding in plain sight. Opened Excel… and nearly missed it. There’s a new Get Data interface rolling out in the Beta channel. Cleaner design, searchable source list, and everything in one place. A small UI change, but a great excuse to revisit one of Excel’s most powerful tools: Power Query. If you're pulling tables from PDFs, scraping web data, combining files from a folder, or just cleaning up messy CSVs... Power Query makes it repeatable, reliable, and refreshable....