VBA vs. Python - Which is better?

Подписаться 613 тыс.

Просмотров 128 тыс.

50% 1

Visit squarespace.com/chandoo to save 10% off your first purchase of a website or domain.
Are you a data analyst and not sure if you need to either VBA or Python? In this video, let me compare these languages and share my opinion & guidance.
⏱ In this video:
=============
0:00 - Introduction & 6 parameters
0:45 - Ease of learning (parameter 1)
1:27 - Immediate application (2)
2:55 - How many places can we use the language? (3)
3:49 - Forgiveness of a language (4)
4:41 - Availability (5)
5:30 - Automation ability (6)
6:58 - So which one to learn?
8:55 - Advice for people who are NOT yet a data analyst
10:06 - Advice for people who are already a data analyst
10:40 - What about other programming languages?
12:09 - Where to learn either Python or VBA?
🐍Resources on Python:
====================
▶ Check out my 1 hour Python tutorial with 3 sample projects - • How to code with Pytho...
‪@programmingwithmosh‬ channel - Watch this 1 hour Python video - • Python for Beginners -...
📕 Recommended BOOK - Python Crash Course - amzn.to/3eHYAY1
👩‍💻 Resources on VBA:
===================
Getting started with VBA - Part 1 video - • Learn VBA & Excel Macr...
All my VBA videos - Playlist - • Learn VBA & Excel Macr...
📗VBA Power Programming Book - amzn.to/3ze3fZM
More on VBA on my website - chandoo.org/wp/excel-vba/
VBA Online class by me - chandoo.org/wp/vba-classes/
~
HAPPY LEARNING :)
🎤📷 Recording gear:
==================
I am using Canon M50 for recording my videos. Blue Yeti X for recording the audio. Camtasia for producing the videos.
See my equipment links here - www.amazon.com/shop/chandoo
Note: the amazon links use my affiliate code.
#VBA #Python

Наука

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 247

@chandoo_ 2 года назад

👉 *Check out **squarespace.com/chandoo* to save 10% off your first purchase. ⏱ *Timestamps* for the video: 0:00 - Introduction & 6 parameters 0:45 - Ease of learning (parameter 1) 1:27 - Immediate application (2) 2:55 - How many places can we use the language? (3) 3:49 - Forgiveness of a language (4) 4:41 - Availability (5) 5:30 - Automation ability (6) 6:58 - So which one to learn? 8:55 - Advice for people who are NOT yet a data analyst 10:06 - Advice for people who are already a data analyst 10:40 - What about other programming languages? 12:09 - Where to learn either Python or VBA?

@jagatkrishna1543 2 года назад

Beautiful ❤️

@wayneedmondson1065 2 года назад

Thanks Chandoo. Good advice all around. I spend most of my day inside EXCEL, so VBA is a natural fit for me. But, would like to learn Python for fun and to expand horizons and knowledge. Thanks for your insights.. always appreciated :)) Thumbs up!!

@roshanreddy7041 Год назад

Hi let me know the resources you referred to and master VBA

@calistussolomon5739 2 года назад

Thanks a lot for clearing the confusion between these two languages. I would go for VBA. You're the best and your explanation is very learner-friendly. God Bless you :)

@suntosh7 2 года назад

I have watched all your videos and in my opinion your doing a great stuff by educating us on BI, VBA and excel learning's.. I am very grateful to you because I have learnt many things from your youtube videos... Thanks for making us educating on these programming..

@chandoo_ 2 года назад

I appreciate that!

@suntosh7 2 года назад

@@chandoo_ Thank you sir...!!

@TripleB-vw1ob 2 года назад

Great video as always! I love the point about formulas being coding. I always try to do something in excel first with formulas before I turn to VBA because VBA raises the complexity for most users.

@chandoo_ 2 года назад

Thanks :) I had to mention those, after all Excel is the original no (low) code programming langauge.

@9019828585 2 года назад

