Path icon Learning Paths
Skills

Microsoft Excel Programming

  • Number of Courses8 courses
  • Duration10 hours
  • Skill IQ available Skill IQ

Microsoft Excel offers several powerful programming features you can use to automate mundane tasks and enrich your spreadsheets with custom logic and behavior. This skill will teach you to leverage the Visual Basic for Applications programming language inside of Excel, as well as using built-in Excel functions to perform data lookups, calculations, and logical comparisons.

Courses in this path

Beginner

Learn to record, playback, and edit your Excel activities using macros.

Recording and Managing Excel 2016 Macros

  • by Pratheerth Padman
  • 31m Duration
  •  (292)

Intermediate

Learn to apply logical, statistical, data, and lookup operations inside of Excel functions.

Excel Logic Function Playbook

  • by Craig Golightly
  • 36m Duration

Excel Statistics and Finance Function Playbook

  • by Craig Golightly
  • 1h 25m Duration

Excel 2016 Data Lookup Function Playbook

  • by Pratheerth Padman
  • 34m Duration
  •  (212)

Excel 2016 Time and Date Function Playbook

  • by Pratheerth Padman
  • 53m Duration
  •  (34)

Advanced

Troubleshoot your formulas, and build rich applications around your data using Excel's Visual Basic for Applications.

Troubleshooting Excel Formulas

  • by Amruta Mahajan
  • 1h 25m Duration
  •  (25)

Building Your First VBA Module

  • by Mike McQuillan
  • 1h 58m Duration
  •  (16)

Developing for Excel with VBA

  • by Mike McQuillan
  • 2h 37m Duration

Learn with the best

Pratheerth Padman
Pratheerth Padman
Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.
Craig Golightly
Craig Golightly
Craig is passionate about solving problems with the right tools. He has over 20 years of software development experience with large enterprises and small startups on everything from search engines to fighter jets. He has a bachelor's and master's degree in computer science with extensive experience in AWS, microservices, and artificial intelligence. Craig enjoys teaching and mentoring others so they can save time and accomplish their goals faster.
Amruta Mahajan
Amruta Mahajan
Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work... more
Mike McQuillan
Mike McQuillan
Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he's working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doe... more

Join our learners and upskill
in leading technologies