Fundamentals of Data Analysis in Excel
About this course
Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. Finally, you’ll visualize those insights by building a dashboard in Excel. You’ll apply these skills using modern functionality like dynamic array formulas, linked data types, and Ideas in Excel. You’ll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales. By the end of the course, you'll be able to: ● analyze a dataset using native Excel tools ● apply Excel tools and formulas to transform and structure your data ● create pivot tables to slice and dice your data ● visualize data with pivot charts and Excel Charts ● describe the landscape of data analysis and visualization
90/100
CourseAsk score
- What the provider tells you
- 39/45
- Who stands behind it
- 35/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- analyze a dataset using native Excel tools
- apply Excel tools and formulas to transform and structure your data
- create pivot tables to slice and dice your data
- visualize data with pivot charts and Excel Charts
Course objectives
- describe the landscape of data analysis and visualization
Price shown by Coursera — confirm on their site.
Enroll on CourseraYou'll be redirected to Coursera to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
edX
Coursera
Udemy
Compared on these lists
Where this course ranks against the alternatives.