Hi chandoo , thanks for the honest and unbiased inputs.honestly, I will follow your inputs and choose VBA after a huge state of confusion . Really appreciate . I request you to make a video on books vs video to learn any programming language / skills from your perspective .

@kuuuyajim 2 года назад

I agree with your point of view regarding someone who's starting to become a data analyst and someone who's already doing the job. In my work, I tried learning Python but wasn't really able to retain the knowledge because I was learning for the sake of learning and wasn't really applicable to my job. Whereas with VBA or at least basic macro, I was able to accomplish a lot of improvements because we are already using MS Office.

@chandoo_ 2 года назад

Well said! The best thing is, once you know something, you know it. So you will have free time to learn other things. After you have the necessary VBA skills, you can go and learn Python / M / DAX or something else altogether. All the best. 👍

@VernHowChan 2 года назад

thank you, this was a humble sharing in terms of both VBA and Python. I like the statement to be open minded and learn whatever comes along and then use it as needed or as chosen.

@chandoo_ 2 года назад

You are welcome Vern.

@caissa6187 2 года назад

Great information. I'm going to check out your vba videos. Thanks for the help, I've become a new subscriber!

@apurbachatterjee3310 2 года назад

One of the most potent contents on this topic and how well executed! Thank you !!!

@chandoo_ 2 года назад

Glad you liked it! I had so much fun shooting and editing the video too.

@apurbachatterjee3310 2 года назад

@@chandoo_ thank you for your hard work to help make us smart 🤓

@Lone.wolf004 Год назад

so far you're my favorite youtuber. thanks man!

@ommm4169 8 месяцев назад

Thanks Chandoo.. your mentality has brought you to where you are now… well done 👍👍👍

@cuejorge2003 2 года назад

Very good explained chandoo. Thank you so much!!!

@snpatel3850 2 года назад

I was actually really confuse and want to start with VBA and your video pops up, i cant thank enough for this video ,, really really thank you so much

@chandoo_ 2 года назад

Thanks Patel. Many of my students & viewers asked me this question, so I made a video.

@aiasaiascon3894 2 года назад

Just a great video - you are a teacher with humour! and that is a thrilling combination!

@ArmandoReportes 2 года назад

I liked and agreed with your comments. I liked the conclusion, which was kind of a surprise.

@ashishtiwari6555 2 года назад

Thanks Chandoo.. It is great learning.. I have shared ur video's links with my friends who actually need them. You have great skills.. Keep up the good work.

@chandoo_ 2 года назад

You are welcome Ashish. Big thanks for sharing and spreading the good word. More power to you.

@moisestatis5418 9 месяцев назад

Thank you for your honest recommendation.

@vikastiwari7134 2 года назад

I really wanted this topic to someone address, thankyou so much Chandoo

@chandoo_ 2 года назад

Glad it helped Vikas :)

@deepthireddy4725 2 года назад

@@chandoo_ grateful to you for addresses this topic! Much needed at this time!

@mirrrvelll5164 2 года назад

Nice to see a book recommendation, got the same but didnt read it :D yet.... after this video I made up my mind a bit! Thanks!

@mouligodavarthi-yme1701 2 года назад

Thanks alot for this chandoo ji

@pixelmasque Год назад

if you are brand new to programming, learning python via simple 2D games is fun and object oriented. Learning a simple language and basics like functions, variables, classes (objects), and oop allows you to pick up a new language fairly easily, just learning syntax and a few workflow differences.

@kalyanidivakar Год назад

Every sentence flowing from exprential knowledge, even many have but may not sharing, your humble explanations are awesome

@tanyaa9510 2 года назад

Hi Chandoo, I am completely from non tech background willing to learn to code in finance analysis field. Your videos gives a real clarity and are of great value.

@chandoo_ 2 года назад

Thank you Tanya. More power to you.

@samsgridview9652 2 года назад

Eyeopener video for me.. Thanks Chandoo.. :)

@chandoo_ 2 года назад

