Why I received error although I used the exact formula?

Great stuff Kyle - very useful! If I can remember them!

Excellent work Kyle! Great and helpful list. I especially needed #2 for selecting visible cells. Thanks!

Thanks!

As always... thank YOU Professor!! 💛

Love it!!! thanks for sharing.

1. Ctrl + shift + L To apply Filter 2. Alt + ; to copy visible records 3. Ctrl + shift + [ To Trace precident 4. Alt H V T to transpose data

this is fantastic and super robust. the debts seem to assume that they are not growing such as a credit card still in use for monthly auto charges -- so is there a way to add to the debt and still figure out the totals or is the spreadsheet assuming the debts, such as a credit card, is out of use. or can one over ride the new total without messing up the rest of the column?

Very nice, complete information. Loved it!

I would take the penny.

HOw do I download the Excel File? ==> Great DEmo!

What happens id you have or need more than 10 inputs.

Mannnn you the best. Thank you.

If I want to pay more sporatically through out the yr, would I just add it to the individual month that I paid more at the bottom of the spread sheet ( month 3, month 6, month 10)etc?

What a great video !! I have bought your excel beginners course on Udemy and enjoying every minute of it

Hi Help me the below, How to use multiple condition Group by

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.