• For Individuals
  • For Businesses
  • For Universities
  • For Governments
Coursera
  • Online Degrees
  • Careers
  • Log In
  • Join for Free
    Coursera
    • Browse
    • Excel Macros

    Excel Macros Courses Online

    Learn to create Excel macros for automating repetitive tasks. Understand VBA (Visual Basic for Applications) to enhance Excel functionality.

    Skip to search results

    Filter by

    Subject
    Required
     *

    Language
    Required
     *

    The language used throughout the course, in both instruction and assessments.

    Learning Product
    Required
     *

    Build job-relevant skills in under 2 hours with hands-on tutorials.
    Learn from top instructors with graded assignments, videos, and discussion forums.
    Learn a new tool or skill in an interactive, hands-on environment.
    Get in-depth knowledge of a subject by completing a series of courses and projects.
    Earn career credentials from industry leaders that demonstrate your expertise.

    Level
    Required
     *

    Duration
    Required
     *

    Skills
    Required
     *

    Subtitles
    Required
     *

    Educator
    Required
     *

    Explore the Excel Macros Course Catalog

    • Status: Free
      Free
      C

      Coursera Project Network

      Custom & Conditional Formatting in Microsoft Excel

      Skills you'll gain: Data Entry, Spreadsheet Software

      4.3
      Rating, 4.3 out of 5 stars
      ·
      19 reviews

      Intermediate · Guided Project · Less Than 2 Hours

    • Status: Free Trial
      Free Trial
      I

      IBM

      IBM Data Management

      Skills you'll gain: Dashboard, Data Storytelling, Data Warehousing, SQL, Data Governance, Data Security, Data Migration, Database Design, Data Literacy, Descriptive Statistics, Extract, Transform, Load, Data Mining, Cloud Storage, Data Visualization Software, Data Store, IBM DB2, Data Management, Relational Databases, MySQL, Excel Formulas

      4.7
      Rating, 4.7 out of 5 stars
      ·
      17K reviews

      Beginner · Professional Certificate · 3 - 6 Months

    • E

      Erasmus University Rotterdam

      Excel Modeling for Professionals: Best Practices & Pitfalls

      Skills you'll gain: Microsoft Excel, Excel Formulas, Verification And Validation, Financial Modeling, Project Documentation, Business Modeling, Spreadsheet Software, Product Testing, Data Validation, Document Management, Data Integrity, Data Management, Organizational Skills

      4.5
      Rating, 4.5 out of 5 stars
      ·
      34 reviews

      Intermediate · Course · 1 - 4 Weeks

    • Status: Free
      Free
      C

      Coursera Project Network

      Usar fórmulas y funciones básicas en Microsoft Excel

      Skills you'll gain: Excel Formulas, Spreadsheet Software, Microsoft Excel, Microsoft 365, Data Analysis Software, Profit and Loss (P&L) Management

      4.8
      Rating, 4.8 out of 5 stars
      ·
      338 reviews

      Beginner · Guided Project · Less Than 2 Hours

    • Status: Free
      Free
      C

      Coursera Project Network

      Creating a Budget with Microsoft Excel

      Skills you'll gain: Budgeting, Microsoft Excel, Budget Management, Excel Formulas, Spreadsheet Software, Accounting and Finance Software, Financial Data, Microsoft 365

      4.5
      Rating, 4.5 out of 5 stars
      ·
      568 reviews

      Intermediate · Guided Project · Less Than 2 Hours

    • Status: Free Trial
      Free Trial
      I

      IBM

      IBM Data Analytics with Excel and R

      Skills you'll gain: Data Storytelling, Interactive Data Visualization, Shiny (R Package), Data Wrangling, Exploratory Data Analysis, Relational Databases, Big Data, Data Visualization Software, Ggplot2, Database Design, Data Analysis, IBM Cognos Analytics, Statistical Analysis, Data Presentation, Data Mining, Dashboard, Excel Formulas, Data Manipulation, Web Scraping, Microsoft Excel

      Build toward a degree

      4.7
      Rating, 4.7 out of 5 stars
      ·
      28K reviews

      Beginner · Professional Certificate · 3 - 6 Months

    • Status: Free Trial
      Free Trial
      I

      IBM

      IBM Business Intelligence (BI) Analyst

      Skills you'll gain: Dashboard, Data Storytelling, Data Warehousing, SQL, Database Design, MySQL, Presentations, Descriptive Statistics, Extract, Transform, Load, Business Intelligence, IBM DB2, Tableau Software, Relational Databases, Star Schema, Data Visualization Software, Interactive Data Visualization, Regression Analysis, Data-Driven Decision-Making, Excel Formulas, Microsoft Excel

      4.7
      Rating, 4.7 out of 5 stars
      ·
      14K reviews

      Beginner · Professional Certificate · 3 - 6 Months

    • Status: Free Trial
      Free Trial
      I

      IBM

      IBM Business Analyst

      Skills you'll gain: Data Storytelling, Requirements Elicitation, Risk Mitigation, Business Analysis, Business Process Modeling, Risk Analysis, Process Mapping, Process Optimization, Requirements Management, Risk Management, Business Requirements, Stakeholder Management, Work Breakdown Structure, Scope Management, Process Analysis, Stakeholder Engagement, Data Visualization Software, Excel Formulas, Microsoft Excel, Analysis

      4.7
      Rating, 4.7 out of 5 stars
      ·
      13K reviews

      Beginner · Professional Certificate · 3 - 6 Months

    • Status: Free Trial
      Free Trial
      I

      IBM

      IBM Back-end JavaScript Developer

      Skills you'll gain: Istio, HTML and CSS, Node.JS, Containerization, Software Development Life Cycle, Software Architecture, Server Side, MongoDB, Professional Networking, Application Deployment, Cloud-Native Computing, NoSQL, Kubernetes, Restful API, OpenShift, Git (Version Control System), Cloud Applications, GitHub, Serverless Computing, Ajax

      4.6
      Rating, 4.6 out of 5 stars
      ·
      6.9K reviews

      Beginner · Professional Certificate · 3 - 6 Months

    • Status: Free
      Free
      C

      Coursera Project Network

      How to use Custom and Conditional Formatting in Excel

      Skills you'll gain: Microsoft Excel, Spreadsheet Software, Excel Formulas, Data Visualization

      4.6
      Rating, 4.6 out of 5 stars
      ·
      85 reviews

      Intermediate · Guided Project · Less Than 2 Hours

    • Status: Free Trial
      Free Trial
      I

      Intuit

      Intuit Academy Bookkeeping

      Skills you'll gain: Reconciliation, Financial Statements, Financial Statement Analysis, Inventory Accounting, Payroll, Bookkeeping, QuickBooks (Accounting Software), Payroll Administration, Inventory Control, Payroll Processing, Income Statement, Balance Sheet, Depreciation, Fixed Asset, Payroll Tax, Property Accounting, Financial Analysis, Sales Tax, Ledgers (Accounting), Accounting

      4.6
      Rating, 4.6 out of 5 stars
      ·
      7.4K reviews

      Beginner · Professional Certificate · 3 - 6 Months

    • Status: Free
      Free
      C

      Coursera Project Network

      How to Use Lookup Reference Math and Text Functions in Excel

      Skills you'll gain: Spreadsheet Software, Data Validation

      4.4
      Rating, 4.4 out of 5 stars
      ·
      450 reviews

      Intermediate · Guided Project · Less Than 2 Hours

    Excel Macros learners also search

    Python Excel
    Python Machine Learning
    Python for Machine Learning
    Computational Science
    Mathematics for Machine Learning
    MATLAB
    Machine Learning Andrew Ng
    Python Pandas
    1…789…58

    In summary, here are 10 of our most popular excel macros courses

    • Custom & Conditional Formatting in Microsoft Excel: Coursera Project Network
    • IBM Data Management: IBM
    • Excel Modeling for Professionals: Best Practices & Pitfalls: Erasmus University Rotterdam
    • Usar fórmulas y funciones básicas en Microsoft Excel: Coursera Project Network
    • Creating a Budget with Microsoft Excel: Coursera Project Network
    • IBM Data Analytics with Excel and R: IBM
    • IBM Business Intelligence (BI) Analyst: IBM
    • IBM Business Analyst: IBM
    • IBM Back-end JavaScript Developer: IBM
    • How to use Custom and Conditional Formatting in Excel: Coursera Project Network

    Frequently Asked Questions about Excel Macros

    Excel macros are simply a sequence of instructions that you provide in Excel using a given formula, and the program starts to execute those instructions automatically. You can create a macro, for instance, that instructs Excel to set up a formula to add up all the numbers in a column and set up percentages of the total for each. When you instruct Excel to run a certain macro, Excel does it automatically.

    By automating steps and processes to produce automatic results, macros save users a lot of time. Plus, you can record almost anything in macro. Some of the basic functions you can do while using macros include manipulating data and text, applying formats, creating new documents, and interfacing with text files and databases.‎

    Macros are important to learn because they help to reduce the time and effort you put into managing a spreadsheet and database. You can use macros to speed up repetitive tasks, like monthly reports. The macros will help you also avoid typing and data adding errors.

    When you learn macros, you can create reports that are viewed as more user-friendly. Macros can be used to set up commands to move in between specific sheets in the Excel workbook. Some users also use macros to set the format for the worksheet and print as needed. You will also be seen as an Excel expert, a valuable skill to your audience.‎

    Learning how to construct Excel macros can help you with a wide range of career opportunities like a business consultant, researcher, workflow analyst, media planner, construction analyst, and many other roles in which research and data come together.

    When you learn about Excel macros for spreadsheets, you can gain a competitive edge in today's workplaces, as employers everywhere expect you to know the MS Office suite of applications. Knowing how to navigate Excel macros can help lead you to better-paying jobs in the future.‎

    When you learn Excel macros through online courses, you can better understand the reasons to use a spreadsheet, how to import and export data into your spreadsheets, and how to set up and modify worksheets. Taking online courses can also help you learn more generally about computer programming, data analysis, problem solving, logic and equations, and more. It's also a step forward in learning VBA, which works closely with macros.‎

    Online Excel Macros courses offer a convenient and flexible way to enhance your knowledge or learn new Excel Macros skills. Choose from a wide range of Excel Macros courses offered by top universities and industry leaders tailored to various skill levels.‎

    When looking to enhance your workforce's skills in Excel Macros, it's crucial to select a course that aligns with their current abilities and learning objectives. Our Skills Dashboard is an invaluable tool for identifying skill gaps and choosing the most appropriate course for effective upskilling. For a comprehensive understanding of how our courses can benefit your employees, explore the enterprise solutions we offer. Discover more about our tailored programs at Coursera for Business here.‎

    This FAQ content has been made available for informational purposes only. Learners are advised to conduct additional research to ensure that courses and other credentials pursued meet their personal, professional, and financial goals.

    Other topics to explore

    Arts and Humanities
    338 courses
    Business
    1095 courses
    Computer Science
    668 courses
    Data Science
    425 courses
    Information Technology
    145 courses
    Health
    471 courses
    Math and Logic
    70 courses
    Personal Development
    137 courses
    Physical Science and Engineering
    413 courses
    Social Sciences
    401 courses
    Language Learning
    150 courses

    Coursera Footer

    Technical Skills

    • ChatGPT
    • Coding
    • Computer Science
    • Cybersecurity
    • DevOps
    • Ethical Hacking
    • Generative AI
    • Java Programming
    • Python
    • Web Development

    Analytical Skills

    • Artificial Intelligence
    • Big Data
    • Business Analysis
    • Data Analytics
    • Data Science
    • Financial Modeling
    • Machine Learning
    • Microsoft Excel
    • Microsoft Power BI
    • SQL

    Business Skills

    • Accounting
    • Digital Marketing
    • E-commerce
    • Finance
    • Google
    • Graphic Design
    • IBM
    • Marketing
    • Project Management
    • Social Media Marketing

    Career Resources

    • Essential IT Certifications
    • High-Income Skills to Learn
    • How to Get a PMP Certification
    • How to Learn Artificial Intelligence
    • Popular Cybersecurity Certifications
    • Popular Data Analytics Certifications
    • What Does a Data Analyst Do?
    • Career Development Resources
    • Career Aptitude Test
    • Share your Coursera Learning Story

    Coursera

    • About
    • What We Offer
    • Leadership
    • Careers
    • Catalog
    • Coursera Plus
    • Professional Certificates
    • MasterTrack® Certificates
    • Degrees
    • For Enterprise
    • For Government
    • For Campus
    • Become a Partner
    • Social Impact
    • Free Courses
    • ECTS Credit Recommendations

    Community

    • Learners
    • Partners
    • Beta Testers
    • Blog
    • The Coursera Podcast
    • Tech Blog
    • Teaching Center

    More

    • Press
    • Investors
    • Terms
    • Privacy
    • Help
    • Accessibility
    • Contact
    • Articles
    • Directory
    • Affiliates
    • Modern Slavery Statement
    • Manage Cookie Preferences
    Learn Anywhere
    Download on the App Store
    Get it on Google Play
    Logo of Certified B Corporation
    © 2025 Coursera Inc. All rights reserved.
    • Coursera Facebook
    • Coursera Linkedin
    • Coursera Twitter
    • Coursera YouTube
    • Coursera Instagram
    • Coursera TikTok