I am glad it helped Sam... 😀

@Deedington 2 года назад

Thank you very much Chandoo

@simpy17325 2 года назад

I'm switching over to Python from learning R. Seems to be a little more useful. Once I was able to download a PDF, scrape it, and then insert that data into the database I realized how powerful these tools really are.

@chandoo_ 2 года назад

I previously dabbled with R too (you can see my R for Data Science book in the video). I agree that Python makes some of the routine tasks amazingly fast and automated. All the best.

@PatrickRatnaraja Год назад

Oh This is Chandoo. I have used your VBA. Nice to watch your video.

@pythoninoffice6568 2 года назад

Great video! I first learned VBA but realize it was very limited to the MS Office, and I wanted to do more than that. Then I learned Python and actually never looked back. I tried to use Python whenever I need to automate Excel or data related things. That said, I totally agree that programming languages are just tools, and we as users have to decide what's the right tool to use for a given case.

@Adi_Azure Год назад

Great @python in office

@Adi_Azure Год назад

Great

@drdeepee2503 Год назад

I would've probably done the same. Except where I work (highly regulated industry), Python is next to impossible to get installed on your machine. VBA is right there.

@pythoninoffice6568 Год назад

@@drdeepee2503 I understand some companies don't want to take the risk, but I think they need to understand what risk is involved before making the decision to ban it. I work in insurance, which is also a highly regulated industry, and we are allowed to use open-source tools like Python or R.

@CodingIsFun 2 года назад

Great video! Thanks for sharing your opinion. I could not agree more. Sadly Python is rarely allowed in companies, while VBA gets you going fast and without any additions to Excel. In addition, VBA allows me to let other colleagues use my code without installing python or anything else. Of course, you could also package a .exe with python, but in many cases, the internal IT blocks most .exe files from running.

@chandoo_ 2 года назад

Thank you. Yes, that is what I found when I work at client places too.

@BalrogsHaveWings Год назад

Thank you very much for explaining this. Sometimes I dream of VBA and Python Offspring

@nupursarkar8737 Год назад

HI Chandoo! Thanks for the amazing share ... Could you please tell us when does the point come when we use other tools other than excel for data analysis where excel has shortcomings? I mean it could be data size or visualization anything it could be.. just let us know

@vinodmathew3036 2 года назад

Good advice Chandoo

@j3553hh 11 месяцев назад

I followed your advice six months ago, and I'm very glad! I was interested in learning a coding language for data handling in my job. I went with VBA because you said that those of us using Excel will have an immediate practical application. That was very true. I took three VBA courses and now I'm far more advanced in Excel than anyone at my 400 person company. And now I'm learning Python with the right perspective! I'm so glad I followed your advice and got that foundation with VBA. Thank you so much!

@chandoo_ 11 месяцев назад

Wow.. awesome to hear that. More power to you ⚡

@amarkate6172 Год назад

your thoughts always give great direction for long life distance

@kyiwintun4253 2 года назад

I did indeed watched "Programming with Mosh", and I really enjoyed how he explained it. Chandoo, thank you very much for the videos. I really appreciate your efforts. The organization I worked 90% uses Microsoft office so, I feel like I need to learn VBA and Macros. Can you kindly me tips on where I can learn VBA and Macro basics?

@shaikusman536 Год назад

Awsome chandooo...Good comparisiion...We We should be loyal to our skills...NOT Languages/Tools...Respect from Blr....

@emtionaldamage112 2 года назад

Your every video is amazing, unlike others you are pretty honest in whatever u teach. May Allah bless you.

@BenDieselBasicAutomotive Год назад

Thank you for the knowledge..

@belkacemseffari7404 2 года назад

Indians being solving modern problems like heroes . a big thanks to every Indians programmer and teachers In youtube, XDA, every platform. you guys are amazing and for sure one of the intelligent people in the globe

@chandoo_ 2 года назад

Thanks for the appreciation and love Belkacem. 😍😀

