À propos de ce cours

909,379 consultations récentes

Résultats de carrière des étudiants

48%

ont commencé une nouvelle carrière après avoir terminé ce cours

41%

ont bénéficié d'un avantage concret dans leur carrières grâce à ce cours

10%

a obtenu une augmentation de salaire ou une promotion
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Approx. 20 heures pour terminer
Anglais
Sous-titres : Anglais, Espagnol, Arabe

Compétences que vous acquerrez

Lookup TableData AnalysisMicrosoft ExcelPivot Table

Résultats de carrière des étudiants

48%

ont commencé une nouvelle carrière après avoir terminé ce cours

41%

ont bénéficié d'un avantage concret dans leur carrières grâce à ce cours

10%

a obtenu une augmentation de salaire ou une promotion
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Approx. 20 heures pour terminer
Anglais
Sous-titres : Anglais, Espagnol, Arabe

Offert par

Logo Université de Rice

Université de Rice

Programme du cours : ce que vous apprendrez dans ce cours

Évaluation du contenuThumbs Up92%(17,009 notes)Info
Semaine
1

Semaine 1

5 heures pour terminer

Introduction to Spreadsheets

5 heures pour terminer
8 vidéos (Total 40 min), 5 lectures, 7 quiz
8 vidéos
Reading Data into Excel7 min
Basic Data Manipulation in Excel5 min
Arithmetic Manipulation in Excel4 min
Basic Functions in Excel6 min
Functions Using Absolute and Relative References6 min
Functions Explained7 min
Week 1 Recap51s
5 lectures
Course FAQs10 min
Pre-Course Survey10 min
Store Sales (Comma delimited).txt10 min
Store Sales (Fixed width).txt10 min
Stores Sales (Tab delimited Text).txt10 min
7 exercices pour s'entraîner
Reading Data into Excel30 min
Basic Data Manipulation in Excel30 min
Arithmetic Manipulation in Excel30 min
Basic Functions in Excel30 min
Functions Using Absolute and Relative References30 min
Functions Explained30 min
Introduction to Spreadsheets1 h
Semaine
2

Semaine 2

5 heures pour terminer

Spreadsheet Functions to Organize Data

5 heures pour terminer
8 vidéos (Total 44 min)
8 vidéos
The “IF” Command in Excel Using Numerical Data3 min
The "Nested IF" Command in Excel7 min
The "VLOOKUP" Function in Excel8 min
Another "VLOOKUP" Example6 min
The "HLOOKUP" Function in Excel4 min
Professor 'Know-it-all' Needs Help!4 min
Week 2 Recap40s
8 exercices pour s'entraîner
The "IF" Command in Excel30 min
The “IF” Command in Excel Using Numerical Data30 min
The "Nested IF" Command in Excel30 min
The "VLOOKUP" Function in Excel30 min
Another "VLOOKUP" Example30 min
The "HLOOKUP" Function in Excel30 min
Professor 'Know-it-all' Needs Help!30 min
Spreadsheet Functions to Organize Data1 h
Semaine
3

Semaine 3

4 heures pour terminer

Introduction to Filtering, Pivot Tables, and Charts

4 heures pour terminer
7 vidéos (Total 42 min)
7 vidéos
Data Filtering in Excel6 min
Use of Pivot Tables in Excel6 min
More Pivot Table Options5 min
Application of Pivot Tables to Numeric Data8 min
Introduction to Charts in Excel8 min
Week 3 Recap52s
7 exercices pour s'entraîner
Using the “VLOOKUP” Function Across Worksheets30 min
Data Filtering in Excel30 min
Use of Pivot Tables in Excel30 min
More Pivot Table Options30 min
Application of Pivot Tables to Numeric Data4 min
Introduction to Charts in Excel30 min
Introduction to Filtering, Pivot Tables, and Charts1 h
Semaine
4

Semaine 4

5 heures pour terminer

Advanced Graphing and Charting

5 heures pour terminer
7 vidéos (Total 41 min), 1 lecture, 7 quiz
7 vidéos
Bar Graphs and Pie Charts9 min
Pivot Charts5 min
Scatter Plots7 min
Histograms Part 14 min
Histograms Part 27 min
Week 4 Recap46s
1 lecture
End-of-Course Survey10 min
7 exercices pour s'entraîner
Line Graphs30 min
Bar Graphs and Pie Charts30 min
Pivot Charts30 min
Scatter Plots30 min
Histograms Part 130 min
Histograms Part 230 min
Advanced Graphing and Charting1 h

Avis

Meilleurs avis pour INTRODUCTION TO DATA ANALYSIS USING EXCEL

Voir tous les avis

À propos du Spécialisation 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

Foire Aux Questions

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

D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.