Advanced Python in Excel: Data Analysis and Visualization
46mAdvanced2024-08-08
Authors
Sarah Nooravi
Data Analyst and Educator
Course details
In this course, learn how to use Python to go beyond Excel’s limited functionalities to perform complex data analysis and visualizations. Instructor Sarah Om details how Python’s integrations with Excel bring new dimensions of functionality, allowing for more advanced data manipulation, automation, and visualization than ever before. Sarah shows you how to leverage Python’s powerful libraries for data analysis to transform raw data into meaningful insights and stunning visualizations—right from the familiar Excel environment.
Skills covered
Data VisualizationSpreadsheetsMicrosoft ExcelPythonData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Do more with data using Python in Excel
- 02 - What you should know
1. Exploratory Data Analysis
- 03 - Data used in this course
- 04 - Data preparation for analysis
- 05 - Augment data - Turn trends into insights
2. Trends
- 06 - Natural language processing
- 07 - Python or Excel
- 08 - Visualize trends
- 09 - Capstone - Step 1
3. Predictions
- 10 - Predictive tools - Shaping future strategies
- 11 - ARIMA
- 12 - Advanced visualizations
- 13 - Outlier detection
- 14 - Capstone - Step 2
4. Dashboard for Consistent Monitoring
- 15 - Build an effective dashboard
- 16 - Build an effective dashboard - Apply your skills
- 17 - Capstone - Step 3
5. Capstone Project
- 18 - Final project walk-through
Conclusion
- 19 - Next steps