Informações sobre o curso

876,432 visualizações recentes

Resultados de carreira do aprendiz

48%

comecei uma nova carreira após concluir estes cursos

41%

consegui um benefício significativo de carreira com este curso

10%

recebi um aumento ou promoção
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Aprox. 20 horas para completar
Inglês
Legendas: Inglês, Espanhol, Árabe

Habilidades que você terá

Lookup TableData AnalysisMicrosoft ExcelPivot Table

Resultados de carreira do aprendiz

48%

comecei uma nova carreira após concluir estes cursos

41%

consegui um benefício significativo de carreira com este curso

10%

recebi um aumento ou promoção
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Aprox. 20 horas para completar
Inglês
Legendas: Inglês, Espanhol, Árabe

Instrutores

oferecido por

Logotipo de Universidade Rice

Universidade Rice

Programa - O que você aprenderá com este curso

Classificação do conteúdoThumbs Up92%(17,156 classificações)Info
Semana
1

Semana 1

5 horas para concluir

Introduction to Spreadsheets

5 horas para concluir
8 vídeos (Total 40 mín.), 5 leituras, 7 testes
8 videos
Reading Data into Excel7min
Basic Data Manipulation in Excel5min
Arithmetic Manipulation in Excel4min
Basic Functions in Excel6min
Functions Using Absolute and Relative References6min
Functions Explained7min
Week 1 Recap51s
5 leituras
Course FAQs10min
Pre-Course Survey10min
Store Sales (Comma delimited).txt10min
Store Sales (Fixed width).txt10min
Stores Sales (Tab delimited Text).txt10min
7 exercícios práticos
Reading Data into Excel30min
Basic Data Manipulation in Excel30min
Arithmetic Manipulation in Excel30min
Basic Functions in Excel30min
Functions Using Absolute and Relative References30min
Functions Explained30min
Introduction to Spreadsheets1h
Semana
2

Semana 2

5 horas para concluir

Spreadsheet Functions to Organize Data

5 horas para concluir
8 vídeos (Total 44 mín.)
8 videos
The “IF” Command in Excel Using Numerical Data3min
The "Nested IF" Command in Excel7min
The "VLOOKUP" Function in Excel8min
Another "VLOOKUP" Example6min
The "HLOOKUP" Function in Excel4min
Professor 'Know-it-all' Needs Help!4min
Week 2 Recap40s
8 exercícios práticos
The "IF" Command in Excel30min
The “IF” Command in Excel Using Numerical Data30min
The "Nested IF" Command in Excel30min
The "VLOOKUP" Function in Excel30min
Another "VLOOKUP" Example30min
The "HLOOKUP" Function in Excel30min
Professor 'Know-it-all' Needs Help!30min
Spreadsheet Functions to Organize Data1h
Semana
3

Semana 3

4 horas para concluir

Introduction to Filtering, Pivot Tables, and Charts

4 horas para concluir
7 vídeos (Total 42 mín.)
7 videos
Data Filtering in Excel6min
Use of Pivot Tables in Excel6min
More Pivot Table Options5min
Application of Pivot Tables to Numeric Data8min
Introduction to Charts in Excel8min
Week 3 Recap52s
7 exercícios práticos
Using the “VLOOKUP” Function Across Worksheets30min
Data Filtering in Excel30min
Use of Pivot Tables in Excel30min
More Pivot Table Options30min
Application of Pivot Tables to Numeric Data4min
Introduction to Charts in Excel30min
Introduction to Filtering, Pivot Tables, and Charts1h
Semana
4

Semana 4

5 horas para concluir

Advanced Graphing and Charting

5 horas para concluir
7 vídeos (Total 41 mín.), 1 leitura, 7 testes
7 videos
Bar Graphs and Pie Charts9min
Pivot Charts5min
Scatter Plots7min
Histograms Part 14min
Histograms Part 27min
Week 4 Recap46s
1 leituras
End-of-Course Survey10min
7 exercícios práticos
Line Graphs30min
Bar Graphs and Pie Charts30min
Pivot Charts30min
Scatter Plots30min
Histograms Part 130min
Histograms Part 230min
Advanced Graphing and Charting1h

Avaliações

Principais avaliações do INTRODUCTION TO DATA ANALYSIS USING EXCEL

Visualizar todas as avaliações

Sobre Programa de cursos integrados 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

Perguntas Frequentes – FAQ

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.