What you'll learn

This course will teach you how to automate and streamline everyday Excel tasks using Office Scripts.  In this course, Automate Microsoft Excel with Office Scripts, you’ll gain the ability to create, edit, and run TypeScript-based scripts that automate essential and repeatable Excel workflows. First, you’ll explore Office Scripts fundamentals, including licensing considerations, script recording, and editing scripts using the Code Editor. Next, you’ll discover how to write basic scripts to work with workbooks, worksheets, ranges, and tables, and how to run and validate scripts in Excel. Finally, you’ll learn how to build practical automation workflows using control flow, reusable functions, error handling, plus effective script storage and versioning strategies. When you’re finished with this course, you’ll have the skills and knowledge needed to design, manage, and troubleshoot Office Scripts that improve efficiency, consistency, and productivity in Microsoft Excel.