Este curso forma parte de Programa especializado: Everyday Excel

4.7
estrellas
229 calificaciones

Charlie Nuttelman

20.185 ya inscrito

Ofrecido Por

Programa especializado: Everyday ExcelUniversidad de Colorado en Boulder

Acerca de este Curso

13.932 vistas recientes

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2".  It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).
Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5).  The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds.

It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.

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.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 3 de 3 en

Programa especializado: Everyday Excel

Nivel avanzado

A working knowledge of Excel is required, including dynamic array functions (Office 365). It is recommended to take Parts 1 and 2 of Everyday Excel.

Aprox. 14 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

Qué aprenderás

In this course, you'll apply Excel functions and tools to solving broad, somewhat open-ended problems through a wide variety of "guided" projects.

Habilidades que obtendrás

Data Management
Spreadsheet
Microsoft Excel
Real-world projects
computing

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.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 3 de 3 en

Programa especializado: Everyday Excel

Nivel avanzado

A working knowledge of Excel is required, including dynamic array functions (Office 365). It is recommended to take Parts 1 and 2 of Everyday Excel.

Aprox. 14 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,9/5 (68 calificaciones)

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

350.741 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

Semana1

Semana 1

2 horas para completar

Introduction and General Course Information

2 horas para completar

2 videos (Total 7 minutos), 12 lecturas, 1 cuestionario

2 videos

Course Overview and Introduction6mHow to Switch Sessions of the Course46s

12 lecturas

Is This Course For You?10mSubscribe to "Everyday Excel VBA" YouTube Channel!2mOffice 365 is Required For This Course!10mTake Your Time!5mFor Mac Users10mThe Importance of a Course Certificate and the Future of Higher Education10mAuditing the Course vs. Purchasing a Course Certificate10mHow to get help2mIf you enjoy Excel... you'll love VBA!10mHow to Unlock the Course Files10mOpening macro-enabled workbooks10mCourse Files10m

1 ejercicio de práctica

Unlock Quiz for Course Files5m

Semana2

Semana 2

3 horas para completar

WARM-UP PROJECTS (Choose Three)

3 horas para completar

7 videos (Total 31 minutos), 5 lecturas, 5 cuestionarios

7 videos

Nearest Eighth of an Inch Preview1mWorld Bank Lookup Preview1mDynamic Amortization Schedule Hints and Preview9mIntroduction to Dynamic Array Functions8mLongest Ladder Around the Corner Preview1mDynamic Temperature Lookup Preview1mIntroduction to Dynamic Array Functions8m

5 lecturas

Nearest Eighth of an Inch Problem Statement10mWorld Bank Lookup Problem Statement10mDynamic Amortization Schedule Problem Statement10mLongest Ladder Around the Corner Problem Statement10mDynamic Temperature Lookup Problem Statement10m

5 ejercicios de práctica

Nearest Eighth of an Inch Submission Quiz5mWorld Bank Lookup Submission Quiz5mDynamic Amortization Schedule Submission Quiz5mLongest Ladder Around the Corner Submission Quiz5mDynamic Temperature Lookup Submission Quiz30m

Semana3

Semana 3

3 horas para completar

INTERMEDIATE PROJECTS (Choose Three)

Now that you're warmed up, let's transition to some more challenging projects! There are six possible projects for you to choose from for the Intermediate Projects, and you must complete three of them. The Sensitivity Analysis and Historical Weather Lookup (Part A) projects are perhaps the easier projects of the bunch, but the Dynamic Data Cleaning is not far behind. The Friday the 13th project is interesting but possibly a tad bit more challenging. The Bakery Shopping List and Dinner Sign-Up projects are somewhere in between. Have fun!

3 horas para completar

10 videos (Total 51 minutos), 6 lecturas, 6 cuestionarios

10 videos

