Excel/VBA for Creative Problem Solving, Part 2

This course is part of Excel/VBA for Creative Problem Solving Specialization

Instructor: Charlie Nuttelman

What you'll learn

  •    Use VBA to import/export arrays from/to Excel
  •   Describe how text strings in Excel and how to write data to .txt files and import information from .txt files
  •   Automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet
  •   Create professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet.
  • Skills you'll gain

  •   Automation
  •   Visual Basic (Programming Language)
  •   Data Structures
  •   Excel Macros
  •   Data Import/Export
  •   Debugging
  •   Data Validation
  •   UI Components
  •   Programming Principles
  •   Spreadsheet Software
  • There are 4 modules in this course

    In Part 2 of the course, learners will: 1) learn how to work with arrays and import/export arrays from/to Excel using VBA code; 2) learn how to work with text strings and write data to .txt files and import information from .txt files; 3) automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet as well as the import of information from multiple workbooks to a central workbook; and 4) gain experience with creating professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet. Learners who have a foundational understanding of VBA code and programming structures can jump right into Part 2 of the course without taking Part 1 and use the screencasts in Part 1 as reference. Each module will introduce foundational and broad problems inspired by situations that you might encounter in the real world. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

    Working with strings and .txt files

    Iterating through worksheets and workbooks

    User forms and advanced user input/output

    Explore more from Algorithms

    ©2025  ementorhub.com. All rights reserved