Do you need VBA ?

Do you need to learn VBA? 🤔📄🔍 

The quick answer is no. 🚫 To understand why, watch the entire video above for a detailed explanation. 📹👍 

If you liked the video then share it with your friends and subscribe.

#️⃣ Social Media #️⃣

[officesuperhero]

VBA is so much more than data cleaning. There are things that you cannot do with power query that can be done with VBA. You are mixing apples and oranges. I know both. And they are different.

[renjithomas]

VBA is for automation and power query is for data clearing, propere VBA coding does not need maintenance, it just run without any problem for years.

[Awachupi]

Woooow. I am using PQ a lot for my data cleaning. I have recently been covering for a colleague whose job is very manual, sending e-mails with attachments each day. If you show me how to automate this with PQ, I think you should at least get a Nobel. I think it would be worth adding that PQ is great for data cleaning while VBA can automate many other tasks.

[AbuUmar-bn]

Sorry, there are plenty of things you can do on VBA which PQ still cannot do... btw, I use both!

[perfect_chaos]

i disagree with u. VBA can work wrll with power query and can help u understand how excel worla more

[qurbankhattak]

Here is a case scenario;
I have a list of employees, that were given a commission on selling a real estate property. Every plot has a unique number. I want to filter an employee and see how many plots he sold and how much commission he got. But I am concerned that some other employee might also have received a commission.

So I need a way that whenever I select an employee I get a summary of his commission as well as all the other employees that got the commission on his plots. This is only possible by dynamically filtering the list. I believe this is where VBA shines, to provide customised tools.

Can you create a dynamic list and then on top of it a dynamic filter in Power Query. The answer is NO! That's why VBA will never loose its place in Data Analytics

[jaedonbigbrain]

Power query is a complement of vba if you want to develop a software in excel you need VBA and complements like power query, power pivot, xlmachine among other is versatil

[vkas]

how can you compare VBA with Power query ..? aren't these two different things ?

[Paladin]

What rubbish. Power Query and VBA are totally different tools. Just because there is crossover between VBA and PQ doesn’t mean PQ can do everything VBA can. It’s true that PQ is easier to use and it is a great tool but it’s ridiculous to say that PQ is as powerful as VBA because VBA can do everything PQ can (just not as easily). But PQ can NOT do everything that VBA can, and by a considerable margin.

[kaushalkumar-fkxr]

There are plenty of job in VBA and used in big MNC. You can create user form with VBA, power query can't and still VBA is used widely

[torgal]

Your are wrong dear friend. VBA will never die and it will be there till last breathing of Microsoft office. There are plenty of jobs on VBA. Yes it is old langauge and this is the time for power BI but still VBA will be there for many years to come.

[marianpascu]

VBA is the "logical power" of Excel, it cannot be replaced by power query.

[mr.goldenball]

Python is another good option for automation.

[saicharankanchu]

But why still now most of the companies are asking VBA skills

[just.fisayo]

VBA is also used for automations lmao.
Can Power query run macros?

[rajm]

Bro I have knowledge on sas, pwerbi, sql, python but no job since a decade kindly sggst me hw to get wrk in online as a freelancer, I attnd intrvws bt rejctd in fnl rounds

[prosenjitshaw]

Can anyone just me a different or best youtube / udemy for learning Sql, power Bi, tableau and python and also suggest as each tools are regularly updated than if i learn from 2/ 3 yrs old video will it be beneficial for me ..

[FouziaHashmi-tqdw]

Bhai agar ap yeh video na banate to main 20 ghante ka VBA course kar leta

[ansarifaizan]

Clearly you have a very limited idea about VBA

[RaphaelChikuka]

He doesn't know what he is talking about.😂