À propos de ce cours : In this course, learners will complete several VBA projects. It is highly recommended that learners first take "Excel/VBA for Creative Problem Solving, Part 1" and "Excel/VBA for Creative Problem Solving, Part 2". This course builds off of skills learned in those two courses. This is a project-based course. Therefore, the projects are quite open-ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners' projects based on a grading rubric.
Les destinataires de ce cours : This course is aimed at science/engineering/business students and professionals wishing to unlock the vast potential of Visual Basic for Applications to help you automate and customize the Excel spreadsheet environment. This course builds on two previous courses ("Excel/VBA for Creative Problem Solving", Parts 1 and 2).
Créé par : Université du Colorado à Boulder
Enseigné par : Charlie Nuttelman, Instructor
Chemical and Biological Engineering
| Informations de base | Cours 3 de 3 dans Excel/VBA for Creative Problem Solving Specialization |
| Niveau | Avancées |
| Engagement | 3-4 weeks of study, 3-5 hours/week |
| Langue | English |
| Matériel requis | Windows version of Excel/VBA |
| Comment réussir | Réussissez tous les devoirs notés pour terminer le cours. |
| Notes des utilisateurs |
Programme de cours
SEMAINE 1
Getting Started
This first module introduces the course and provides some background material. Paid learners have access to the course files, which are unlocked when you complete the "Unlock Quiz".
1 vidéo, 4 lectures
- 阅读: Is this course for you?
- 阅读: For Mac users
- 阅读: The importance of a Course Certificate and the future of higher education
- 阅读: Course files
- 讨论提示: (OPTIONAL) What about you?
Noté: Unlock Quiz
SEMAINE 2
Easy Projects
Choose one of two potential easy projects to complete!
5 vidéos, 1 lecture
- 阅读: Currency Converter - Problem Statement
- Vidéo: How to run a data query
- Vidéo: Initializing the combo boxes and today's date
- Vidéo: Importing data from the currency website using proper date format
- Vidéo: Plotting the last 30 days
Noté: Currency Converter Grading Rubric
SEMAINE 3
Intermediate Projects
For the second project, choose one of two possible intermediate projects.
7 vidéos, 1 lecture
- 阅读: Ultimate Organizer - Problem Statement
- Vidéo: A demonstration of the Ultimate Organizer
- Vidéo: How to add a category
- Vidéo: How to add a new record, Part 1
- Vidéo: How to add a new record, Part 2
- Vidéo: How to reveal hidden labels and text boxes
- Vidéo: How to add an icon to the Quick Access Toolbar to run your user form
Noté: Ultimate Organizer
SEMAINE 4
Monte Carlo Simulation
All learners are required to complete the Monte Carlo simulation, which is intermediate in difficulty.
10 vidéos, 1 lecture
- 阅读: Monte Carlo Simulation Problem Statement
- Vidéo: Monte Carlo cookie example
- Vidéo: How to output a random variable that follows a certain distribution
- Vidéo: The uniform distribution
- Vidéo: The discrete distribution
- Vidéo: The normal distribution
- Vidéo: The triangular distribution
- Vidéo: The Beta-PERT distribution
- Vidéo: How to apply a VBA user form to a Monte Carlo simulation
- Vidéo: An overview of the profitability analysis spreadsheet
Noté: Monte Carlo Simulation
SEMAINE 5
Grade Manager Project (for Honors)
If you are really up for a challenge, complete the Grade Manager project, which is very challenging. Learners who successfully create this project will earn an Honors designation on their Course Certificate.
13 vidéos, 1 lecture
- 阅读: Grade Manager - Problem Statement
- Vidéo: Creating a new folder inside a preexisting directory
- Vidéo: Importing the Roster.xlsx file to a new sheet
- Vidéo: Creating section rosters from main roster file, Part 1
- Vidéo: Creating section rosters from main roster file, Part 2
- Vidéo: Initializing column headings on section roster files
- Vidéo: Syncing files, Part 1
- Vidéo: Syncing files, Part 2
- Vidéo: How to create a dated backup file
- Vidéo: Adding a new grade item to all section sheets, Part 1
- Vidéo: Adding a new grade item to all section sheets, Part 2
- Vidéo: Adding a new grade item to all section sheets, Part 3
- Vidéo: Search and replace tool
Noté: Grade Manager
FAQ
Comment cela fonctionne
课程作业
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
来自同学的帮助
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
证书
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
Créateurs
Université du Colorado à Boulder
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
Tarification
| Acheter le cours | |
|---|---|
| Accéder au contenu du cours | Disponible |
| Accéder au contenu noté | Disponible |
| Recevoir une Note Finale | Disponible |
| Obtenir un Certificat de Cours partageable | Disponible |
Notation et examens
Thanks a lot for the great course and great specialization!Working in Supply Chain Planning, I need deep knowledge of Excel, especially now, when companies tend to save on expensive tools like SAP or Oracle. I always wanted to learn Excel VBA, but it seemed not easy to me.It was a surprise for me that VBA can be explained so well, in a structured way and with great examples! Instructor Charlie creates very nice and friendly atmosphere in the course and provides great and very talented teaching!Thank you for that! I will recommend excel VBA specialization to my friends and colleagues.
Challenging and rewarding. Very useful and complete. Great tutor support. A course i am enjoying very, very much.
The projects in this course were challenging, but at no point did I feel completely loss. The lessons leading into the projects were very informative. I had to refer to Level 2 a few times and rewatch the videos, but never really had to search the internet. Overall a very good course.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2018 Coursera Inc. Tous droits réservés.
I really enjoyed those free projects! Very challenging. However, I am not the biggest fan of peer reviews. For people wanting to finish the subscription earlier and not go with 3 month fees it is basically impossible. Either one doesn't get reviews - even after posting into discussion forums - or one cannot upload because it is not open yet as the course officially hasn't started. Or one switches sessions backwards and one is too late in submitting and doesn't get reviews in time either. I would prefer much more having grader and the peer review just as a second option to learn from others in case one gets absolutely stuck or to see other ways to do it. But to make passing and timing dependable on this: not helpful. Other than that, again, loved the class. :) Thanks!