Introducing Python in Excel - Create Dynamic Dashboard using Python + Excel + ChatGPT Part 2 смотреть онлайн

Welcome to Part 2 of our exciting series, "Introducing Python in Excel - Create Dynamic Dashboard using Python + Excel + ChatGPT"! ?

In this tutorial, we'll dive deep into the world of financial analysis and show you how to harness the power of Python right within Excel, all while leveraging the capabilities of ChatGPT for additional insights and guidance.

In this episode:
? We'll start by setting up Python in Excel and preparing our data for analysis.
? Learn how to use Python libraries for data manipulation and visualization.
? Build a dynamic financial analysis dashboard that updates in real-time.
? Explore the capabilities of ChatGPT to provide context and answer your questions.

Whether you're a finance professional, a data enthusiast, or simply curious about combining Python, Excel, and AI, this series is designed to empower you with the knowledge and skills to excel in your financial analysis endeavors.

Don't forget to subscribe and hit the notification bell so you won't miss any of the upcoming parts in this series. If you have any questions or topics you'd like us to cover in future episodes, feel free to leave them in the comments section below.

Let's embark on this exciting journey of financial analysis with Python, Excel, and ChatGPT! ???

#excel, #vbamacros #MSofficeScript #ChethanaPixel #python #chatgpt #excel #financialmodeling #financialanalysis #financialanalyst

00:00 Introducing to Part 1 Python in Excel
00:46 Dynamic Dashboard using Slicers
01:39 Creating Filtered Data frame
03:09 Link Slicer to Python code for charts
04:40 Dynamic Dashboard using Data Validation
06:02 Link Data validation to Python code for charts
06:58 Wrap-up

Python in Excel Part 1: https://youtu.be/ByQTxh8M1fE
Financial Raw data: https://go.microsoft.com/fwlink/?LinkID=521962
Excel | Anaconda: https://www.anaconda.com/excel
ChatGPT: https://chat.openai.com/
Seaborn Chart Gallery: https://seaborn.pydata.org/examples/index.html
Github Sample data: https://github.com/mwaskom/seaborn-data/blob/master/mpg.csv
Power Query Series: https://www.youtube.com/playlist?list=PLAJojq_HX3tYVVd0bT42Qsu0GwFa9z5-9

JOIN us for more FUN:
https://www.youtube.com/@ChethanaPixel?sub_confirmation=1

Play List: https://www.youtube.com/c/Chethana/playlists

Instagram: https://www.instagram.com/chethanas_/

Facebook: https://www.facebook.com/ChethanaSolutions

Twitter: https://twitter.com/ChethanaPixel

Telegram: https://t.me/ChethanaPixel

Thank you!!!