Excel Office Scripts are the future of automation for Excel and other Office apps, replacing VBA and macros going forward. In this video I use ChatGPT to write an Office Script for me and the results are impressive!
⬇️DOWNLOAD the example file & Office Script here: myonlinetraininghub.com/write-excel-office-scripts-with-chatgpt
📜OFFICE SCRIPTS LICENSING REQUIREMENTS
Office Scripts is available to Excel users with the following:
1. Excel for Windows (version 2210 or higher), Excel for Mac, or Excel on the web.
2. OneDrive for Business.
3. Any commercial or educational Microsoft 365 license with access to the Microsoft 365 Office desktop apps, such as:
• Office 365 Business or Business Premium
• Office 365 ProPlus or ProPlus for Devices
• Office 365 Enterprise E3 or E5
• Office 365 A3 or A5
4. Internet connectivity with connected experiences enabled.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy/
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 What are Office Scripts
0:52 Where to find Excel Script Tools
1:24 The Scenario
1:49 Using ChatGPT to write Office Scripts
3:07 Using the Script form ChatGPT
3:42 Running the Script
4:08 Handling Errors in ChatGPT Scripts
4:38 Re-using Scripts you Create
5:04 Assigning the Script to a Button
- No More VBA. ChatGPT to automates boring work with Office Scripts ( Download)
- How to use Office Scripts and Power Automate to do Boring Excel Tasks for You ( Download)
- Do You Need to SWITCH from Excel VBA Macros to Office Scripts ( Download)
- ChatGPT: Automating Excel with VBA like never before 🤯 ( Download)
- Automate Excel with Office Scripts and Power Automate ( Download)
- Automate Tasks in Microsoft Excel with Office Scripts ( Download)
- Despite VBA’s impressive longevity, a new kid has recently arrived on the block: Office Scripts… ( Download)
- Say Goodbye to Boring Excel Tasks: Create Cool Buttons to Run Office Scripts from ANYWHERE ( Download)
- How To Use ChatGPT and Excel VBA to Automate BORING Office Tasks ( Download)
- Automating Excel VBA with Chat GPT: VBA Macro Coding Made Easy | Episode 07 ( Download)
- Run VBA routines from Office Scripts ( Download)
- ChatGPT and Excel AUTOMATION - No more BORING Tasks! #shorts ( Download)
- Introduction to Office Scripts & How to Tweak Macros to Automate Tasks in Excel ( Download)
- Excel + ChatGPT - Center Across Selection Shortcut Macro! ( Download)
- 👩💻 How to use Office Scripts in Excel & Power Automate ( Download)
