Logical Operations

Programming and Data Wrangling with VBA and Excel Specialization

Build in-demand skills with a full year of Coursera Plus, now $239. Save now.

Logical Operations

Programming and Data Wrangling with VBA and Excel Specialization

Automate Excel Workbooks with VBA.

Automate tasks in Excel such as collecting, cleaning, and manipulating data.

Bill Rosenthal

Instructor: Bill Rosenthal

Included with Coursera PlusLearn more

Get in-depth knowledge of a subject
Intermediate level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
Intermediate level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • In this course, you will develop and deploy VBA modules to solve business problems.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

Specialization - 3 course series

Excel VBA Macros: Automating Tasks

Excel VBA Macros: Automating Tasks

Course 1, 7 hours

What you'll learn

  • Prepare the Excel interface for developer workflows by adjusting macro security, managing trusted locations, and navigating the Visual Basic Editor.

  • Record and manage automated tasks using both absolute and relative cell positioning while analyzing underlying VBA code strings.

  • Leverage contextual help files, R1C1 reference notation, and the Object Browser to discover and experiment with object properties.

  • Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Category: Microsoft Excel
Category: Excel Macros
Category: Data Wrangling
Category: Computer Programming
Category: Business Process Automation
Category: Visual Basic (Programming Language)
Category: Development Environment
Category: Property Inspection
Category: Data Science
Category: Spreadsheet Software
Category: Automation
Category: Microsoft 365
Excel VBA Macros: Custom Functions and Structures

Excel VBA Macros: Custom Functions and Structures

Course 2, 7 hours

What you'll learn

  • Write custom, reusable Excel formulas by defining input parameters, implementing If...Then...Else logic, and utilizing Select Case control blocks.

  • Manage memory and data structures using explicit variable declarations, strong data typing, Option Explicit, arrays, and iterative collection loops.

  • Troubleshoot runtime exceptions and improve macro execution speed.

  • Data files for this course are provided in the first course of this specialization, "Excel VBA Macros: Automating Tasks".

Skills you'll gain

Category: Computational Logic
Category: Microsoft Excel
Category: Debugging
Category: Data Science
Category: Maintainability
Category: Computer Programming
Category: Spreadsheet Software
Category: Excel Macros
Category: Microsoft 365
Category: Performance Improvement
Category: Visual Basic (Programming Language)
Category: Programming Principles
Category: Program Development
Category: Code Reusability
Category: Event-Driven Programming
Category: Data Wrangling
Category: Performance Tuning
Category: Automation
Excel VBA Macros: Forms, Files, and Data Handling

Excel VBA Macros: Forms, Files, and Data Handling

Course 3, 7 hours

What you'll learn

  • Build interactive custom forms with command buttons, event procedures, and data validation rules to improve user experience.

  • Read, write, and parse external text files and automate Power Query to streamline your data cleanup workflows.

  • Use regular expressions and error management tools to validate worksheet data and connect Excel with other desktop applications.

  • Data files for this course are provided in the first course of this specialization, "Excel VBA Macros: Automating Tasks".

Skills you'll gain

Category: Excel Macros
Category: Performance Improvement
Category: Visual Basic (Programming Language)
Category: File Management
Category: Data Quality
Category: Data Cleansing
Category: Excel Formulas
Category: Data Validation
Category: File I/O
Category: Event-Driven Programming
Category: Automation
Category: Debugging
Category: Data Science
Category: Spreadsheet Software
Category: Data Transformation
Category: Microsoft Excel
Category: Query Languages
Category: Microsoft 365
Category: Data Wrangling
Category: Computer Programming

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Bill Rosenthal
Logical Operations
161 Courses69,485 learners

Offered by

What brings you to Coursera today?

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions