Data Analysis in Excel overview
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.
Data Analysis in Excel learning objectives
Upon completing this course, you will 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
- Explore the landscape of data analysis and visualization
Who should take this course?
This data analysis in Excel course is perfect for professionals who want to expand their skill set to include data analysis and visualization in Excel. This course is designed to equip anyone who desires to begin a career in financial analysis or business intelligence—or in other roles that work heavily in Excel—with the skills to create dynamic data-viewing experiences.