Turn Your Excel Sheet Into An Interactive Application Using Python (Full Project)

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This tutorial will teach you how to create interactive applications using Excel and Python. Learn how to use Python scripts to execute tasks and combine the two in one seamless coding environment. In this video, we will build an application to download YouTube videos as mp3 files, convert the audio files to text using the AssemblyAI API and finally create a word cloud based on that text file.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Introduction
00:48 – Installation dependencies
01:40 – Create an Excel starter template
04:34 – Prepare the worksheet
08:44 – Download a YouTube video mp3
11:40 – Transcribe the audio file
16:59 – Create the word cloud
18:15 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[patloeber]

The king of Python+Excel automation :)

[CodingIsFun]

🚨 *Because youtube changed something on its end, you might get the following error message* 🚨
get_throttling_function_name: could not find match for multiple

[TimePasser]

You are amazing man.. Thank you very very much. I really appreciate your work and dedication. I love streamlit because of your videos. In my work I started using streamlit and management quite impressed with this approach. Keep it up buddy.

[nagendravishwamitra]

Absolutely Super !! Such a inspiring coder!! Always brings new things !!

[KhalilYasser]

Really amazing and inspiring. I have learned a lot from you.

[yigitcelik]

thank you a lot. your videos are so informative and easy to understand.

[elsheep]

Fantastic and inspiring. Thank you. I code for fun and use excel for work.Python is so much neater and more powerful than excel VBA. I now mix fun projects into my work :) p.s. The tool belt is excellent and a real time saver. It took me less than 10 minutes of using the free version to decide to upgrade!

[Yosalsafiesta]

Hey buddy thanks so much for sharing! By the way I got another application for you. Super easy to work out montecarlo simulations with excel and python. Most financial models are in corporate finance are in excel. You can use Win32 to open up excel, randomly input values in your cells, extract the output and graph the results. Super useful for risk managemet!

[pixelmasque]

building a GUI type interactivity (data input and visual icons) on an excel table with Python to share interactivity between 3 sheets. is it possible to do this and upload it to OneDrive as a shared excel web application? Or is it for desktop only?

[OmerMan]

Hi, can you make a follow-up video showing how you turn this into a web app please? Thanks for the great info!

[holybusta]

I created a data entry form for my persomal business, i gave it too much time created a macro enabled button for entries in excel but at the end when i completed it i download the file in my mobile but macro vba is not working in mobile can i create something dashboard kinda data form which works on mobile for entries in excel sheet please help

[ahmedelhaddad]

thank u so much, pls how to fix this
Error

Traceback (most recent call last):

File "<string>", line 1, in <module>

ModuleNotFoundError: No module named 'transcriber'

[emmanuelronstadt]

When I try to run the SampleCall I get this error message: sh: python: command not found, do you by any chance know why? As I followed your instructions 1to1.

[KhalilYasser]

I got an error message `Traceback (most recent call last):

File "<string>", line 1, in <module>

AttributeError: module 'xlwings.utils' has no attribute 'prepare_sys_path'`

[hakimdz]

I have a question, how can I contact you?