Видео

Hey Kyle! Could you also make tutorial on using AI with Excel??

This is amazing. I have bought your courses on Udemy and love them. Kyle could you please make a video on how we can create Gantt Chart using Power Bi and show dependencies? I tried searching and following a lot of videos, But the way and clarity you explain it with makes it highly enjoyable and easy process. I am sure that would be an absolute HIIT.. Thank you! Bless you.

The moment I noticed you on RUclips, it was like this is the man I truly want to leverage RUclips for sharing best in class tutorials.

It works... but not sure I'd call it pretty 😅😅. But nice exercise!

Great video and a very nice explanation , thank you Kyle

The best excel lecturer of all times!

Sub ShowHideSubShapes() ' ' ShowHideSubShapes Macro ' ' if the shapes are visible then hide the shapes If ActiveSheet.Shapes.Range(Array("SubShape01")).Visible = msoTrue Then ActiveSheet.Shapes.Range(Array("SubShape01")).Visible = msoFalse ActiveSheet.Shapes.Range(Array("SubShape02")).Visible = msoFalse ActiveSheet.Shapes.Range(Array("SubShape03")).Visible = msoFalse ActiveSheet.Shapes.Range(Array("SubShape04")).Visible = msoFalse ' change - sign to a + sign ActiveSheet.Shapes.Range(Array("ShowHide")).AutoShapeType = msoShapeMathPlus Else ' if the shapes are not visible then show the shapes ActiveSheet.Shapes.Range(Array("SubShape01")).Visible = msoTrue ActiveSheet.Shapes.Range(Array("SubShape02")).Visible = msoTrue ActiveSheet.Shapes.Range(Array("SubShape03")).Visible = msoTrue ActiveSheet.Shapes.Range(Array("SubShape04")).Visible = msoTrue ' change + sign to a - sign ActiveSheet.Shapes.Range(Array("ShowHide")).AutoShapeType = msoShapeMathMinus End If End Sub

No. 3 and 4 are the life saver. I know the others.

Thanks 🎉🎉

Thank you. I am registered in your class on Udemy. I can honestly say that this has approved my performance. Thank you for clear instructions.

YOU ARE A FANTASTIC TUTOR🙏

I am vaibhav kamble I came here from Udemy Description. Watched all videos in one go... Excellent explaination... going to buy your Udemy Course for sure. See you soon.

Hello sir, I took your Excel course on Udemy and I recommend this to everyone who asks me how to get started learning Excel. Your way of teaching is great. Loved the video though

amazing

Can't download the spreadsheet unless you have premium :(

Thanks for this! Can i use sum and count functions at the same time? E.g the total of 'Adventure' is 450, can I count how many 'Adventure' in the next column?

Does this work in the office 365 version? I do not get the ability to select the date from the calendar when i click in the cell of A2 where i have my date column. My table is labeled RawData and i have changed that in the macro. I'm new to this so i have probably messed something up.

please upload exercise file as well

you saved me! Thank you!!

This is an excellent video. Unfortunately, my copilot does not retain your formatting, i.e., bullets and sub-bullet as you have generated here. It does create a presentation but it doesn't look anywhere close to what you have. Is there a reason for that? I downloaded the same file that you have and followed the instructions.

Excellent Video Kyle - Im retired now but if I had this when I was working I could have relaxed a lot more!

Great video! Thank you!

How to overwrite the current date?

Great!

Nice Info... All shortcuts.

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.