Informações sobre o curso: 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.

Para quem é direcionado este curso: 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).

Desenvolvido por: University of Colorado Boulder

Ministrado por: Charlie Nuttelman, Instructor
Chemical and Biological Engineering

Informações básicas	Curso 3 de 3 no Excel/VBA for Creative Problem Solving Specialization
Nível	Avançado
Compromisso	3-4 weeks of study, 3-5 hours/week
Idioma	English
Requisitos de hardware	Windows version of Excel/VBA
Como ser aprovado	Seja aprovado em todas as tarefas para concluir o curso.
Classificação do usuário	4.9 estrelas Classificação média do usuário 4.9Veja o que os aprendizes disseram

Programa

SEMANA 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 vídeos, 4 leituras

Reading: Is this course for you?
Reading: For Mac users
Reading: The importance of a Course Certificate and the future of higher education
Reading: Course files
Discussion Prompt: (OPTIONAL) What about you?

Nota atribuída: Unlock Quiz

SEMANA 2

Easy Projects

Choose one of two potential easy projects to complete!

5 videos, 1 leituras

Reading: Currency Converter - Problem Statement
Vídeo: How to run a data query
Vídeo: Initializing the combo boxes and today's date
Vídeo: Importing data from the currency website using proper date format
Vídeo: Plotting the last 30 days

Nota atribuída: Currency Converter Grading Rubric

SEMANA 3

Intermediate Projects

For the second project, choose one of two possible intermediate projects.

7 videos, 1 leituras

Reading: Ultimate Organizer - Problem Statement
Vídeo: A demonstration of the Ultimate Organizer
Vídeo: How to add a category
Vídeo: How to add a new record, Part 1
Vídeo: How to add a new record, Part 2
Vídeo: How to reveal hidden labels and text boxes
Vídeo: How to add an icon to the Quick Access Toolbar to run your user form

Nota atribuída: Ultimate Organizer

SEMANA 4

Monte Carlo Simulation

All learners are required to complete the Monte Carlo simulation, which is intermediate in difficulty.

10 videos, 1 leituras

Reading: Monte Carlo Simulation Problem Statement
Vídeo: Monte Carlo cookie example
Vídeo: How to output a random variable that follows a certain distribution
Vídeo: The uniform distribution
Vídeo: The discrete distribution
Vídeo: The normal distribution
Vídeo: The triangular distribution
Vídeo: The Beta-PERT distribution
Vídeo: How to apply a VBA user form to a Monte Carlo simulation
Vídeo: An overview of the profitability analysis spreadsheet

Nota atribuída: Monte Carlo Simulation

SEMANA 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 videos, 1 leituras

Reading: Grade Manager - Problem Statement
Vídeo: Creating a new folder inside a preexisting directory
Vídeo: Importing the Roster.xlsx file to a new sheet
Vídeo: Creating section rosters from main roster file, Part 1
Vídeo: Creating section rosters from main roster file, Part 2
Vídeo: Initializing column headings on section roster files
Vídeo: Syncing files, Part 1
Vídeo: Syncing files, Part 2
Vídeo: How to create a dated backup file
Vídeo: Adding a new grade item to all section sheets, Part 1
Vídeo: Adding a new grade item to all section sheets, Part 2
Vídeo: Adding a new grade item to all section sheets, Part 3
Vídeo: Search and replace tool

Nota atribuída: Grade Manager

Perguntas frequentes

Quando terei acesso aos vídeos do curso e às tarefas?

E se eu precisar de tempo adicional para concluir o curso?

O que obtenho se eu pagar por este curso?

Posso fazer este curso gratuitamente?

Como funciona a política de reembolso?Como funciona a política de reembolso?

Existe algum auxílio financeiro disponível?

Como funciona

Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from Your Peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates

Earn official recognition for your work, and share your success with friends, colleagues, and employers.

Desenvolvedores

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.

Custo

	Comprar curso
Acesso aos materiais do curso	Disponível
Acesso a materiais valendo nota	Disponível
Receba uma nota final	Disponível
Obtenha um Certificado de Curso compartilhável	Disponível

Classificações e avaliações

Avaliado em 4.9 de 5 decorrente de 15 avaliações

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.