3 things we’re covering today:
My latest video is all about how to use ChatGPT in smarter, more efficient ways!
Here’s a quick overview of each tip.
I love Shortform’s super-detailed book guides.
But now they're taking things to another level with the recent release of Shortform AI!
It’s game-changing browser extension that generates detailed summaries of blogs, articles, emails (and even YouTube videos) in a single click.
Add the extension to your browser, and you’ll be able to:
Even better, Shortform AI is included with Shortform's premium service at no extra cost!
Sign up here for a free trial at http://shortform.com/leila. XelPlus Weekly readers also get 25% off the annual subscription - that’s equivalent to 3 free months!
Thank you to Shortform for sponsoring today's newsletter. 😊
✈️ Copilot - A Major Update from Microsoft
Microsoft made a series of announcements and outlined their vision for their AI companion tool Copilot on Thursday.
Copilot will begin rollout to Windows 11 starting September 26th 2023. It will be a part of every app (including paint, photos, etc), and will include over 150 new features!
Here are some of the key changes:
📊 Excel - Introducing the Python Editor from Excel Labs
Excel Labs has a new addition - Python Editor! It’s a dedicated code editor that lets you write and edit Python formulas in Excel!
It provides a dedicated code editor (similar to Python notebook environments), offering benefits like:
To access it, update the Excel Labs add-in or install it from the Add-ins Store, and then launch the Python Editor.
🤪 Create Animated Stickers From Live Photos on Your iPhone
Want to torment your friends and family with animated stickers on WhatsApp?
Look no further than this fun Howtogeek article, which shows you how to take a Live Photo with your iPhone and send it as a sticker on WhatsApp:
I’m thrilled to have Veronica be a part of our XelPlus community!
Congratulations on completing our Automate with Power Query course Veronica. Sounds like amazing things lie ahead in your career!
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!
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 🔨 -...