10X Your Excel with Macros & Basic VBA

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 ก.พ. 2025

ความคิดเห็น • 59

  • @KenjiExplains
    @KenjiExplains  ปีที่แล้ว +4

    👉 Take our Excel course here: www.careerprinciples.com/courses/excel-for-business-finance

    • @frontiermedia8772
      @frontiermedia8772 ปีที่แล้ว

      Sir kindly reach us real life project for VBA

  • @adarshfr
    @adarshfr ปีที่แล้ว +4

    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

    • @KenjiExplains
      @KenjiExplains  ปีที่แล้ว +1

      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 😁

  • @andysartz
    @andysartz 7 หลายเดือนก่อน

    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! =)

  • @data_with_dylan
    @data_with_dylan ปีที่แล้ว +3

    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

  • @akshayarachwal7529
    @akshayarachwal7529 ปีที่แล้ว +1

    You are my inspiration
    Your content is easy to catch and work

  • @KevLaj
    @KevLaj ปีที่แล้ว +3

    As a 25 year Excel user I'm still learning tricks with these videos 👍🏿.

  • @JosephDAquila-s6q
    @JosephDAquila-s6q ปีที่แล้ว +1

    You can also set certain keys to run macros for you

  • @Chiesther
    @Chiesther ปีที่แล้ว +2

    Can macros automatically copy a range of cells and duplicate same for a number of times?

  • @harishkumarsahoo2255
    @harishkumarsahoo2255 ปีที่แล้ว +1

    Hey kenji can you please tell me about your education qualification

  • @ACanvasofLoveandLight
    @ACanvasofLoveandLight ปีที่แล้ว

    Very informative and useful... thanks handsom!

  • @alirezakarkouti8179
    @alirezakarkouti8179 ปีที่แล้ว

    Thank you, this was really useful.

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 ปีที่แล้ว

    Thank you Coach Kenji

  • @sahajchhatwal4071
    @sahajchhatwal4071 ปีที่แล้ว

    hello, i want shift row data form sheet 1 to sheet 2 , when quantity of product is added

  • @vikramadityarathore97
    @vikramadityarathore97 ปีที่แล้ว +1

    Great job kenji, really appreciate you making videos on power bi apart from insightful excel functions and features.

    • @KenjiExplains
      @KenjiExplains  ปีที่แล้ว

      Thank you for watching them :)

  • @ArchJoe1
    @ArchJoe1 ปีที่แล้ว +1

    Thank you! Are VBAs and Macros covered in the Excel course at Career Principles?

  • @willzinner8813
    @willzinner8813 ปีที่แล้ว +1

    thank you

  • @tofynoor861
    @tofynoor861 ปีที่แล้ว +1

    Any discount code for the course ?

    • @KenjiExplains
      @KenjiExplains  ปีที่แล้ว +1

      Hey you can use code EMAIL10 at checkout :)

  • @aleksmaric5159
    @aleksmaric5159 7 หลายเดือนก่อน

    Hi Kenji where to download link from today's presentation?

  • @brian5220
    @brian5220 ปีที่แล้ว +1

    Your video’s are helping me a lot. 👊🏽

  • @khoadang1703
    @khoadang1703 8 หลายเดือนก่อน

    Very informative

  • @VBASqlAccessPowerApps
    @VBASqlAccessPowerApps ปีที่แล้ว +1

    Nice video, however you should do proper Indentation in your code

  • @muddasar3060
    @muddasar3060 9 หลายเดือนก่อน

    Very good

  • @nsdesain6794
    @nsdesain6794 ปีที่แล้ว

    What version of Microsoft Excel do you use?

  • @akshayarachwal7529
    @akshayarachwal7529 ปีที่แล้ว

    Kenji my view cords tab not show comments and any programing help me

  • @michaelquach6655
    @michaelquach6655 ปีที่แล้ว +1

    Nice video! Great way to simplify using the macro recorder and VB editor together!

  • @yohaibinyamin5233
    @yohaibinyamin5233 ปีที่แล้ว

    when i insert the developer. my excel start to work very slow. I have MO 2019

  • @YogeswarKasi
    @YogeswarKasi ปีที่แล้ว

    Instead of using VBA, Can't I just duplicate sheets and do minor edits ? isnt is a bit less complex?

  • @jennifer2185
    @jennifer2185 ปีที่แล้ว +8

    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...

    • @Clean09
      @Clean09 ปีที่แล้ว

      I wonder why would they disable it...🤔

    • @rockhitbant5
      @rockhitbant5 ปีที่แล้ว

      @@Clean09 to make employees suffer

    • @kinbii1261
      @kinbii1261 ปีที่แล้ว +2

      Security concerns

  • @camlex6310
    @camlex6310 ปีที่แล้ว

    Great tutorial!

  • @chrisMuc1966
    @chrisMuc1966 ปีที่แล้ว

    Very useful!

  • @sallyho146
    @sallyho146 ปีที่แล้ว

    What is vba?

    • @brian5220
      @brian5220 ปีที่แล้ว +1

      Visual Basic for Application. The programing language for excel

  • @willzinner8813
    @willzinner8813 ปีที่แล้ว +1

    can you do more on vba sir?

  • @sallyho146
    @sallyho146 ปีที่แล้ว

    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?

    • @adarshfr
      @adarshfr ปีที่แล้ว +1

      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

    • @sallyho146
      @sallyho146 ปีที่แล้ว

      @@adarshfr Thankd. So basically it is for speed.

  • @nishanth4323
    @nishanth4323 ปีที่แล้ว

    🙏

  • @tvfamily160
    @tvfamily160 ปีที่แล้ว

    👍🏼

  • @sumitkanpur2901
    @sumitkanpur2901 6 หลายเดือนก่อน

    Contact no. Sir