@janmejayamishra9308 2 года назад

Chandoo is the best... long time follower of your website for vba and excel.. keep up the great job👍👍

@chandoo_ 2 года назад

Thanks Janmejaya... 😀

@silvestrecamposano6317 Год назад

Thanks again, Professor...

@arslanmughal2024 2 года назад

Sir, Can you please make a short video about Excel SQL. Is it advanced VBA ? I'm confused as some job listings (Data analysts) requires you to have SQL experience.

@amit15491 2 года назад

Thanks Chandu. I am following you since decade.. Thanks for sharing for all VBA and Python information.. Looking forward and stay blessed.

@chandoo_ 2 года назад

Wow.. it is always a pleasure to interact with long time followers like you. Thanks for the blessings & love. 😍

@gyana441 2 года назад

Was Looking for this video.

@chandoo_ 2 года назад

😀😀😀

@Jeddles Год назад

your line of code to download all the comments from a youtube video was really interesting

@resilientprogrammer8466 2 года назад

Thanks for recommending Mosh. He's my instructor and he's very explicit in his teaching.

@chandoo_ 2 года назад

Yeah... Mosh is awesome :)

@behrad9712 Год назад

thank you!🙏

@nikitampmaurya 2 года назад

Thank you so much!!

@junaidrizvi9884 2 года назад

Thanks chandoo👍

@chandoo_ 2 года назад

You are welcome Junaid... :)

@emadabuhagag222 2 года назад

very helpful , thank you

@bgowda6989 Год назад

Nice information thank you so much

@teoxengineer 2 года назад

Chandoo hi, This comparison is so useful and applicable. However, you could make your tutorial enrich if you had added some screen examples which can be seen the functionality of two programming languages. Thanks

@chandoo_ 2 года назад

Thanks Emre.. Good suggestion on adding screen examples. I will do a follow-up video in a few weeks time on that.

@operator8194 Год назад

Thank you.

@BryanMendez120 Год назад

Because Python has libraries, it makes a lot easier to work with data... I know VBA anf Python and certainly I would choose this last one

@hi-tech-1149 Год назад

Hi Sir, Could you please guide me how to make automation using python software. I would like to automate some repetitive task which is kind input entry in some simulation software to get the output.

@mathewinmuscat 2 года назад

Sir, you did not mention charting ability in python, particularly with PBI.

@chandoo_ 2 года назад

Yes... that was one thing I had on my notes but skipped.

@richardcarlin1332 2 месяца назад

VBA is really great if you want to automate while you are in and using, for example, Excel or Word. Python is great for automating from outside Excel or Word. In Python from the outside you can run Word or Excel macros, so when you actually open Excel or Word, you will be looking at the finished result. No requirement for the user to press buttons.

@sibongilethwala7080 11 месяцев назад

Thank you

@manuelnilo6460 2 года назад

but the big question is: when is Python going to be integrated in Excel as VBA is??

@uthoshantm 2 года назад

You do not need Python to be integrated with Excel. Excel contains your data, Python does the processing.

@chandoo_ 2 года назад

There are also packages that can process / automate Excel files with Python. Just search.

@smarannayak7357 2 года назад

Tbh no, Office Scripts is based on JavaScript. I guess Microsoft is moving towards that more than Python. But python still has tons of packages that work with excel.

@vinodmathew3036 2 года назад

Never. Microsoft is more interested in integrating Typescript (Office Scripts).

@sreejeshjnair6755 2 года назад

Thanks for considering my comment

@chandoo_ 2 года назад

You are welcome Sreejesh.. Many of our viewers requested this topic. So I made a video :)

@mdmilonmahamud7908 10 месяцев назад

I want to Microsoft Office & Google sheet Automation. For this which is better for me VBA or Python? Please reply

@shernawabkhan232 Год назад

wonderful conclusion dont have loyal to one program, keep learning.

@bharathserji1276 2 года назад

