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.
🦾 I Built ChatGPT Into Excel…
Hi there,
By now we all know that ChatGPT can solve (some) complicated Excel problems. And it’s even better at generating dummy data.
But I wanted to take things further, and actually bring ChatGPT inside Excel. I had three main reasons for doing this:
1. Reduce Hassle - I didn’t want to constantly leave Excel and go to ChatGPT to copy/paste data.
2. Reliable Access - ChatGPT is often ‘at capacity’, but I knew I’d get guaranteed access by using OpenAI’s API.
3. Excel-Specific - I wanted GPT to give its answers in multiple rows if needed, not just in one cell.
Sounds challenging to build, right? Well, I also asked GPT if it could build this system for me (or at least, help out 😉).
And it worked!
My setup had 2 ingredients: an Office Script written in Typescript (here’s my code on GitHub), which connected to OpenAI’s API for GPT.
After some troubleshooting, I could ask questions in one cell, Office Scripts would automatically send the query to GPT via the API… and I’d get my answer in the cell below. 🚀
I included some code to check if the answer had more than one line.
If it did, my Office Script would split the answer up, and paste it into several individual lines in a separate ‘Results’ sheet. So no more manual copy/pasting of individual lines.
Having GPT right inside Excel speeds up my workflow a lot.
For example, I can also take a company balance sheet, ask GPT to analyze it for risks, and I’ll get a reasonable second opinion within a few seconds:
But remember – you still need to analyze the data yourself and make your own decisions! AI doesn’t always have the right answers, and we need to use our own common sense.
As Mark Proctor said at the Global Excel Summit:
Want to set up GPT in Excel yourself, or just curious? Check out my latest video, where I give a step-by-step guide on how to do it👇
🤓 Geeky News
🤖 ChatGPT Search - AI-powered Microsoft Bing and Edge.
The new AI-powered Bing search tool looks seriously impressive. It can even create tables based on data it’s extracted from webpages. I’ve signed up for the waiting list – excited to report back.
📝 Word - Transcribe Audio Files in Word?
Never manually transcribe an audio recording again! Word’s new Transcribe feature lets you convert any speech audio file (eg mp3) to text, with each speaker individually separated. Check out my 60-second demo.
👥 Teams - Video Filters in Teams Meetings
Microsoft has rolled out filter effects for Teams. Admittedly, I won’t use these much… But if you like, you can give your presentations more personality, or choose a filter to reflect your company branding.
🧑🏫 PowerPoint - Closed Captions for PowerPoint
You can now add closed captions to your PowerPoint presentations. Just select Playback >Insert Captions to upload your captions file, and viewers will be able to toggle captions on/off by clicking CC at the bottom-right of their screen.
💚 My Favorite Things
🧮 A Fun App - The Calculator Drawer
The Internet Archive just released a collection of 15 emulated old-school calculators that you can boot up and use, just as if you had the physical versions in front of you! Or you could use Excel 🤭
🥊 The Big Debate - Is VBA Dying?
This was the topic of one panel discussion at the Excel Global Summit. Microsoft say they’ll continue to support VBA, but mainly invest in Office Scripts going forward. Security is the first concern – many companies have banned VBA in their offices, as enabling macros could put their networks at risk from viruses.
The second reason is that VBA doesn’t fit with the rapid shift towards web-based applications. Martin Weiẞ made this point, which I think is accurate.
🧑🎨 Art in Excel - George Lungu’s 3D VBA Animations
George blew everybody's mind at the Excel Summit with his 3D animations. Made with maths, physics and good old VBA. Who said Excel isn’t creative!?
🚀 Power Stories
Thank you to Tanya Coetzee for this lovely feedback after she look our Fast Track to PowerBI course. Glad you’re on the right track Tanya! 💚
See you next week,
Leila
Want more?
▶️ Subscribe on YouTube
🖇️ Follow me on LinkedIn
🥇 Join 300,000+ people in our courses
📣 Want to advertise on XelPlus Weekly? Get in touch here.
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.
For years, I did something I'm a little embarrassed to admit now. Every time I needed to present pivot table data, I'd copy it out. Paste it as values into a separate sheet. Then format it manually. My pivot table stayed hidden in the background like a rough draft nobody was allowed to see. Why did I do this? Pivot table default styles are just ugly. Nothing to impress management with. It never occurred to me that the pivot table itself could look like this: Yes. That's a pivot table. Fully...
You have a list of messy text. You need to filter it down to only rows that contain a 4-digit product code. Me in 2004 would have done it manually. Me in 2014 would have used VBA. Me now? Just 60 seconds with one formula. The function is called REGEXTEST. It's relatively new in Excel, and once you see what it does, you'll wonder how you worked without it. 👉 Check out the short video here REGEXTEST tells you if a pattern exists. But there are two sister functions also worth knowing:...
Here's a situation I hear about all the time. Someone leaves. Could be a data analyst, could be the "Excel person" on the team. And whoever's left behind is now responsible for spreadsheets they didn't build and reports they don't fully understand. Someone wrote in from our survey recently, an administrator at a charity. The analyst who set everything up moved on, and now it's her job to keep it all running. She's watching YouTube videos to figure out how to create charts. She's using a pivot...