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.
This week, I had the pleasure of speaking at the 49th Controller Congress in Munich - one of Europe's top events for finance leaders and controllers. It was an incredible crowd. Smart. Experienced. People who work with data every day. My session was about AI in Excel. In 40 minutes, we walked through a "day in the life" of a modern data analyst - using the AI features in Excel. When we got to Analyze Data, I asked for a quick show of hands. Who here is using it? Out of more than 400 seasoned...
“Why would I use Python in Excel if it can’t handle external data?” That’s the top complaint I hear. And it’s flat-out wrong. You see, Python people try to use Python code to import the data. That doesn't work. Excel people do copy-paste or load via Power Query into a sheet. That works - but it bloats your file. And if your dataset has more rows than Excel can handle, you're stuck. The solution? Don't load your data into Excel at all. Go from a raw CSV... ...to a clean correlation heatmap in...
You open the file. The formula’s broken. The chart’s gone. Cell colors? A rainbow mess. You don’t know who did it. Doesn’t matter. Excel’s Version History has your back. It quietly keeps snapshots of your file, so you can rewind, review, and restore past versions. Find out what changed, when, and roll back if needed. Fix the mess. No drama. No blame. 👉 Here’s how to use it—fast. (BTW, if you want to create a dashboard like the one on the right - before someone took a sledgehammer to it 🔨 -...