When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel/VBA for Creative Problem Solving, Part 2
This course is part of Excel/VBA for Creative Problem Solving Specialization
Free
This Course Includes
coursera
4.9 (1.3K reviews )
20 hours (approximately) 
english
Online - Self Paced
course
University of Colorado Boulder
About Excel/VBA for Creative Problem Solving, Part 2
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
What You Will 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..