The virtual course "Excel/VBA for creative problem solving, part 1 - Virtual Course - Coursera", is a course with different contents and that offers video classes of Approx. 18 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 1" is intended for students looking to increase, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by taking advantage of the powerful programming, automation, and customization capabilities available. with Visual Basics for Applications (VBA).
This course is the first part of a three-part series and a specialization that focuses on the application of computer techniques in Excel/VBA to solve problems.
In this course (Part 1), you will: 1) create macros to automate procedures in Excel; 2) define your own user-defined functions; 3) create basic subroutines to interact with the user; 4) learn the basic programming structures in VBA; and 5) automating Excel's Goal Seek and Solver tools and using numerical techniques to create "live solutions" to solve targeting and optimization problems.
New to computer programming? The extremely intuitive and visual nature of VBA lends itself very well to teaching and learning - what a fun way to learn to code! No prior programming knowledge or advanced math skills are required, but experienced programmers will learn new and creative strategies for solving spreadsheet problems.
Once you've learned the basics of VBA, 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