After saving pdf file how to make it open automatically?

@jrm250 2 года назад

I got my nephew a Raspberry Pi for Christmas a few years ago and learned some very basic Python. I realized that it looked very similar to how my recorded macros look in excel and learned that it was actually a programming language called VBA. I now use VBA extensively at work and likely would not have gotten my recent promotion without it.

@SageRudra Год назад

Is VBA easy to learn for non coders and is it a part of advanced Excel? If I learn VBA will python be easy for me? I am a mechanical design engineer with no programming knowledge or experience.

@jrm250 Год назад

@@SageRudra Learning one programming language will certainly help to learn others. I only really use VBA, but with a few google searches, and trial and error, I have been able to create code for Google Sheets scripts on a few occasions.

@SageRudra Год назад

@@jrm250 Do I need to be strong in mathematical concepts like Algebra, statistics and graph theory for python or VBA?

@sanketv1 2 года назад

PLEASE I have the project of getting some data from a dynamic website(which updates in realtime) to excel & further to process it for the result that can help me to take the decision- in this condition which is better -python or VBA? PLEASE

@FlyingSweep 2 года назад

Great Thank you!

@chandoo_ 2 года назад

You're welcome!

@venkatiyer7459 Год назад

Guru ... Correct me whether I am seeing Power Point when you say Access .... or it is voluntary

@yogeshvaghu17 Год назад

Hey, I have some query .. How can I link my excel sheet with ERP oracle software.. Expecting a response on this comments from any member of author

@vegaswould Год назад

i think VBA is better depending on skill level and what goal you're trying to accomplish. macro recording automatically writes your VBA code for you when doing simple tasks. as far as i know, you can't do that with python :) (would be amazing if you could though)

@vinaymanchanda6526 2 года назад

Hi @chandoo , Can you please create a playlist just for Automation through VBA and/or python

@chandoo_ 2 года назад

Here it is - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nerIcLV7a2s.html

@JuFF1989_FI 2 года назад

Does a possibility of getting employed as a data analyst prior to learning coding really exist?

@JoshAutomates 2 года назад

And having excellent foundation in VBA helps you learn other programming languages a lot faster. Let's thrive in data crunching!

@chandoo_ 2 года назад

Bingo!!! VBA, the gateway to programming addiction since 1993.

@AliMadoobe 2 года назад

ArcGIS gives you options to use VBA, Python and SQL

@chandoo_ 2 года назад

Didn't know that...

@dominicatuahene7303 2 года назад

Hello Chandoo, what is the link to your website please

@brittokhan5278 19 дней назад

Do we need to learn c programming before? Or c++ ?

@sakthii2403 10 месяцев назад

Hi chandoo, I m working in shipping industry all my daily works are in Excel like (data extraction, Data cleansing, after cleaning need to filling gap using lookup formulas , after filling gap need to organizing data, Data Transferring to msword template and also consolidation), and i handle VBA which already created if is there any error occurs while running means my team mate (now he left from my company) guided me, so i can able to debug existing vba code. In my project my company using Excel only. Right now no one know VBA in my team, mostly all our teammates are doing repetitive tasks every day. Now i m planning to learn VBA or Python or RPA. i m not that much good in coding (I Know basic SQL, PLSQL) could you please suggest me which one i need to learn right now.(if i learn VBA is that good for future? or directly can i learn python or RPA tools?) When i research I came to know RPA tools like Uipath have a drag and drop option and that RPA tools also automate excel tasks, do's RPA tools can able to automate my daily works which I said above? I m in confusing stage please help me to take currect decision.

@anarkiamusicmovie7036 2 года назад

I learn VBA since 1years because in Mechanical it is THE KING, all sofware as CATIA or SolidWOrks use VBA with Excel often xD

@chandoo_ 2 года назад

Didn't know that. 😀

@adreetadas2032 2 года назад

Hi Chandoo, do you know of any resources that can help integrate already created excel VBA with python?

