What about multi line codes like for loops?

Looking at the views & likes I wonder how many new kids learned Excel and never watched this video. You make it so easy to understand.

Great way to create interactive dashboards. Sad to see such low visibility on the post.

Thanks a lot, that was very helpful

Hello there! I spent the better part of yesterday (11/9/2024) working on my own Snowball spreadsheet. My interest calculation was off. One I fixed it, I was really close to your numbers. Where we differ is the month where the additional money rolls into the next card. Let's say for example, the first and second card's payment is $40 and $60 respectively. The additional amount is $40. So first card is paid at $80 monthly. In the 15th month, the final payment is $14.25. In that same week, you rolled the full $80 into the second card. << I don't think it would happen this way. I think on week 15, Card 1 would be paid at $14.25 and the card owner would spend the remaining $65.75 on himself. Card 2 still gets $60 for week 15. Week 16 is paid at $140. Per my calculation, this added one month to the pay off of Card 2. < I used my rollover pattern into Card 3, and again, my payoff date was one month after yours. So, you and I are off by one month per card after the first card. I'm not sure if that one month per card makes a difference to anyone, but it does for me because it impacts when I can go on vacation and how much I have to spend during the holiday season. Please let me know if my thinking or my math is off. Otherwise, THANK YOU for confirming that I was on the right track with my own spreadsheet! Now I'm going to see if I can convert it to MS ACCESS :D

To all the users to find the "trick" for VBE windows to original setting - This is the video you should watch. First of all - make sure you get the "Dockable" boxes (at "Options->Docking") for #1 to #5 (except Object bowser) all checked on. Second - This video shows us when he holds and dragging the Window (at the title bar) to the left side of the screen - at first it looks like almost disappearing into half where the window will start showing like "double images" or resizing like he mentioned in this video, there we go, we can put it back and dock it back at the desired location. Trust me! This works wonderfully! As I have browsed many videos, this one specifically mentioned "drag the window to the left screen ........" just follow what he says in this video. You will get it.

Thanks this is great! because I have been looking ways to dock my VBE to original setting => #1) Project VBA window (top left), #2) Properties window (bottom left), #3) Code window (top right), #4) Immediate window and #5) Watch window (both at the bottom, at choice be it at the bottom right or bottom left) and while with the "Dockable" boxes (at "Options->Docking") for #1 to #5 (except Object bowser) all checked. My VBE windows all back to the Original Setting now!! Hooray! finally! Thanks a lot!!!

is downloading the file free? It doesn't look like it when reading the terms. Any idea?

Respected Sir, I have Excel 2021 version. My Excel is not showing TOCOL and TOROW functions. As I am trying to write down the TOCOL function its showing NAME error in the cell. How can i enable the TOCOL and TOROW in my 2021 EXCEL? Please Help.

Thank you so much for sharing this spreadsheet! I have completely filled it in and I'm feeling super motivated about tracking my progress to debt-free! Yay!

In my opinion, this is incorrect since the question was would you rather have $1 million or a penny that doubles itself every day for 30 days. The first day it’s still a penny so technically you would have to take the formula down to Cell or line 31 therefore the correct answer would be an excess of $10 million. You’re welcome.

Thanks. Quick, clear, and concise intro to Flash Fill. Wouldn't mind seeing Ctrl+E used in the video itself though, instead of the description.

***SOLVED*** Error 9 in line 4: the code gives an error in line 4: If Not Intersect(Target, Me.ListObjects("ProjectTable").ListColumns(3).DataBodyRange.Resize(, 2)) Is Nothing Then I have renamed my calendar object to "Calendar" as the video instructed, and pasted everything in as directed, but no luck. SOLVED IT: Ok answered my own question. This code has 2 references that each user will have to specify that aren't mentioned in the video. First, the OBJECT is a table that must be inserted ( click the "Insert" tab, then choose "Table") and then named ( rename your tables by clicking the Table Design tab, then on the left side set Table Name (ex: "Table15"). Second, the columns with dates need to be referenced. In this script, it is done by targeting the first column with a date and assuming the one immediately to the right of it is also a date (Resize(,2)). So, if I had named my table "Table15" and wanted the 2nd and 3rd columns of the table to have the date selector, then this line should read: If Not Intersect(Target, Me.ListObjects("Table15").ListColumns(2).DataBodyRange.Resize(, 2)) Is Nothing Then

