Este curso forma parte de Programa especializado: Excel/VBA for Creative Problem Solving

4.8
estrellas
3,939 calificaciones

94 %

Charlie Nuttelman

133.804 ya inscrito

Ofrecido Por

Programa especializado: Excel/VBA for Creative Problem SolvingUniversidad de Colorado en Boulder

Acerca de este Curso

121.505 vistas recientes

"Excel/VBA for Creative Problem Solving, Part 1" is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).  
This course is the first part of a three-part series and Specialization that focuses on the application of computing 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 interface with the user; 4) learn the basic programming structures in VBA; and 5) automate Excel’s Goal Seek and Solver tools and use 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 nicely to teaching and learning - what a fun way to learn to code!  No prior knowledge in programming nor advanced math skills are necessary yet seasoned programmers will pick up new and creative spreadsheet problem solving strategies.

After you have learned the basics of VBA, each module will introduce foundational and broad problems inspired by situations that you might encounter in the real world.  To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment.  This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 1 de 3 en

Programa especializado: Excel/VBA for Creative Problem Solving

Nivel principiante

Aprox. 20 horas para completar

Inglés (English)

¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?

Prueba Coursera para negocios

Habilidades que obtendrás

Microsoft Excel Vba
Computer Programming
Problem Solving
Debugging

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 1 de 3 en

Programa especializado: Excel/VBA for Creative Problem Solving

Nivel principiante

Aprox. 20 horas para completar

Inglés (English)

¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?

Prueba Coursera para negocios

Instructor

Calificación del instructor

4,85/5 (1156 calificaciones)

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

343.380 alumnos

6 cursos

Ofrecido por

Universidad de Colorado en Boulder

Mira cómo los empleados de las mejores empresas dominan las habilidades más demandadas

Obtén más información sobre Coursera para Empresas

Programa - Qué aprenderás en este curso

Calificación del contenido94%(14,918 calificaciones)

Semana

Semana 1

5 horas para completar

Macro recording, VBA procedures, and debugging

5 horas para completar

14 videos (Total 64 minutos), 16 lecturas, 3 cuestionarios

14 videos

Welcome!2m

What can you do with Excel/VBA?5m

How the course works2m

How to switch sessions of the course1m

Week 1 preview1m

Getting your feet wet4m

Saving your files as macro-enabled workbooks57s

Recording basic macros8m

Absolute vs. relative referencing during macro recording8m

Overview of procedures in VBA8m

Why use Option Explicit?3m

Declaration of variables, data types, and scope of variables8m

How to troubleshoot when your code is not working properly6m

Assignment 1 preview and instructions2m

16 lecturas

Additional Excel/VBA examples10m

For Mac users10m

The power of Excel/VBA3m

Subscribe to "Everyday Excel VBA" YouTube Channel!2m

The importance of a Course Certificate and the future of higher education5m

Auditing the course vs. purchasing a Course Certificate10m

(OPTIONAL) Will Office Scripts replace VBA?10m

Course improvement and my philosophy on learning2m

If an assignment is not showing up for you10m

How to get help2m

VBA Tutorial10m

Opening macro-enabled workbooks10m

Week 1 files2m

Need to improve your Excel skills?10m

Assignment 11h

Week 2 files10m

3 ejercicios de práctica

Unlock quiz for Week 1 files2m

Week 1 Quiz10m

Assignment 1 Submission1m

Semana

Semana 2

3 horas para completar

VBA Nuts & Bolts, Part 1

3 horas para completar

11 videos (Total 59 minutos), 2 lecturas, 2 cuestionarios

11 videos

Week 2 preview1m

VBA syntax and expression entry: Part 16m

VBA syntax and expression entry: Part 25m

A warning about exponentiation and ampersands1m

Introduction to objects, properties, methods, and events7m

Common objects, properties, and methods8m

How to borrow functions from Excel11m

Examples, Part 1: Basic input and output in subroutines6m

Examples, Part 2: Basic input and output in subroutines4m

Examples, Part 3: Basic input and output in subroutines2m

Assignment 2 preview and instructions1m

2 lecturas