How to Perform a Sensitivity Analysis11mSensitivity Analysis Hints and Preview2mFriday the 13th Preview1mDynamic Data Cleaning Preview and Hints8mIntroduction to Dynamic Array Functions8mFiltering for Multiple Criteria4mHistorical Weather Lookup (Part A) Preview2mBakery Shopping List Preview1mDinner Sign-Up preview1mAn Introduction to Dynamic Array Functions8m

6 lecturas

Sensitivity Analysis Problem Statement10mFriday the 13th Problem Statement10mDynamic Data Cleaning Problem Statement10mHistorical Weather Lookup (Part A) Problem Statement10mBakery Shopping List Problem Statement10mDinner Sign-Up Problem Statement1m

6 ejercicios de práctica

Sensitivity Analysis Submission Quiz5mFriday the 13th Submission Quiz5mDynamic Data Cleaning Submission Quiz5mHistorical Weather Lookup (Part A) Submission Quiz5mBakery Shopping List Submission Quiz30mDinner Sign-Up Submission Quiz5m

Semana4

Semana 4

4 horas para completar

MAIN PROJECTS (Choose Three)

Now for the heart of the course - the Main Projects! You'll implement many of the techniques and tools that you've learned in Parts 1 and 2 of "Everyday Excel". These projects are more involved than the intermediate projects. However, in many cases I provide significant hints and suggestions (mainly through screencasts). Therefore, I "guide" you through these projects. You'll be left with a proud, well-earned sense of accomplishment after having done these projects! There are 5 projects to choose from, and you need to complete 3 of them. Good luck!

4 horas para completar

17 videos (Total 114 minutos), 5 lecturas, 5 cuestionarios

17 videos

Distance Calculator Preview3mDealing with Multiple Table Lookups9mHow to Reset Conditional Drop-Down Lists9mRental Center Inventory Preview4mAn Introduction to Dynamic Array Functions 8mDynamic Filtering for Multiple Constraints12mHow to Reset Conditional Drop-Down Lists9mMatrix Approach to Regression, Part 16mMatrix Approach to Regression, Part 27mReal-Time Regression Preview2mDynamic Array Hints for Real-Time Regression 7mHow to Calculate Standard Error and Adjusted R-Squared7mAmortization Schedule with Extra Payments, Part 110mAmortization Schedule with Extra Payments, Part 26mAmortization Schedule with Extra Payments Preview1mHistorical Weather Lookup (Part B) Preview2mTo Get You Pumped Up for VBA (Preview for My Specialization "Excel/VBA for Creative Problem Solving")3m

5 lecturas

Distance Calculator Problem Statement10mRental Center Inventory Problem Statement10mReal-Time Regression Problem Statement10mAmortization Schedule with Extra Payments Problem Statement10mHistorical Weather Lookup (Part B) Problem Statement10m

5 ejercicios de práctica

Distance Calculator Submission Quiz5mRental Center Inventory Submission Quiz5mReal-Time Regression Submission Quiz5mAmortization Schedule with Extra Payments Submission Quiz5mHistorical Weather Lookup (Part B) Submission Quiz30m

Reseñas

4.7

55 reseña

5 stars
80,43 %
4 stars
16,08 %
3 stars
1,30 %
2 stars
0,43 %
1 star
1,73 %

Principales reseñas sobre EVERYDAY EXCEL, PART 3 (PROJECTS)

por Q12 de mar. de 2021

Very useful and informative, but I still don't see the honor on my certificate even after completing the honor part

por WI22 de may. de 2022

I enjoyed this course. Would have been nice to have more interaction wiht the instructor as many of the projects needed further clairification to complete.

por KR14 de may. de 2021

Really good projects to evaluate what you learnt, some were very difficult to pass the grader although the project answer was correct and it took some time to get pass the grader.

por AS14 de feb. de 2021

As always.. Great course, content, and instructor.

It was really awesome, I highly recommend it.

Thank you

Ver todas las reseñas

Acerca de Programa especializado: Everyday Excel

This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.

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

Everyday Excel, Part 3 (Projects)

Acerca de este Curso

Qué aprenderás

Habilidades que obtendrás