- 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
7 Courses
7 Hours
Skill IQ
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
Access this learning path and other
top-rated tech content with a free
trial.
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
Prerequisites
- 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.
Related topics
- Microsoft Excel
- Microsoft Office
- Data analysis
- Python
- Programming
Not sure where to start?
With over 500 assessments to choose from, you can see where your skills
stand and receive adaptive learning recommendations to fill knowledge gaps in as little as 10 minutes.
Learn with the best
