10X Your Excel with Macros & Basic VBA
Вставка
- Опубліковано 2 сер 2024
- Learn Excel Macros and Basic VBA to automate your repetitive tasks.
👉 Take our Excel course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/642553...
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this video you'll learn how to use excel macros from scratch using three real world examples. First, we'll go over a simple formatting example so you can automate formatting cells. Second, we'll go over removing comments and making the selection dynamic. We'll also cover macro buttons so you can activate these more easily. This will also include the types of macros from personal workbook, to file specific. Finally, we'll go over an advanced macro example with a bit of VBA so we can customize it further. This will be to create multiple new excel sheets with different names.
SOCIALS:
🎬 My Company UA-cam Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Macros (Beginner)
2:42 - Macros (Intermediate)
6:27 - Macros & VBA (Difficult)
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
👉 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! =)
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
Very informative and useful... thanks handsom!
Thank you, this was really useful.
Thank you Coach Kenji
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
Very informative
Great job kenji, really appreciate you making videos on power bi apart from insightful excel functions and features.
Thank you for watching them :)
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 😁
Very good
Hey kenji can you please tell me about your education qualification
Your video’s are helping me a lot. 👊🏽
As a 25 year Excel user I'm still learning tricks with these videos 👍🏿.
Nice video! Great way to simplify using the macro recorder and VB editor together!
Glad you like it!
thank you
You're welcome!
Can macros automatically copy a range of cells and duplicate same for a number of times?
Thank you! Are VBAs and Macros covered in the Excel course at Career Principles?
I don't think so
What version of Microsoft Excel do you use?
hello, i want shift row data form sheet 1 to sheet 2 , when quantity of product is added
Nice video, however you should do proper Indentation in your code
Hi Kenji where to download link from today's presentation?
Great tutorial!
Thank you! Cheers!
Very useful!
Glad you think so!
Kenji my view cords tab not show comments and any programing help me
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
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 :)
Instead of using VBA, Can't I just duplicate sheets and do minor edits ? isnt is a bit less complex?
👍🏼
😀
can you do more on vba sir?
Noted!
🙏
Cheers!
@@KenjiExplains 🍻
What is vba?
Visual Basic for Application. The programing language for excel
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.