Featured resource
2026 Tech Forecast
2026 Tech Forecast

Stay ahead of what’s next in tech with predictions from 1,500+ business leaders, insiders, and Pluralsight Authors.

Get these insights
  • 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

1 Course
1 Hours
Skill IQ

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.

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.

Get started with Pluralsight