I have finished your Basics and Advanced Playlist today. Can't believe that I can get all of these for free. Thank you so much for such an amazing learning journey!!!!
@excelisfun
Ай бұрын
You are welcome!!! You are on your way to Excel Awesoemness!!!!
@new2dascene
7 жыл бұрын
This guy is amazing, ive watched so many of his videos and now at work im consistently able to showcase my excel knowledge and currently am working on a big promotion based on my experience using excel. Couldnt be here without these videos. Thank you so much
@excelisfun
7 жыл бұрын
You are welcome so much! Thanks for the Thumbs Up on each video and sub! : )
@davida.taylor8444
7 жыл бұрын
I was in the same boat...and got the promotion due to some of these videos, especially his stuff on PowerPivot.
@jackieo7113
Жыл бұрын
I know, right! He's my secret weapon!!!
@777kiya
2 жыл бұрын
The Best Excel Teacher as far as I know Two years ago, I found out about Macro and I was thrilled to know and use it. I used it to create tools for easing my work, which me and my collegues saw as miraclous. But now I see this video, I learned a lot more. It answered some questions I had and as usual you've done an amazing job. Seeing you have thousands of videos on youtube, you should be celebrated. Thank you
@abdulsamadibrahim4929
Жыл бұрын
I just finished all the videos for Advanced excel. I would like to say big thank you to Mr Mike!
@excelisfun
Жыл бұрын
You are welcome, Abdulsamad!!! I am glad you made it to the end so you can have fun and power with Excel : )
@armondnazarian4455
5 жыл бұрын
Done with the advanced Excel now! wow it's unbelievable how great and efficient you teach the Excel. Thanks for your hard work Mike.
@excelisfun
5 жыл бұрын
You are welcome, Armond!!! Thanks for your support : )
@esanbifi6377
8 жыл бұрын
I am 50 years old, in my life I’ve seen many teachers, honestly you are the BEST teacher.
@excelisfun
7 жыл бұрын
I am glad the the videos hep! : )
@Cracktune
2 жыл бұрын
dawg! you kill it! i bought your book Slaying Excel Dragons and boi; i got my sword ready. Thank you, man.
@excelisfun
2 жыл бұрын
Yes!!! I am glad that you got your sword ready : ) You are going to do amazing things with Excel!!!
@sim7717
8 жыл бұрын
Dear Sir, I've made a calculation using a macro which might pep up your venture a little bit. Watching your videos created on using relative references is always fun. Anyways, what I'm gonna say is that if you think of spreading your calculation to a table no matter how long and wide it is then I have already found one to share with you. I noticed that you have worked on the length side. Now, please record one macro applied for unlimited length and width. Here are the steps I tried to impress you: 1. I selected the first cell then Ctrl+Right arrow to get to the right end of the table and then switching on relative reference button I moved to the next cell to write the heading then moved to the second row straight under the heading. Then switched the relative button off. 2. Here I used a sum calculation. Then copied it and after that, I pressed Ctrl+Home button to get to the first cell. 3. Then pressing Ctrl+Down arrow I got to the bottom of the table then ctrl+Right arrow to get to the right-most corner. 4. Then switched the relative reference button on and moved to the next cell up to which the calculation should be made. Then switched the relative button off. 5.Then pressing Ctrl+Shift+up arrow I reached the cell from where the formula I copied. Then pressing ctrl+V I pasted the formula throughout the cell I selected. Then pressed ctrl+Home tab to reached the first cell and ctrl+* to select the whole table to apply borders around it. And then I stopped recording. I noticed that this macro is sufficient to spread calculation whatever the table length or width is. Inspired by your three macro related videos I tried to make this. Hope you don't take it otherwise. You are the best teacher I've ever had in my whole life. Good day and T.C. Md. Shahin Iqbal
@excelisfun
8 жыл бұрын
That is awesome! I am happy that the video helped you to learn and then innovate with the Macro Recorder!!! You are an awesome Exceller!!! : )
@sim7717
8 жыл бұрын
Thanks, Sir. I am very happy as well that you liked it.
@JTheill
6 жыл бұрын
Brilliant stuff, this dude's talent for teaching excel is just something else.
@fjanjuah
8 жыл бұрын
Dear Mike you made Excel so easy that it's understandable...You are one of the best tutors..Many many thanks...
@excelisfun
7 жыл бұрын
Many: You are welcomes!
@hrprk5507
4 жыл бұрын
Just finished the "beginners" playlist, (comprehensive for beginners but does not lack the quality and depth of an advanced course), and here to learn more. :)
@excelisfun
4 жыл бұрын
My beginners classes are quite advanced. But after teh Basics, you can move on to this advanced class.
@jkhoo2137
7 жыл бұрын
Hi Mike, Just want to give you a big shout out for all your great excel tutorials. I am a fresh graduate who knew nuts about Excel and have been trying to learn from your vids to apply these concepts at work. They really helped me so much! Thank you!
@Chamchijjige
3 жыл бұрын
Ready to be data analyst now. Thank you very much.
@haythamamairah
8 жыл бұрын
Thank you, Mike, this is a really amazing video! But you can shorten the click of the Ctrl+Shift+Z keyboard shortcut from 14 times to just one click! Try to update the code using the Do While Statement as follows: Do While ActiveCell "" Range(Selection, Selection.End(xlDown)).Select Selection.Copy ActiveCell.Offset(-1, 0).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True ActiveCell.Offset(1, 0).Rows("1:9").EntireRow.Select Application.CutCopyMode = False Selection.Delete Shift:=xlUp ActiveCell.Offset(1, 0).Range("A1").Select Loop
@sasavienne
4 жыл бұрын
No Excel without Mike. 👍 🌟 🌟 Thanks . 👍
@excelisfun
4 жыл бұрын
: )
@Javicrack16
7 жыл бұрын
Using the relative reference when recording macros is absolutely powerful !!! Thank you so much for this useful advice. Big fan of your videos !!!
@excelisfun
7 жыл бұрын
You are welcome!
@sim7717
8 жыл бұрын
Whatever you teach in your video whether it is excel or VBA that turns out to be awesome for a learner like me or thousand others. It would be good for us to learn VBA from you as well. But so far I know you barely like to go through VBA coding. Anyways, don't get me wrong because whenever I learn anything from you I find that I can be a master of that very thing. You are the best. Long live sir!
@excelisfun
8 жыл бұрын
As I said in the video, I do not know how to write VBA so I can't do videos about VBA. Sorry about that.
@sim7717
8 жыл бұрын
Thanks for your reply, sir. God bless you.
@Lisaquirit
Жыл бұрын
You deserve a medal
@khubaib-binehsan
3 жыл бұрын
I just want to say one thing and that is I LOVE YOU MANN!!
@excelisfun
3 жыл бұрын
I love you too, man!!! I am glad that the videos help.
@ashishmishra9692
6 жыл бұрын
No one does it(excel) better like mike. He is my online guru thanks for your all tutorial "mike"(with absolute reference)🤗
@excelisfun
6 жыл бұрын
Glad you like it, ashish!!! Thanks for the support with your comment, Thumbs Up and Sub : )
@rodion-z
8 жыл бұрын
You videos are the most amazing and useful. Thank you for spreading the knowledge (and fun!)
@excelisfun
8 жыл бұрын
You are welcome! Thanks for Thumbs Up on each! : )
@shubhampawar8506
3 жыл бұрын
Copying code is really cool ..like it ...you are genuious ❤️
@excelisfun
3 жыл бұрын
You made it through another class, Excel Expert shubham!!! On to E-DAB and then MSPTDA : )
@shubhampawar8506
3 жыл бұрын
@@excelisfun yes ,now I'm gonna move to E-DAB...thanks a lot once again for such amazing stuff for free ...you are very kind hearted and generous..❤️😍
@Chamchijjige
3 жыл бұрын
About to say "Class over! That was fun!" :)
@canefan17
7 жыл бұрын
Fantastic video! I don't want to dive into the world of vba, but simple record macros such as this is definitely something I wanted in my toolbox. Thanks
@excelisfun
7 жыл бұрын
You are welcome!
@forzaalgiers2045
8 жыл бұрын
Another Fruit from the Excel Garden.Thank you
@excelisfun
8 жыл бұрын
You are welcome!
@eCabinetstipsandtricks
8 жыл бұрын
Great job. I wish you made this video 4 years ago when I tried to record my first macro. Looking forward to more like this.
@excelisfun
8 жыл бұрын
I do not know how to write VBA. Sorry about that. This video is the extent of what I know.
@rahulpareekbikaner
7 жыл бұрын
Thanku so much sir. You are doing a great job..
@excelisfun
7 жыл бұрын
You are welcome!
@himanshudalai1028
5 жыл бұрын
Thank you Mike for this awesome video !! You have made life easy for non-coders like me :)
@excelisfun
5 жыл бұрын
Non-coders, like us : ) Me too!!! You are welcome, HIMANSHU!!!!
@mohammedahsaini1613
5 ай бұрын
Hey, i just wanna thank you for all your efforts you do for everyone. i ll soon finish your basic class excel and i wanna learn about coding and vba, can i start directly this course playlist, or i need to go for advanced excel course and then come here. thank you in advance !!
@excelisfun
5 ай бұрын
Basics and then advanced. But if you have M 365 then you should do MECS class. I guess you are not subbed and have not seen my home page at KZitem with my intro video? That goes over everything: www.youtube.com/@excelisfun
@mohammedahsaini1613
5 ай бұрын
@@excelisfun Ah thanks, I ve already subscribed just didn't see that video, i will follow your advice. Thanks again for everything you do !
@Q8Patriot
7 жыл бұрын
Thanks Girvin .. Appreciate your time :)
@excelisfun
7 жыл бұрын
You are welcome!
@ajaymore3009
8 жыл бұрын
Very nice series sir ! It was a great experience of leaning Excel from you. There were nice additions such as dashboards, power queries and many more compared to previous highline series. My only recommendation will be to move video no 3 after video no 17. It was too early in the series. Also, I will be grateful if you could start a series on VBA programming. You are a great teacher. Thanks.
@excelisfun
8 жыл бұрын
Thank you for the recommendations. I will try and do better next time. As I said in the video, I do not know how to write VBA so I cannot start up a series on VBA.
@mantaray5645
7 жыл бұрын
really helpful... AMAZING I'm going to recommend this channel to my friends...
@excelisfun
7 жыл бұрын
Glad you like it! Thanks for your Sub and Thumbs Up on each video : )
@cmaman1
8 жыл бұрын
Dear Mike Thank you very much & Why this is last video , you said before this series will be 50 videos
@excelisfun
8 жыл бұрын
Only 26 becasue for this series I decided to do many hour log videos rather than many shorter videos. All content that I intended is in series.
@cmaman1
8 жыл бұрын
Thank you , I appreciate your efforts
@excelisfun
8 жыл бұрын
You are welcome! Thanks for your Thumbs Up on all the videos!
@PedroCabraldaCamara
8 жыл бұрын
absolute amazing class. Thank you very much
@excelisfun
8 жыл бұрын
You are welcome!
@abdiazizibrahim9163
Жыл бұрын
Thank you so much! You are amazing.
@excelisfun
Жыл бұрын
Glad you liked the class!!!
@SyedMuzammilMahasanShahi
7 жыл бұрын
Wow. Macros. Thanks Mike for another EXCELlent video.
@rajeshkalagara
6 жыл бұрын
No words... Thanks for making this video.
@krn14242
8 жыл бұрын
Hey Mike. Nice to see you dabble into the VBA waters. Great job.
@excelisfun
8 жыл бұрын
Thanks for watching, WRH!!
@excelisfun
8 жыл бұрын
Thanks for the .xlsb tip!
@mobr.
6 жыл бұрын
Thank you. This video is very clear and informative.
@niavras
4 жыл бұрын
Amazing work, as always. Thank you Mike!
@pmsocho
8 жыл бұрын
Huge and great video! Thanks for your work!
@excelisfun
8 жыл бұрын
You are welcome! Thanks for your work too, Teammate!
@luv1pocket
3 жыл бұрын
Can you do more on just Excel VBA more in depth. There isn't much on KZitem. Thank You
@SamerDebs
4 жыл бұрын
Great Video!
@excelisfun
4 жыл бұрын
Glad it helps, S Deb : )
@jarbzfabe012
7 жыл бұрын
Sir, your video tutorials are very amazing! I'm currently making a medicine inventory worksheet. I'm trying to figure out how to update my inventory everyday from my dispensed medicines. Most of the medicines have the same names but different serial numbers. I need to know which medicines will be expiring before 3 months from expiration, almost finished stocks, auto updated medicine list with day-to-day numbers to how many being dispensed during that day. Thanks sir!
@josepedromunizvargas691
8 жыл бұрын
Thnk you very much! Mike...you are a master.
@excelisfun
8 жыл бұрын
You are welcome!
@klaldju
7 жыл бұрын
Thank you so much, ExcelsFun! Do you have (or maybe you can recommend) a tutorial on the KPI function?
@Chimp_No_1
8 жыл бұрын
Wonderful and a great help. Many thanks.
@excelisfun
8 жыл бұрын
Glad it helped!
@bipinsagar123
5 жыл бұрын
thanks a lot for your efforts.
@asmaheshcr7
5 жыл бұрын
You must be crazy!! Thanks a lot for your help!!
@johnsonbrown5735
7 жыл бұрын
Excellent, Superb.
@ndelpurg
7 жыл бұрын
Many thanks professor
@rumviktor
8 жыл бұрын
Классно! Спасибо.
@sjn7220
8 жыл бұрын
Awesome video, thanks!
@excelisfun
8 жыл бұрын
You are welcome!
@AhmedAbdalalim
5 жыл бұрын
nice one
@edwardwatson8937
8 жыл бұрын
Hi Mike, Another question. How do I get rid of the "#REF!" in a summary table of pivot tables?I created a summary table of four pivot tables, where each row corresponds to a total row of a pivot table. All I did was use the "=##" feature where ## was the cell in a pivot table and the data in the summary table row said "=GETPIVOTDATA..."Somehow, the ISERROR command does not work when the table references pivot tables.Thanks for the awesome things you do.Ed:-)
@emiliotzum186
6 жыл бұрын
I'm on a site that has several tabs. i can click on it but each clickable tab has no id, name or class. It just has: Title Title ("Music Tab") I have tried IE.Document.getElementsByTitle("ElementName")(0).click IE.Document.getElementsByTitle("ElementName")(0).submit IE.Document.getElementsByTitle("ElementName")(0).select IE.Document.getElementsByTitle("ElementName").click IE.Document.getElementsByTitleName("ElementName")(0).click But none of those work
@md.ishtiakazim9754
7 ай бұрын
Done
@excelisfun
7 ай бұрын
Awesome!!! I am so glad that you made it through and had fun doing it : )
@adriensagna717
6 жыл бұрын
Amazing stuff
@xiaobincheung6660
8 жыл бұрын
Hi Mike! Thanks for your excellent work!! Really useful and wonderful videos! But now I've got a problem, it seems the file link isn't available? There is no way for me to download files from class 16 to class 26. Would you mind helping me with this situation? Thanks a million!
@alvinaverghis7570
Жыл бұрын
Where can I download these worksheets?
@lazalazarevic6192
8 жыл бұрын
XLNT video, VBA are such timesavers
@excelisfun
8 жыл бұрын
Yes they are!
@khurramsamnani768
5 жыл бұрын
how can we create macros of variables row using countifs formula
@Berghiker
7 жыл бұрын
The deveoplers tab and the design mode is not showing up. It just won't show! Can you please show me how to get the developers tab and design mode in my version of excel 2016? very 15.23.
@Ehole_84
3 жыл бұрын
I got the name error when I copied the code into the VBA editor.
@dejanjovovic8807
6 жыл бұрын
Mike,could you please upload this file again? It seems that for some reason it can't be downloaded. Maybe it's only me, but just to check...
@Chamchijjige
3 жыл бұрын
"Class over! That was fun!"
@excelisfun
3 жыл бұрын
Yes!!! Congratulations on completing the class : )
@bhpadsumbia1775
8 жыл бұрын
thank you
@excelisfun
8 жыл бұрын
You are welcome!
@skillhub5073
4 жыл бұрын
great
@excelisfun
4 жыл бұрын
Macros are fun : ) : )
@doareuGDZ
8 жыл бұрын
Hey, great video. I have a question, do you know how can I make a macro to run automatically even if I have multiple excel files opened? I know how to make the macro to run at specific time and to start when I open the file, but if I am working on other file (workbook) at the moment when my macro has to run, I will receive an error because I am not on the right file. I don't know if I make myself clear but maybe you can help me. Thank you for your videos
@mzd5990
5 жыл бұрын
You can save the macro you created and use the "add-in" in other excel files where you want use the macro you created. Go to developer tap in excel click on "excel add-ins" browse for the file (saved macro file) and click ok. After doing so if you go to "Add-ins" tab in excel you will find your add-in and if you run it you will get the result.
@Rita-us5cd
6 жыл бұрын
Why there is #NAME after i enter the code to use sumbycolor?
@rekhapons3400
6 жыл бұрын
Thank you.please. I have a workbook with a multiple worksheets which have external links and formulas. I need to Split the work sheets and sent to various recipients with other documents eg, one work book has c30 worksheets named as 1,2,3.4.5.6....30. And I need to send sheets 1&2 as one workbook to one recipient via mail and 2,3&:7 sheets as one workbook to another mail recipient and so on. And also I need to attach another document with these workbook as well before I mail to the relevant recipients every month. Could you please kindly post a video to automate this process via VBA solution on you channel please . It’s very urgent. Thank you so much
@topchoice32
8 жыл бұрын
do u know anyone that make an excel sheet on vlookup between 2 spread sheet
@LorisAyoub
6 жыл бұрын
Hi there I need help please, I have a main sheet when I add data, coworkers use macros, so if I add a new data that they have on their macro, my vlookup formulas should read that it is a duplicate, but somehow they are not updating. Is there a solution for this? I work with dropbox
@kenkrak4649
6 жыл бұрын
write you question on reddit's /r/excel subreddit
@darshanshah9711
7 жыл бұрын
hey mike , can u put some videos of ms word & outlook.
@ramyasuresh143
7 жыл бұрын
Hi.. Im unable to download this excel.. pls help
@royalnass1029
6 жыл бұрын
everytime I type Change or % Change in the header the program shuts down
Пікірлер: 128