Excel 365 - Task Automation for Non-Programmers Using AI

• Solving practical examples and scenarios from real working life
• Basics and principles of Office Scripts in MS Excel environment
• Recording repeated actions using an automatic recorder
• Editing and customizing scripts in the Code Editor environment
• Using AI (LLM) assistants for writing, editing and generating script code
• Automatic manipulation of tables, cell ranges and data
• Working with graphs and formatting reports
• Running and managing created scripts to speed up everyday work

• Microsoft Excel - basic course.

Introduction to Office Scripts

• Difference between VBA and Office Scripts
• Office Scripts environment in MS Excel on the web and in the application
• When and why to choose scripts for automation

Action Recorder and the first script

• Creating a script without writing code using Recorder
• Analyzing the generated script
• Saving, editing and running scripts

Involving AI (LLM) in script creation

• How to correctly enter a request to an AI assistant (Prompting)
• Generating new code using AI without the need to actively control the TypeScript syntax
• Correcting errors and explaining unknown code using AI

Working with data, tables and formatting

• Reading and writing data to cells and ranges
• Automatic cleaning, filtering and sorting of data
• Formatting tables, rows and generating graphs

Practical scenarios from real practice

• Automating a regular monthly/weekly report
• Bulk editing and unifying inconsistent data
• Create your own button tools to speed up your work

Previous courses

Microsoft Excel – Basic Course [MSEX1]