Python in Excel 2023 Masterclass for Data Science

Focused View

Alexander Hagmann

5:50:46

44 View

1. Getting started

1. Welcome.mp4

02:03

2. How to get the most out of this course.mp4

05:27

3. Python in Excel How it works & what you need.mp4

02:48

4. Python in Excel Features & alternative Tools (xlwings).mp4

10:00

5. How to set up Python in Excel (BETA).mp4

03:11

6. Troubleshooting.mp4

05:36

2. Python in Excel - First Steps and Must Knows

1. Introduction.mp4

01:57

2.1 Book1 SimpleOps.xlsx

2. Simple Operations using the PY Function.mp4

12:04

3.1 Book2 Variables vs References.xlsx

3. Python Variables vs. Excel Cell References.mp4

07:14

4.1 Book3 DataTypes.xlsx

4. Python Objects and Data Types.mp4

12:30

5.1 Book4 NoneTypes.xlsx

5. NoneType Objects.mp4

09:17

6.1 Book5 OutputTypes.xlsx

6. Output Types Python Output vs. Excel Value.mp4

08:21

7.1 Book6 ExtractData.xlsx

7. Extracting Data from Python Objects to Excel.mp4

06:09

8.1 Book7 Diagnostics.xlsx

8. Diagnostics.mp4

04:57

9.1 Book8 CaluclationOrder.xlsx

9. Calculation Order and Recalculation.mp4

13:31

10.1 Book9 Initialization.xlsx

10. Initialization Settings and Customizations.mp4

08:23

11.1 Book10 Functions.xlsx

11. User-defined Functions and Classes.mp4

03:02

12.1 Book11 Plots.xlsx

12. Python Plots (Matplotlib & Seaborn).mp4

08:31

3. Project 1 Explanatory Data Analysis (EDA) with Python and Excel

1.1 Project1 EDA.zip

1. Project Introduction and Downloads.mp4

03:49

2. Instructions and Hints.mp4

08:23

3. Excursus Project Solution in a Jupyter Notebook.mp4

03:55

4. Task 1 How to load and import the Dataset.mp4

07:47

5. Task 2 Initial Data Inspection.mp4

13:04

6. Task 3 Univariate Data Analysis 1.mp4

08:40

7. Task 4 Univariate Data Analysis 2.mp4

05:12

8. Task 5 Multivariate Data Analysis 1.mp4

06:15

9. Task 6 Multivariate Data Analysis 2.mp4

07:27

10. Task 7 Multivariate Data Analysis 3.mp4

07:39

4. Project 2 Time Series and Financial Data Analysis with Python in Excel

1.1 Project2 FinancialDataAnalysis.zip

1. Project Introduction and Downloads.mp4

00:59

2. Instructions and Hints.mp4

06:33

3. Excursus Project Solution in a Jupyter Notebook.mp4

02:21

4. Task 1 How to load the Dataset and Initial Data Inspection.mp4

06:08

5. Task 2 How to create dynamic Price Charts.mp4

11:03

6. Task 3 Dynamic Resampling and Financial Returns.mp4

09:17

7. Task 4 Statistics and Performance Analysis.mp4

09:17

8. Task 5 Covariance and Correlation Matrix and Heatmaps.mp4

05:21

5. Bonus Project Using Python in Excel and xlwings together - the ultimate Boost

1.1 First Steps.zip

1. Introduction & Downloads.mp4

02:59

2. Set up and Installation of xlwings.mp4

01:38

3. How to use xlwings as a Data Viewer.mp4

07:24

4. Data Viewer - Update.mp4

01:26

5. How to connect to an Excel Workbook.mp4

07:28

6. How to read and write single Values.mp4

05:56

7.1 RunPython.zip

7. Introduction to Running Python Scripts in Excel & Downloads.mp4

01:14

8.1 Add-in File Download.html

8. Installing the xlwings add-in and other preparations.mp4

08:44

9. Running Python Scripts with Run main.mp4

04:41

10.1 Troubleshooting Link.html

10. Troubleshooting.mp4

04:32

11.1 Case Study.zip

11. Bonus Project Introduction & Downloads.mp4

07:31

12. Instruction and Hints.mp4

06:19

13. Solution.mp4

06:39

6. Appendix Installing and working with Anaconda and Jupyter Notebooks

1. Download and Install Anaconda.mp4

06:15

2. How to open Jupyter Notebooks.mp4

12:24

3. How to work with Jupyter Notebooks.mp4

17:25

7. Whats next (outlook and additional resources)

1. Bonus Lecture.html

Description

Super-exciting BRAND-NEW Excel Feature for early adopters! Use Pandas, Seaborn, Scikit-Learn & more directly in Excel!

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)

Who is this for?

Data Scientists and Finance Professionals seeking to use Excel as Frontend and Python as analytical Backend in their Projects.

Python Data Scientists seeking to perform their work in Excel

Frequent Excel Users seeking to boost their work results with Python Code in Excel

What You Need to Know?

A Windows desktop computer with a valid Microsoft 365 Subscription installed (MAC & Linux not supported)

An internet connection capable of streaming HD videos.

Basic Excel and Python Coding skills

More details

Description
Unlock the Power of Data Science and Finance with Python in Excel 2023 - 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 2023 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.

Who Is This Course For?
Excel enthusiasts looking to expand their skill set and explore Python's data analysis capabilities.
Data analysts, business analysts, and finance professionals wanting to leverage Python's advanced analytics tools without leaving the Excel environment.
Data science aspirants eager to gain hands-on experience in using Python for real-world data projects.
Anyone seeking to enhance their career prospects by mastering the latest data analysis techniques.
Why Choose This Course?
Up-to-date Content: Stay ahead of the curve with the latest Python integration features in Excel 2023.
Practical Learning: Dive into hands-on projects and exercises that reinforce your skills.
Expert Guidance: Benefit from the knowledge of experienced instructors who simplify complex concepts.
Certificate of Completion: Showcase your newfound skills with a Udemy certificate upon course completion.
Instructor Profile:
Your course instructor, Alexander Hagmann, is a seasoned data scientist and finance professional with >15 years of experience in both Excel and Python. He has designed this course to help you bridge the gap between Excel and Python, making data analysis and visualization more accessible and powerful than ever before.

Note: This course assumes a basic understanding of Excel and some prior knowledge of Python. A valid Microsoft 365 Subscription on a Windows machine is needed (MACÂ and Linux are currently not supported!)
Who this course is for:
Data Scientists and Finance Professionals seeking to use Excel as Frontend and Python as analytical Backend in their Projects.
Python Data Scientists seeking to perform their work in Excel
Frequent Excel Users seeking to boost their work results with Python Code in Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Alexander is a Data Scientist and Finance Professional with more than 10 years of experience in the Finance and Investment Industry. He is also a Bestselling Udemy Instructor for - Data Analysis/Manipulation with Pandas- (Financial) Data Science- Python for Business and Finance- Algorithmic TradingAlexander started his career in the traditional Finance sector and moved step-by-step into Data-driven and Artificial Intelligence-driven Finance roles. He is currently working on cutting-edge Fintech projects and creates solutions for Algorithmic Trading and Robo Investing. And Alexander is excited to share his knowledge with others here on Udemy. Students who completed his courses work in the largest and most popular tech and finance companies all over the world. Alexander´s courses have one thing in common: Content and concepts are practical and real-world proven. The clear focus is on acquiring skills and understanding concepts rather than memorizing things. Alexander holds a Master´s degree in Finance and passed all three CFA Exams (he is currently no active member of the CFA Institute).

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.