15 49.0138 8.38624 1 0 4000 1 https://yswiki.org 300 true 0
theme-sticky-logo-alt

Learn Macros in 7 Minutes (Microsoft Excel)

47 Comments


Here is the sample file: Interested in learning more? You can use the following link to enroll in my course, “Become a Microsoft Excel Wizard in 1 Hour”:

Macros allow you to automate repetitive tasks in Microsoft Excel.

Nguồn: https://yswiki.org

Xem thêm bài viết khác: dhttps://yswiki.org/cong-nghe/

Previous
Next

47 Comments

  • May 23, 2020 at 9:17 pm
    Cody Baldwin

    What's up, Excel ninjas? I hope this video is helpful. I love me some macros! If you're interested in learning more about Microsoft Excel, you can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": http://rebrand.ly/excelcourse

    Reply
  • May 23, 2020 at 9:17 pm
    Matthew Clixby

    Thanks that’s a great introduction! Macros are defiant going to make many of my work tasks much easier. Thanks for sharing 😃

    Reply
  • May 23, 2020 at 9:17 pm
    Gin Tomino

    that is probably the easiest to learn the macro. Thanks a lot! *subscribed

    Reply
  • May 23, 2020 at 9:17 pm
    Radha Shakthivel

    Explained very easily

    Reply
  • May 23, 2020 at 9:17 pm
    Ondřej Suchý

    Hi, how do I create a "Button" for using my macro? Thanks in advance'

    Reply
  • May 23, 2020 at 9:17 pm
    Robert ONeill

    THANK YOU! I made a few for my job (happens to be bank) and my office now thinks im a wiz of a manager! THANK YOU!!

    Reply
  • May 23, 2020 at 9:17 pm
    Sanjiv Patel

    I thought macros were more difficult. How do you delete a row where a field in the report is blank?

    Reply
  • May 23, 2020 at 9:17 pm
    Jzone

    What if my row counts is dynamic? Not always the same like the recorded macro. It can be more and can be less.

    Reply
  • May 23, 2020 at 9:17 pm
    Low Effort

    roblox simulators dont stand a chance

    Reply
  • May 23, 2020 at 9:17 pm
    J De Leon

    So helpful. Thank you!

    Reply
  • May 23, 2020 at 9:17 pm
    daniel patrick

    good job cody

    Reply
  • May 23, 2020 at 9:17 pm
    Mukhammadali Otaboev

    Awesome!

    Reply
  • May 23, 2020 at 9:17 pm
    lifeisfun71

    OMG. I only wish this video existed 5 years ago and that I watched it then. #lifechanged

    Reply
  • May 23, 2020 at 9:17 pm
    NbaLive4ever

    I just learned about making macros and I have to format a worksheet for my coworker daily so I tried to create my own and oh my…went from like 10 min to one second in one click! (Sounds like a click bait title lol) but macros are so awesome!!

    Reply
  • May 23, 2020 at 9:17 pm
    Afrizal Firdaus

    Thank you.

    Reply
  • May 23, 2020 at 9:17 pm
    sameer naseri YFF

    Thanks bro

    Reply
  • May 23, 2020 at 9:17 pm
    Rhys Bird

    Brilliant video, explained perfectly, thank you!

    Reply
  • May 23, 2020 at 9:17 pm
    Jide O.

    Hi Cody! Thank you sooooo much for this, you have saved my sanity in 7minutes wow. I am so confused how to show how much I appreciate you and this video! Thanks a lot.

    Reply
  • May 23, 2020 at 9:17 pm
    Jesse Tagore

    Great info Cody. Thanks alot!!!. Can you upload videos on VBA for excel.

    Reply
  • May 23, 2020 at 9:17 pm
    Ruchi Batra

    Can you tell me some short cuts on ms excel? just mail me on my mail id. or provide me the link. It would be great learning by you.

    Reply
  • May 23, 2020 at 9:17 pm
    YOO HOO

    So it seems macro can only work on Exactly Same forms only, correct?

    Reply
  • May 23, 2020 at 9:17 pm
    APIndia

    Very cool, I am not a fan of excel macros but this video is very cool

    Reply
  • May 23, 2020 at 9:17 pm
    Hitesh Shetty

    Hi @Cody Baldwin I followed your video till the end. However, Iam unable to run the macros for 2nd and 3rd week. The debugger is showing the error as .Color = -16383844 highlighted in yellow in the VB page. Do I need to make any changes in the code to make the macro run for 2nd and 3rd week. Even the conditional formatting for 'Charged Off' is not reflecting for those weeks.

    Reply
  • May 23, 2020 at 9:17 pm
    Scott Garcia

    Great video.

    Reply
  • May 23, 2020 at 9:17 pm
    Raymond Nevin Binoya

    Thanks!

    Reply
  • May 23, 2020 at 9:17 pm
    Ahsan Ali

    If v have more sheets in workbook, should the raw data be same in each sheet (headerwise) ? What if one or more columns r missing or extra

    Reply
  • May 23, 2020 at 9:17 pm
    srinivas narisetty

    Thank you very much for explaining Macros.

    Reply
  • May 23, 2020 at 9:17 pm
    łī Łī

    Awesome

    Reply
  • May 23, 2020 at 9:17 pm
    lee hoong

    please make more relevant videos about excel. it's indeed much helpful

    Reply
  • May 23, 2020 at 9:17 pm
    BVM BVM

    Thank you

    Reply
  • May 23, 2020 at 9:17 pm
    Sarah Oakes

    Got stuck on macros with an online course and this video was super helpful

    Reply
  • May 23, 2020 at 9:17 pm
    Narasimha

    Wow. Well explained. Thanks.

    Reply
  • May 23, 2020 at 9:17 pm
    Peter Rios

    Thank you! Thank you! THANK YOU!!!

    Reply
  • May 23, 2020 at 9:17 pm
    Clancy Waldron

    This was spot on. loved it. I have been trying to delve into the world of manual macro coding. Does your course cover the topic?

    Reply
  • May 23, 2020 at 9:17 pm
    Filipe Bergami Alves

    Thanks for producing high value content in short video format. Way easier to learn exactly what one was looking for and no time is wasted.

    Reply
  • May 23, 2020 at 9:17 pm
    john joseph ricaña

    Thanks Cody. Great video tutorial 👍

    Reply
  • May 23, 2020 at 9:17 pm
    Бойко Димов

    OMGF BRO!!! Thank you sincerely!

    Reply
  • May 23, 2020 at 9:17 pm
    Francisco Pereiro

    Thanks for the explanation, very informative. But I noticed that the macro didn't sort the new column from higher to lower… Regards, and thanks for the lesson

    Reply
  • May 23, 2020 at 9:17 pm
    John

    Awesome Video! Very Informative and Helpful.

    Something I am running into though is being able to pull up that same macro for future use in other workbooks. What am I doing wrong?

    Reply
  • May 23, 2020 at 9:17 pm
    Kintario

    It is an incredible tool. However, it has its limitations and if the task is not so simple there is a need of VBA scripting in order to make a macro work the way you truly want it.

    Reply
  • May 23, 2020 at 9:17 pm
    MrMeghdadi

    informative, concise and right to the point. thanks for teaching me

    Reply
  • May 23, 2020 at 9:17 pm
    Zaleha Ali

    Hi Cody – You have taught me from Zero to an "'Expert'' in 7mins. I bought your course. Thank you for sharing!

    Reply
  • May 23, 2020 at 9:17 pm
    1dylanflowang

    your second sheet, it doesn’t seem to arrange the deb_ to_income column automatically…

    Reply
  • May 23, 2020 at 9:17 pm
    shubham pawar

    u r the BEST

    Reply
  • May 23, 2020 at 9:17 pm
    yettytube

    wow learnt so much in such a short time. thank you

    Reply
  • May 23, 2020 at 9:17 pm
    Edison International School

    That was very cool. I wasnt even interested in Macros !!

    Reply
  • May 23, 2020 at 9:17 pm
    Enriquez Melissa

    I spend at least 30 minutes each morning in reports… I can’t thank you enough for this video gentleman

    Reply

Leave a Reply