The virtual course "Excel/VBA for creative problem solving, part 2 - Virtual Course - Coursera", is a course with different contents and that offers video classes of Approx. 20 hours to complete. Explore its essential features, and click the orange button to get detailed information on the Coursera e-Learning platform
"Excel/VBA for Creative Problem Solving, Part 2" builds on the knowledge and skills gained in "Excel/VBA for Creative Problem Solving, Part 1" and is intended for students looking to augment, expand, optimize and increase the efficiency of your Excel spreadsheet skills by taking advantage of the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).
In Part 2 of the course, students will: 1) learn how to work with arrays and import/export arrays from/to Excel using VBA code; 2) learn to work with strings and write data to .
txt and import information from .
txt; 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 in creating professional user forms to interact with the user, perform advanced calculations, and manipulate data in the spreadsheet.
Students who have a basic understanding of VBA code and programming structures can skip directly to Part 2 of the course without taking Part 1 and use the screencasts in Part 1 for reference.
Each module will present fundamental and broad problems inspired by situations you might encounter in the real world.
To pass each module, you will need to pass a mastery quiz and complete a problem solving task.
This course is unique in that weekly assignments are completed on the app (i.e.
Prepare yourself from home with the most prestigious universities in the world.
The quality of Coursera's courses is supported by its instructors, who are often deans and have doctorates.
More than 85% of Coursera students report career benefits, such as promotions or salary increases.
Millions of students around the world are meeting their personal and professional goals with Coursera.
Coursera offers courses from over 200 leading universities and companies to deliver online learning around the world. With a Coursera Plus subscription, you get unlimited access to over 90% of all courses, and the most popular professional certificates and specializations on Coursera.
Data science, business and personal development. You can enroll in multiple courses at once, earn unlimited certificates, and learn in-demand job skills to start, grow, and even change careers.
DISCOVER HOW TO GET THE MOST, AND SAVE OVER USD $500 WITH AN ANNUAL SUBSCRIPTION TO COURSERA PLUS*
*You save up to USD$500 in 12 months, when you go from paying USD$59 for a monthly subscription, to an annual subscription with the promotion. The normal annual subscription is USD $399. With the promotion you will only pay USD $299. Find out everything by clicking the yellow button.
University of Colorado at Boulder
Hello how can I help you? Are you interested in a course? About what subject?
Add a review