I'm trying to remember how to use Excel VBA after 7 years of not really needing to use it and your videos have been super helpful. Thank you for sharing! =)
For anyone wondering whether the courses are worh it, heres an unbiased review from someone trying to get into investment banking (finance major in the UK) I purchased the all access subscription (best value + for my career, all the courses teach skills required) - Just like his youtube videos, he gets straight to the point in the course. The pace makes sure theres no time wastage, yet taking it step by step, so you don't get confused - After talking to alumni and people in the field, they're impressed with the skills that I have, and I owe that to these courses One thing that you need to keep in mind though. No matter what course, free or paid that you're trying to start, you'll never reap all the benefits unless you make a concious effort to learn & study consistently. Thanks Kenji for the amount of value you provide to your viewers, and I'm sure that was a big reason for the growth you've been having You can pin this if you'd like Kenji, so if anyone has questions abt it, i'm more than happy to answer them
Hi Adarsh, thank you for the awesome comment! Definitely wasn't expecting it :) And I agree, you won't reap all the benefits unless you put in the work yourself. Again, I appreciate your support 😁
I wish my current company didn't have Macros disabled.... I can think of at least 3 tasks this would be perfect for right off the top of my head.... sigh...
Kanji - instead of using micro to create 5 product tabs, can we copy product 1 tab into 4 more? What are the benefits of using macro where it involves programming language?
The main benefit is automation. If you make a list of macros for while, eventually you will have a list of them And that list will come of great help when you're under pressure and having to do multiple tasks with deadlines You'll have a whole set of macros that will speed up simple processes that eat up your time
👉 Take our Excel course here: www.careerprinciples.com/courses/excel-for-business-finance
Sir kindly reach us real life project for VBA
I'm trying to remember how to use Excel VBA after 7 years of not really needing to use it and your videos have been super helpful. Thank you for sharing! =)
For anyone wondering whether the courses are worh it, heres an unbiased review from someone trying to get into investment banking (finance major in the UK)
I purchased the all access subscription (best value + for my career, all the courses teach skills required)
- Just like his youtube videos, he gets straight to the point in the course. The pace makes sure theres no time wastage, yet taking it step by step, so you don't get confused
- After talking to alumni and people in the field, they're impressed with the skills that I have, and I owe that to these courses
One thing that you need to keep in mind though. No matter what course, free or paid that you're trying to start, you'll never reap all the benefits unless you make a concious effort to learn & study consistently.
Thanks Kenji for the amount of value you provide to your viewers, and I'm sure that was a big reason for the growth you've been having
You can pin this if you'd like Kenji, so if anyone has questions abt it, i'm more than happy to answer them
Hi Adarsh, thank you for the awesome comment! Definitely wasn't expecting it :)
And I agree, you won't reap all the benefits unless you put in the work yourself.
Again, I appreciate your support 😁
Thank you, this was really helpful! I love how macros can automatically do the task that you want it to do everytime you run it
good I also love them
As a 25 year Excel user I'm still learning tricks with these videos 👍🏿.
You are my inspiration
Your content is easy to catch and work
same here!
You can also set certain keys to run macros for you
Can macros automatically copy a range of cells and duplicate same for a number of times?
Very informative and useful... thanks handsom!
I wish my current company didn't have Macros disabled.... I can think of at least 3 tasks this would be perfect for right off the top of my head.... sigh...
I wonder why would they disable it...🤔
@@Clean09 to make employees suffer
Security concerns
Great job kenji, really appreciate you making videos on power bi apart from insightful excel functions and features.
Thank you for watching them :)
Hey kenji can you please tell me about your education qualification
Thank you, this was really useful.
Thank you Coach Kenji
Thank you! Are VBAs and Macros covered in the Excel course at Career Principles?
I don't think so
Hi Kenji where to download link from today's presentation?
Nice video, however you should do proper Indentation in your code
Your video’s are helping me a lot. 👊🏽
Very informative
hello, i want shift row data form sheet 1 to sheet 2 , when quantity of product is added
thank you
You're welcome!
Instead of using VBA, Can't I just duplicate sheets and do minor edits ? isnt is a bit less complex?
Nice video! Great way to simplify using the macro recorder and VB editor together!
Glad you like it!
when i insert the developer. my excel start to work very slow. I have MO 2019
Any discount code for the course ?
Hey you can use code EMAIL10 at checkout :)
Kenji my view cords tab not show comments and any programing help me
Very good
What version of Microsoft Excel do you use?
Kanji - instead of using micro to create 5 product tabs, can we copy product 1 tab into 4 more? What are the benefits of using macro where it involves programming language?
The main benefit is automation. If you make a list of macros for while, eventually you will have a list of them
And that list will come of great help when you're under pressure and having to do multiple tasks with deadlines
You'll have a whole set of macros that will speed up simple processes that eat up your time
@@adarshfr Thankd. So basically it is for speed.
Great tutorial!
Thank you! Cheers!
Very useful!
Glad you think so!
can you do more on vba sir?
Noted!
Lopez Larry Lopez Timothy Clark Christopher
What is vba?
Visual Basic for Application. The programing language for excel
🙏
Cheers!
@@KenjiExplains 🍻
👍🏼
😀
Contact no. Sir