Assignment 21h 30m

Week 3 files2m

2 ejercicios de práctica

Week 2 Quiz20m

Assignment 2 submission1m

Semana

Semana 3

2 horas para completar

VBA Nuts & Bolts, Part 2

2 horas para completar

9 videos (Total 26 minutos), 3 lecturas, 2 cuestionarios

9 videos

Week 3 preview35s

How to make your own user-defined function4m

How to convert a user-defined function to an Excel Add-In2m

How to troubleshoot your user defined functions1m

Why you don't use input and message boxes in functions2m

How to handle basic user error in your subroutines3m

An introduction to modular programming5m

Running a subroutine that resides in another file4m

Assignment 3 preview and instructions1m

3 lecturas

Remember to use your DEBUGGING skills!5m

Assignment 31h

Week 4 files2m

2 ejercicios de práctica

Week 3 Quiz20m

Assignment 3 submission1m

Semana

Semana 4

3 horas para completar

Programming structures in VBA

3 horas para completar

15 videos (Total 95 minutos), 2 lecturas, 2 cuestionarios

15 videos

Week 4 preview1m

How to implement One-Way If...Then selection structures7m

How to implement Two-Way If...Then selection structures7m

All about the Multi-Alternative If...Then4m

Variable iteration loops (Do...Loops)7m

Validating user input using a Do...Loop3m

Creating a guessing game using a Do...Loop3m

All about fixed iteration (For...Next) loops8m

Iterating through a Selection vs. a Range10m

Putting it all together: Example 15m

Putting it all together: Example 27m

Example: Highlighting max and min values in a range7m

Using the For Each... Next statement8m

Worked mini-project: Searching through high and low temperatures in an Excel workbook8m

Assignment 4 preview and instructions3m

2 lecturas

Assignment 41h

Week 5 files10m

2 ejercicios de práctica

Week 4 Quiz20m

Assignment 4 submission1m

Reseñas

4.8

1125 reseña

5 stars
87,19 %
4 stars
10,24 %
3 stars
1,21 %
2 stars
0,32 %
1 star
1,01 %

Principales reseñas sobre EXCEL/VBA FOR CREATIVE PROBLEM SOLVING, PART 1

por LR4 de jul. de 2018

I'm not one to write reviews - this course is fantastic and a game changer. Prof Nuttelman is a very engaging speaker and makes what could seem a very dry topic come across as interesting, fascin

por KM24 de oct. de 2020

The course is definitely challenging. I am an engineering graduate but it did not come easily as I expected. Good exercise for the brains though and the lessons were taught systematically.

por MV18 de ene. de 2020

Great course!! For a Part I it introduces you to useful functions and ways to approach different kind of problems. Challenging course but reasonable with low algebra. Exactly what I was looking for.

por NN2 de mar. de 2020

i highly recommend this course as the content is new and the questions are designed to be challenging but not difficult. It is an excellent introduction course to VBA or programming in general

Ver todas las reseñas

Acerca de Programa especializado: Excel/VBA for Creative Problem Solving

This Specialization is for learners wishing to dramatically change the way that they use Excel spreadsheets by unleashing the power to automate and optimize spreadsheets using Visual Basic for Applications (VBA). The first two courses will teach learners the basics of VBA through the use of dozens of educational screencasts and a series of quizzes and in-application programming assignments. Finally, in Part 3 of the course, learners will complete 3 "real world" and somewhat open ended projects, which are graded through peer review.

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
¿Hay ayuda económica disponible?
Sí. En ciertos programas de aprendizaje, puedes postularte para recibir ayuda económica o una beca en caso de no poder costear los gastos de la tarifa de inscripción. Si hay ayuda económica o becas disponibles para tu selección de programa de aprendizaje, verás un enlace para postularte en la página de descripción.

¿Tienes más preguntas? Visita el Centro de Ayuda al Estudiante.

Desarrolla habilidades para tus empleados e impulsa los resultados de la empresa

Descubre Coursera para Empresas

Excel/VBA for Creative Problem Solving, Part 1

Acerca de este Curso

Habilidades que obtendrás