- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Microsoft Excel Programming and Automation
This learning path is actively in production. More content will be added to this page as it gets published and becomes available in the library. Planned content includes: 1. Write Complex Formulas in Microsoft Excel (video course) 2. Record and Manage Macros in Microsoft Excel (video course) 3. Up and Running with VBA in Microsoft Excel (video course) 4. Automate Microsoft Excel with VBA (video course) 5. Automate Microsoft Excel with Power Query (video course) 6. Automate Microsoft Excel with Office Scripts (video course) 7. Work with Data using Python in Microsoft Excel (video course)
Microsoft Excel programming and automation refers to using formulas, macros, VBA, Power Query, Office Scripts, and Python to streamline tasks, apply logic, and extend what Excel can do. This path teaches learners how to build smarter spreadsheets, automate repetitive work, and apply scripting tools within Excel. By completing it, learners can save time, reduce errors, and create more efficient, scalable Excel workflows that go beyond manual data handling and standard spreadsheet features.
Content in this path
Microsoft Excel Programming and Automation
Watch the following course to start learning how to take Excel to the next level with programming and automation.
Try this learning path for free
What You'll Learn
- How to write complex formulas in Excel
- How to record and manage macros in Excel
- How to use VBA to automate Excel
- How to use Power Query to automate Excel
- How to use Office Scripts to automate Excel
- How to work with data in Excel using Python
- Learners interested in this path should be proficient in core Excel features and functionality, including writing formulas, sorting and filtering, and navigation. While prior coding or programming experience is beneficial, it is not required.
- Microsoft Excel
- Microsoft Office
- Data analysis
- Python
- Programming
