Acerca de este Curso

63,707 vistas recientes
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel intermedio

A knowledge of algebra will help for some of this course.

Aprox. 21 horas para completar
Inglés (English)
Subtítulos: Inglés (English)

Habilidades que obtendrás

Data ManagementSpreadsheetMicrosoft ExcelProblem SolvingReal World
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel intermedio

A knowledge of algebra will help for some of this course.

Aprox. 21 horas para completar
Inglés (English)
Subtítulos: Inglés (English)

ofrecido por

Placeholder

Universidad de Colorado en Boulder

Programa - Qué aprenderás en este curso

Semana
1

Semana 1

6 horas para completar

Advanced Data Management

6 horas para completar
16 videos (Total 127 minutos), 7 lecturas, 3 cuestionarios
16 videos
(OPTIONAL): Review of VLOOKUP, MATCH, INDEX, and OFFSET functions10m
Two-way lookups in Excel9m
Two-way conditional lookups9m
Finding the location of a maximum10m
Conditional drop-down lists (data validation)9m
Conditional formatting based on formula8m
Example: Conditional formatting to identify errors7m
Comparing lists9m
Example: Who hasn't signed up?6m
Managing duplicates, Part 18m
Managing duplicates, Part 210m
Example: Expiry dates7m
Most frequent text3m
Assignment 1 preview and instructions2m
More about the OFFSET function7m
7 lecturas
The Power of Microsoft Excel10m
The importance of a Course Certificate and the future of higher education10m
For Mac users10m
Week 1 Excel files10m
Quiz 1 solutions and explanations10m
Assignment 12h
Week 2 Excel files10m
3 ejercicios de práctica
Unlock quiz for Week 1 files2m
Quiz 130m
Assignment 1 submission
Semana
2

Semana 2

3 horas para completar

Excel for Financial Applications, Part 1

3 horas para completar
13 videos (Total 82 minutos), 4 lecturas, 2 cuestionarios
13 videos
Customizing Excel for financial applications3m
Time value of money3m
Simple and compound interest, Part 19m
Simple and compound interest, Part 29m
Amortized loans5m
Using Excel to create an amortization schedule11m
Amortization schedule with extra payments2m
Effective vs. nominal interest rate9m
Savings accounts with payments and disbursements9m
Interest-only loans5m
Lines of credit9m
Assignment 2 preview and instructions1m
4 lecturas
Quiz 2 instructions2m
Quiz 2 solutions and explanations10m
Assignment 21h
Week 3 Excel files10m
2 ejercicios de práctica
Quiz 230m
Assignment 2 submission2m
Semana
3

Semana 3

4 horas para completar

Excel for Financial Applications, Part 2

4 horas para completar
10 videos (Total 73 minutos), 4 lecturas, 2 cuestionarios
10 videos
Depreciation9m
Common depreciation methods, Part 19m
Common depreciation methods, Part 28m
Cash flows and net present value, Part 18m
Cash flows and net present value, Part 27m
Comparing alternatives8m
Internal rate of return (IRR)9m
More about the OFFSET function7m
Assignment 3 preview and instructions1m
4 lecturas
Quiz 3 instructions2m
Quiz 3 solutions and explanations10m
Assignment 32h
Week 4 files10m
2 ejercicios de práctica
Quiz 330m
Assignment 3 submission2m
Semana
4

Semana 4

5 horas para completar

Case Studies and "What-If" Analyses

5 horas para completar
12 videos (Total 67 minutos), 4 lecturas, 2 cuestionarios
12 videos
Introduction to case studies8m
One-way Data Tables, Part 16m
One-way Data Tables, Part 27m
Two-way Data Tables6m
Example: Two-way Data Table2m
Goal Seek and Solver for targeting problems, Part 17m
Goal Seek and Solver for targeting problems, Part 25m
Solver for optimization problems4m
Using the Solver with constraints, Part 16m
Using Solver with constraints, Part 25m
Assignment 4 preview and instructions1m
4 lecturas
Quiz 4 instructions2m
Quiz 4 solutions and explanations10m
Assignment 41h 30m
Week 5 Excel files10m
2 ejercicios de práctica
Quiz 430m
Assignment 4 submission1h

Reseñas

Principales reseñas sobre EVERYDAY EXCEL, PART 2

Ver todas las reseñas

Preguntas Frecuentes

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