Acerca de este Curso
4.7
2,168 calificaciones
525 revisiones
Programa Especializado
100 % en línea

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles

Fechas límite flexibles

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

Aprox. 12 horas para completar

Sugerido: 4 weeks of study, 1-3 hours/week...
Idiomas disponibles

Inglés (English)

Subtítulos: Inglés (English), Árabe (Arabic)...

Habilidades que obtendrás

Lookup TableData AnalysisMicrosoft ExcelPivot Table
Programa Especializado
100 % en línea

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles

Fechas límite flexibles

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

Aprox. 12 horas para completar

Sugerido: 4 weeks of study, 1-3 hours/week...
Idiomas disponibles

Inglés (English)

Subtítulos: Inglés (English), Árabe (Arabic)...

Programa - Qué aprenderás en este curso

Semana
1
Horas para completar
3 horas para completar

Introduction to Spreadsheets

Introduction to spreadsheets, reading data, manipulating data. Basic spreadsheet operations and functions....
Reading
8 videos (Total: 40 min), 5 readings, 7 quizzes
Video8 videos
Reading Data into Excel7m
Basic Data Manipulation in Excel5m
Arithmetic Manipulation in Excel4m
Basic Functions in Excel6m
Functions Using Absolute and Relative References6m
Functions Explained7m
Week 1 Recapm
Reading5 lecturas
Course FAQs10m
Pre-Course Survey10m
Store Sales (Comma delimited).txt10m
Store Sales (Fixed width).txt10m
Stores Sales (Tab delimited Text).txt10m
Quiz7 ejercicios de práctica
Reading Data into Excel4m
Basic Data Manipulation in Excel4m
Arithmetic Manipulation in Excel4m
Basic Functions in Excel4m
Functions Using Absolute and Relative References4m
Functions Explained4m
Introduction to Spreadsheetsm
Semana
2
Horas para completar
2 horas para completar

Spreadsheet Functions to Organize Data

Introduction to some more useful functions such as the IF, nested IF, VLOOKUP and HLOOKUP functions in Excel....
Reading
8 videos (Total: 44 min), 8 quizzes
Video8 videos
The “IF” Command in Excel Using Numerical Data3m
The "Nested IF" Command in Excel7m
The "VLOOKUP" Function in Excel8m
Another "VLOOKUP" Example6m
The "HLOOKUP" Function in Excel4m
Professor 'Know-it-all' Needs Help!4m
Week 2 Recapm
Quiz8 ejercicios de práctica
The "IF" Command in Excel4m
The “IF” Command in Excel Using Numerical Data4m
The "Nested IF" Command in Excel4m
The "VLOOKUP" Function in Excel4m
Another "VLOOKUP" Example4m
The "HLOOKUP" Function in Excel4m
Professor 'Know-it-all' Needs Help!4m
Spreadsheet Functions to Organize Datam
Semana
3
Horas para completar
2 horas para completar

Introduction to Filtering, Pivot Tables, and Charts

Introduction to the Data filtering capabilities of Excel, the construction of Pivot Tables to organize data and introduction to charts in Excel....
Reading
7 videos (Total: 42 min), 7 quizzes
Video7 videos
Data Filtering in Excel6m
Use of Pivot Tables in Excel6m
More Pivot Table Options5m
Application of Pivot Tables to Numeric Data8m
Introduction to Charts in Excel8m
Week 3 Recapm
Quiz7 ejercicios de práctica
Using the “VLOOKUP” Function Across Worksheets4m
Data Filtering in Excel4m
Use of Pivot Tables in Excel4m
More Pivot Table Options4m
Application of Pivot Tables to Numeric Data4m
Introduction to Charts in Excel4m
Introduction to Filtering, Pivot Tables, and Chartsm
Semana
4
Horas para completar
2 horas para completar

Advanced Graphing and Charting

Constructing various Line, Bar and Pie charts. Using the Pivot chart features of Excel. Understanding and constructing Histograms and Scatterplots....
Reading
7 videos (Total: 41 min), 1 reading, 7 quizzes
Video7 videos
Bar Graphs and Pie Charts9m
Pivot Charts5m
Scatter Plots7m
Histograms Part 14m
Histograms Part 27m
Week 4 Recapm
Reading1 lectura
End-of-Course Survey10m
Quiz7 ejercicios de práctica
Line Graphs4m
Bar Graphs and Pie Charts4m
Pivot Charts4m
Scatter Plots4m
Histograms Part 12m
Histograms Part 24m
Advanced Graphing and Chartingm
4.7
Dirección de la carrera

33%

comenzó una nueva carrera después de completar estos cursos
Beneficio de la carrera

83%

consiguió un beneficio tangible en su carrera profesional gracias a este curso
Promoción de la carrera

14%

consiguió un aumento de sueldo o ascenso

Principales revisiones

por SSApr 28th 2017

good course gives a basic foundation for data analytics ! Excellent for beginners who have no idea how to use excel for want to learn systematically excel files given at every lecture are very useful.

por LCMay 18th 2018

Excellent class, well-written and presented with real-world examples that are challenging but not impossible to complete if you follow the small quizzes and stay on top of the deadlines. Great job!

Instructor

Avatar

Sharad Borle

Associate Professor of Management
Jones Graduate School of Business

Acerca de Rice University

Rice University is consistently ranked among the top 20 universities in the U.S. and the top 100 in the world. Rice has highly respected schools of Architecture, Business, Continuing Studies, Engineering, Humanities, Music, Natural Sciences and Social Sciences and is home to the Baker Institute for Public Policy....

Acerca del programa especializado Business Statistics and Analysis

The Business Statistics and Analysis Specialization is designed to equip you with a basic understanding of business data analysis tools and techniques. You’ll master essential spreadsheet functions, build descriptive business data measures, and develop your aptitude for data modeling. You’ll also explore basic probability concepts, including measuring and modeling uncertainty, and you’ll use various data distributions, along with the Linear Regression Model, to analyze and inform business decisions. The Specialization culminates with a Capstone Project in which you’ll apply the skills and knowledge you’ve gained to an actual business problem. To successfully complete all course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later. To see an overview video for this Specialization, click here!...
Business Statistics and Analysis

Preguntas Frecuentes

  • Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.

  • 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.

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