English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 66 lectures (7h 28m) | 3.13 GB
Super-exciting BRAND-NEW Excel Feature for early adopters! Use Pandas, Seaborn, Scikit-Learn & more directly in Excel!
Unlock the Power of Data Science and Finance with Python in Excel 2024 – the BRAND-NEW Excel Feature!
Are you ready to take your data analysis and visualization skills to the next level? Welcome to the “Python in Excel 2024 Masterclass for Data Science,” the ultimate course that empowers Excel users to seamlessly integrate Python into their workflow for enhanced data manipulation, analysis, visualization, and machine learning.
Course Highlights:
Harness the Synergy: Dive into the future of data science by merging Excel’s familiar interface with the limitless possibilities of Python programming.
Data Transformation: Learn how to effortlessly load, clean, and transform your data using Python libraries, supercharging your data preparation processes.
Advanced Analytics: Master the art of statistical analysis and machine learning within Excel using Python’s powerful libraries, opening up new horizons for predictive modeling and decision-making.
Data Visualization: Create stunning charts, graphs, and interactive dashboards using Python’s data visualization libraries to tell compelling data stories.
Financial Analytics: Perform more complex Finance and Investment workflows within Excel using Python’s powerful libraries
Seamless Integration: Discover how to seamlessly integrate Python scripts into your Excel workbooks and automate repetitive tasks, saving you time and effort.
Combination with other powerful Tools: Complementary usage of the brand-new Python in Excel together with xlwings will boost your projects.
What you’ll learn
- Set up and use the brand-new Python in Excel Feature
- Use powerful Python Data Science tools (Pandas, Seaborn, Scikit-learn) directly in Excel
- Explanatory Data Analysis (EDA) and Data Visualization with Python in Excel
- Statistics, Hypothesis Tests and Machine Learning with Python in Excel
- Financial Data and Time Series Analysis with Pandas in Excel
- Merging, Aggregating and Manipulating Tabular Data with Pandas in Excel
- Combining the brand new Python in Excel Feature with other powerful Tools (Xlwings)
Table of Contents
Getting started
1 Welcome
2 How to get the most out of this course
3 Sneak Preview Merging and joining Data with Pandas in Excel
4 Python in Excel How it works & what you need
5 Python in Excel Features & alternative Tools (xlwings)
6 Important Preps before you can set up Python in Excel
7 How to set up Python in Excel (BETA)
8 Troubleshooting
Python in Excel – First Steps and Must Knows
9 Introduction
10 Simple Operations using the PY Function
11 Python Variables vs. Excel Cell References
12 Python Objects and Data Types
13 NoneType Objects
14 Output Types Python Output vs. Excel Value
15 Extracting Data from Python Objects to Excel
16 Diagnostics
17 Calculation Order and Recalculation
18 Initialization Settings and Customizations
19 User-defined Functions and Classes
20 Python Plots (Matplotlib & Seaborn)
Project 1 Explanatory Data Analysis (EDA) with Python and Excel
21 Project Introduction and Downloads
22 Instructions and Hints
23 Excursus Project Solution in a Jupyter Notebook
24 Task 1 How to load and import the Dataset
25 Task 2 Initial Data Inspection
26 Task 3 Univariate Data Analysis 1
27 Task 4 Univariate Data Analysis 2
28 Task 5 Multivariate Data Analysis 1
29 Task 6 Multivariate Data Analysis 2
30 Task 7 Multivariate Data Analysis 3
Project 2 Time Series and Financial Data Analysis with Python in Excel
31 Project Introduction and Downloads
32 Instructions and Hints
33 Excursus Project Solution in a Jupyter Notebook
34 Task 1 How to load the Dataset and Initial Data Inspection
35 Task 2 How to create dynamic Price Charts
36 Task 3 Dynamic Resampling and Financial Returns
37 Task 4 Statistics and Performance Analysis
38 Task 5 Covariance and Correlation Matrix and Heatmaps
Project 3 Merging and aggregating Data with Pandas in Excel
39 Project Introduction and Downloads
40 Instructions and Hints
41 Excursus Project Solution in a Jupyter Notebook
42 Task 1 Creating and Aggregating DataFrames
43 Task 2 Creating a tool to joinmerge Datasets with full flexibility
Project 4 Multiple Regression Analysis, Hypothesis Testing and Preprocessing
44 Project Introduction, Downloads and Hints
45 Coding Solution (Part 1)
46 Coding Solution (Part 2)
47 Coding Solution (Part 3)
48 Implementation & Feature Elimination in Excel (Part 1)
49 Implementation & Feature Elimination in Excel (Part 2)
Bonus Project Using Python in Excel and xlwings together – the ultimate Boost
50 Introduction and Downloads
51 Set up and Installation of xlwings
52 How to use xlwings as a Data Viewer
53 Data Viewer – Update
54 How to connect to an Excel Workbook
55 How to read and write single Values
56 Introduction to Running Python Scripts in Excel & Downloads
57 Installing the xlwings add-in and other preparations
58 Running Python Scripts with Run main
59 Troubleshooting
60 Bonus Project Introduction & Downloads
61 Instruction and Hints
62 Solution
Appendix Installing and working with Anaconda and Jupyter Notebooks
63 Download and Install Anaconda
64 How to open Jupyter Notebooks
65 How to work with Jupyter Notebooks
What´s next (outlook and additional resources)
66 Bonus Lecture
Resolve the captcha to access the links!