關於此課程：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.
此課程適用人群：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).
製作方： University of Colorado Boulder
教學方： Charlie Nuttelman, Instructor
Chemical and Biological Engineering
| 基本信息 | |
| 級別 | 高級設置 |
| 承諾學習時間 | 3-4 weeks of study, 3-5 hours/week |
| 語言 | 英語（English） |
| 硬件要求 | Windows version of Excel/VBA |
| 如何通過 | 通過所有計分作業以完成課程。 |
| 用戶評分 |
授課大綱
第 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 個視頻, 4 個閱讀材料
- 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?
已評分: Unlock Quiz
第 2 週
Easy Projects
Choose one of two potential easy projects to complete!
5 個視頻, 1 個閱讀材料
- Reading: Currency Converter - Problem Statement
- 視頻: How to run a data query
- 視頻: Initializing the combo boxes and today's date
- 視頻: Importing data from the currency website using proper date format
- 視頻: Plotting the last 30 days
已評分: Currency Converter Grading Rubric
第 3 週
Intermediate Projects
For the second project, choose one of two possible intermediate projects.
7 個視頻, 1 個閱讀材料
- Reading: Ultimate Organizer - Problem Statement
- 視頻: A demonstration of the Ultimate Organizer
- 視頻: How to add a category
- 視頻: How to add a new record, Part 1
- 視頻: How to add a new record, Part 2
- 視頻: How to reveal hidden labels and text boxes
- 視頻: How to add an icon to the Quick Access Toolbar to run your user form
已評分: Ultimate Organizer
第 4 週
Monte Carlo Simulation
All learners are required to complete the Monte Carlo simulation, which is intermediate in difficulty.
10 個視頻, 1 個閱讀材料
- Reading: Monte Carlo Simulation Problem Statement
- 視頻: Monte Carlo cookie example
- 視頻: How to output a random variable that follows a certain distribution
- 視頻: The uniform distribution
- 視頻: The discrete distribution
- 視頻: The normal distribution
- 視頻: The triangular distribution
- 視頻: The Beta-PERT distribution
- 視頻: How to apply a VBA user form to a Monte Carlo simulation
- 視頻: An overview of the profitability analysis spreadsheet
已評分: Monte Carlo Simulation
第 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 個視頻, 1 個閱讀材料
- Reading: Grade Manager - Problem Statement
- 視頻: Creating a new folder inside a preexisting directory
- 視頻: Importing the Roster.xlsx file to a new sheet
- 視頻: Creating section rosters from main roster file, Part 1
- 視頻: Creating section rosters from main roster file, Part 2
- 視頻: Initializing column headings on section roster files
- 視頻: Syncing files, Part 1
- 視頻: Syncing files, Part 2
- 視頻: How to create a dated backup file
- 視頻: Adding a new grade item to all section sheets, Part 1
- 視頻: Adding a new grade item to all section sheets, Part 2
- 視頻: Adding a new grade item to all section sheets, Part 3
- 視頻: Search and replace tool
已評分: Grade Manager
常見問題解答
運作方式
Trabalho
Cada curso é como um livro didático interativo, com vídeos pré-gravados, testes e projetos.
Ajuda dos seus colegas
Conecte-se com milhares de outros aprendizes, debata ideias, discuta sobre os materiais do curso e obtenha ajuda para dominar conceitos.
Certificados
Obtenha reconhecimento oficial pelo seu trabalho e compartilhe seu sucesso com amigos, colegas e empregadores.
製作方
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.
價格
| 購買課程 | |
|---|---|
| 訪問課程材料 | 可用 |
| 訪問評分的材料 | 可用 |
| 收到最終成績 | 可用 |
| 獲得可共享的課程證書 | 可用 |
評分和審閱
All the spcialization is absolutely amazing, you will not only learn how to make impressive tools in excel VBA, but also a lot of other things!
Best course to learn Visual Basic
The course was really good. It helped me gain knowledge about the various aspects of excel which had been untouched by me. It has helped me in my professional endeavours too.
Thank You
CC
Awesome course. Challenging but yet easy-going.