課程信息

919,391 次近期查看

學生職業成果

48%

完成這些課程後已開始新的職業生涯

41%

通過此課程獲得實實在在的工作福利

10%

加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始,按照自己的計劃學習。
第 1 門課程(共 5 門)
可靈活調整截止日期
根據您的日程表重置截止日期。
完成時間大約為20 小時
英語(English)
字幕:英語(English), 西班牙語(Spanish), 阿拉伯語(Arabic)

您將獲得的技能

Lookup TableData AnalysisMicrosoft ExcelPivot Table

學生職業成果

48%

完成這些課程後已開始新的職業生涯

41%

通過此課程獲得實實在在的工作福利

10%

加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始,按照自己的計劃學習。
第 1 門課程(共 5 門)
可靈活調整截止日期
根據您的日程表重置截止日期。
完成時間大約為20 小時
英語(English)
字幕:英語(English), 西班牙語(Spanish), 阿拉伯語(Arabic)

提供方

莱斯大学 徽標

莱斯大学

教學大綱 - 您將從這門課程中學到什麼

內容評分Thumbs Up92%(16,926 個評分)Info
1

1

完成時間為 5 小時

Introduction to Spreadsheets

完成時間為 5 小時
8 個視頻 (總計 40 分鐘), 5 個閱讀材料, 7 個測驗
8 個視頻
Reading Data into Excel7分鐘
Basic Data Manipulation in Excel5分鐘
Arithmetic Manipulation in Excel4分鐘
Basic Functions in Excel6分鐘
Functions Using Absolute and Relative References6分鐘
Functions Explained7分鐘
Week 1 Recap51
5 個閱讀材料
Course FAQs10分鐘
Pre-Course Survey10分鐘
Store Sales (Comma delimited).txt10分鐘
Store Sales (Fixed width).txt10分鐘
Stores Sales (Tab delimited Text).txt10分鐘
7 個練習
Reading Data into Excel30分鐘
Basic Data Manipulation in Excel30分鐘
Arithmetic Manipulation in Excel30分鐘
Basic Functions in Excel30分鐘
Functions Using Absolute and Relative References30分鐘
Functions Explained30分鐘
Introduction to Spreadsheets1小時
2

2

完成時間為 5 小時

Spreadsheet Functions to Organize Data

完成時間為 5 小時
8 個視頻 (總計 44 分鐘)
8 個視頻
The “IF” Command in Excel Using Numerical Data3分鐘
The "Nested IF" Command in Excel7分鐘
The "VLOOKUP" Function in Excel8分鐘
Another "VLOOKUP" Example6分鐘
The "HLOOKUP" Function in Excel4分鐘
Professor 'Know-it-all' Needs Help!4分鐘
Week 2 Recap40
8 個練習
The "IF" Command in Excel30分鐘
The “IF” Command in Excel Using Numerical Data30分鐘
The "Nested IF" Command in Excel30分鐘
The "VLOOKUP" Function in Excel30分鐘
Another "VLOOKUP" Example30分鐘
The "HLOOKUP" Function in Excel30分鐘
Professor 'Know-it-all' Needs Help!30分鐘
Spreadsheet Functions to Organize Data1小時
3

3

完成時間為 4 小時

Introduction to Filtering, Pivot Tables, and Charts

完成時間為 4 小時
7 個視頻 (總計 42 分鐘)
7 個視頻
Data Filtering in Excel6分鐘
Use of Pivot Tables in Excel6分鐘
More Pivot Table Options5分鐘
Application of Pivot Tables to Numeric Data8分鐘
Introduction to Charts in Excel8分鐘
Week 3 Recap52
7 個練習
Using the “VLOOKUP” Function Across Worksheets30分鐘
Data Filtering in Excel30分鐘
Use of Pivot Tables in Excel30分鐘
More Pivot Table Options30分鐘
Application of Pivot Tables to Numeric Data4分鐘
Introduction to Charts in Excel30分鐘
Introduction to Filtering, Pivot Tables, and Charts1小時
4

4

完成時間為 5 小時

Advanced Graphing and Charting

完成時間為 5 小時
7 個視頻 (總計 41 分鐘), 1 個閱讀材料, 7 個測驗
7 個視頻
Bar Graphs and Pie Charts9分鐘
Pivot Charts5分鐘
Scatter Plots7分鐘
Histograms Part 14分鐘
Histograms Part 27分鐘
Week 4 Recap46
1 個閱讀材料
End-of-Course Survey10分鐘
7 個練習
Line Graphs30分鐘
Bar Graphs and Pie Charts30分鐘
Pivot Charts30分鐘
Scatter Plots30分鐘
Histograms Part 130分鐘
Histograms Part 230分鐘
Advanced Graphing and Charting1小時

審閱

來自INTRODUCTION TO DATA ANALYSIS USING EXCEL的熱門評論

查看所有評論

關於 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

常見問題

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

還有其他問題嗎?請訪問 學生幫助中心