@chandoo_ 2 года назад

I am not familiar with such tools.

@AdityaSingh24 2 года назад

Hi Chandoo, can you please explain what does that 100 line code does?

@chandoo_ 2 года назад

I did mention in the video. But the code is a set of macros to automate letter generation & emailing for employee salary review outcomes.

@jagannathhup9083 Год назад

What are the best books for python for learners

@suprabhaparab7610 2 года назад

The domain is also important.for example If we take finance industry then anyone who works in financial modeling then VBA is non negotiable and if the person is in trading then nowadays python is the must

@chandoo_ 2 года назад

Very good point. That said, most people will go thru a few domains in their life. I started off in Pharmaceutical, then went to insurance, then to tech, and now do a bit of HR.

@36chethan 8 месяцев назад

Hi chandoo, As python is now available in Excel could you please try to create new videos on this topic as i know the basics of both vba and python. And i use everyday vba towards my office work

@PaulRoneClarke 2 года назад

Learn whichever you want/need or is more immediately first - then 6 months later learn the other - the skills you acquired learning the first are almost directly transferrable to the second. So you don't lose either way. If you work in a company that uses Excel a lot (and so many many companies still do) then maybe prefer VBA first. If not, if you want a little extra flexibility, learn Python first. Learning a second similar OO language will take a fraction of the time of learning your first. You'll be coding in your second language in no time once you've mastered your first. That's why so many coders know several languages. It generally gets easier to pick up new languages as you go on. I know a guy who is proficient in Java, C#, C++, Python, Javascript, VB, F, Ruby, as well as knowing CSS, HTML and PHP as well as anyone I know - and legacy languages like Pascal, Cobol, Lisp and Fortran. When a new dialect comes out like Kotlin - he's coding to a staggeringly good standard in it inside one or two days. TLDNR? It matters a lot less than most people think.

@RohitSingh-ml9zb 2 года назад

please make more videos about VBA topice, codes.

@hemanthkumar4870 2 года назад

Chandoo...u have a good sense of humor 🤣😀

@chandoo_ 2 года назад

I love a good joke (and biryani 🥘 too).

@rahulmane3948 Год назад

Dear all, Can you pls confirm how and from where we can learn VBA?

@johnmosheim 2 года назад

Can Python be used inside of Excel like VBA to manipulate spreadsheet elements from the inside?

@SeetheAutmon Год назад

Multiple languages can be used to modify the data inside a spreadsheet. However, only VBA can be used inside Excel and other Microsoft Office products.

@useme2275 2 года назад

Please make a video on how not to make mistakes and keep spreadsheets error free.

@BufordTJustice42069 2 года назад

A man that dares ask THE question.

@GinMotoLoko Год назад

decided to go to c++ to create my own VBTHON :)

@samarmushtaq3979 Год назад

Sir Could you explain how to learn R programming language

@urbaneplanner Год назад

Good advice - personally, I would agree that if you are working in a corporate environment where Microsoft products are used, learning vba is a terrific and efficient use of time. Advanced excel skills, including vba and also as you note, working with formulas, may be enough to super - charge your abilities and dramatically improve your productivity. Python, on the other hand, gets you involved with many applications outside of Microsoft. If you want to be programming more generally, it seems like python would be superior. However, not everyone will want to do this sort of more general programming - and if you do, basic python skills are really just the tip of the iceberg. The only slight caveat to this relates to indenting- for a beginner, it can be frustrating to deal with python’s fussiness about indents. This can distract from other learning as your code can break for indenting reasons. Vba doesn’t have this characteristic, so it may be a better language to start with.

@Aditya-um6wc Год назад

Any book for the VBA crash course?

@amoljondhalekar4917 2 года назад

Any one please recommend job for mis profile for thane location

@FaisalReacts Год назад

A great feature of VBA is you just know how use formulas and functions in Excel and record Macros, and it will convert into a VBA program itself.. there's no such a thing in Python related to Excel