Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis.
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
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.