Thank you for this video. The video is super easy to follow and, overall, to learn. This video helps me a lot! Thank you again. 10/13/2024

Thanks! You helped me with my student project :D

Sir, I want to work from home by freelancing on ms excel. Please guide me if I buy your course on udemy named as Microsoft Excel - Excel from Beginner to Advanced will it be helpful for me to get 50-100 dollars per hour? I need to earn and support my family. Please guide 🙏🏻

I studied your course sir in Udemy. You are SIMPLY THE BEST. I followed your courses into youtube. I honestly don't understand any other tutor

For you guys that have some problem with showing the map of one region only, you can try to turn off the Grand Totals in the map's pivot table. It works for me, I hope works for you too!

Thank you so much for providing this. Super helpful and efficient. Great tool and explanation! :)

Love this idea....

Hi Klye, to you do any private instructions for a specific project? I've watched your VLoop but I need for some specific work tasks. Thank you!

hello, which software did you use for this screen capture?

Thanks!

You’re the best instructor I have ever had. Your teaching style is top notch in my opinion. I wish you could teach in every subject matter . Just wanted to give you your props. Keep doing what your doing, your truly appreciated. ✌🏾

Genius!!! Thanks

I need vba code

Hello Kyle Pew, I am Promise, that your course on Udemy:(Microsoft Certified Trainer - 1 Million+ Students) was not that clear to me could you please kindly provide me more concept explanation based on the course, What time suits you the best? I will be happy to hear from you

Finally I found someone that explains this issue. Great job.

brilliant

Don't forget to download the Example File found in the video description so you can follow a long.

Sir, this is excellent. Thank you for making this tutorial.

One of the best excel tutorials I have watched. Super clear. Thank You!

Would combining this method with making weekly payments make much of a difference in the time it will take to pay off all the debt? Do you have a downloadable spreadsheet for that? I'm curious to explore every option but don't have a clue as to how to create my own spreadsheet formulas. Thank you so much.

This is great! I thank you for making it so clear and structured! Wonderful job, Kyle. Please let us know if you will be doing a course.

Great video. I'm really hoping you launch a full power BI course soon, Kyle!

you are informative 😂

This is very useful, but I have one question about the spreadsheet. When I input the data the payoff date comes up odd. it will show 12/31/1908 or 8/31/1900 why is that? How can I have it show current payoff dates?

I am having the same problem in excel 2019. Whatever capacity or material I choose comes back with 0. I have even copied and pasted the formula just to be sure. Would love to know what I am doing incorrectly. Thank you.

Awesome explanation

I think I found one mistake in your worksheet, I might be wrong but can you please check. I am refering same example in this video @10:26 if you see last payment of credit card 1 is 63.24 but payment 37 for credit card 2 should be 125+200-63.24. Can you please let me know if payment 37 for credit card 2 should be 325 or 325-63.24 as we are still paying out the credit card 1.

You are the one who made me know Microsoft Excel, I bought your course on Udemy and since then I have been teaching Excel as well. You make Excel look so simple, especially the complex topics! Thanks so much my Tutor!

This is awesome! Thanks for sharing the excel document. You may have it in your course, but do you happen to have a budget excel document that operates I similar manner with inputs?

Is this dynamic?

Thank you! This is exactly what I needed! Quick question, why does it list the earlier dated items at the bottom and then up to the later dated items? Just curious, it will bother me LOL

can you make a one time payment without going over to the next loan? I want to make a big payment one time only and I don't to add to the next loan, please help

Is this available office 2021 or MS 365 ? Can we apply also to numeric field ?

How does it handle "McIntyre" or "O'Brien", or "MacCleod, Connor"? How about hyphenated names?

@OfficeNewb Are you available for a quick discussion concerning your Udemy course promotion Looking forward on working together Thanks

Thank you ❤ you made my day and Subscribed as a grattitude🤝

Been looking around for this and you're by far the ONLY non boring one. I wonder if you're a teacher. :)