À 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 : University of 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	4.9 étoiles Note moyenne des utilisateurs 4.9Voir ce que disent les étudiants

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

Quand aurai-je accès aux vidéos de cours et aux devoirs ?

Que dois-je faire si j'ai besoin de plus de temps pour terminer le cours ?

À quoi ai-je droit si je paie ce cours ?

Puis-je suivre ce cours gratuitement ?

Quelle est la politique de remboursement ?

Une aide financière est-elle disponible ?

Comment cela fonctionne

Задания курса

Каждый курс — это интерактивный учебник, который содержит видеоматериалы, тесты и проекты.

Помощь сокурсников

Общайтесь с тысячами других учащихся: обсуждайте идеи, материалы курса и помогайте друг другу осваивать новые понятия.

Сертификаты

Получите документы о прохождении курсов и поделитесь своим успехом с друзьями, коллегами и работодателями.

Créateurs

University of 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

Note moyenne 4.9 sur 5 sur 15 notes

Useful !

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!

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.