This is the first instruction in a long time that I was able to learn from without being confused at the end of the webinar.
@MyExcelOnline
7 ай бұрын
That's so great! Thanks for watching!
@MyExcelOnline
4 жыл бұрын
💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html
@UDADNAMAS
Жыл бұрын
Amazing presentation in the simplest mode of conveying! Thanks a million. Congrats. Learnt a lot in a single video.
@MyExcelOnline
Жыл бұрын
Glad it was helpful!
@manjulaa1179
Ай бұрын
Thanks a lot for the detailed explanation and the free excel sheet. So helpful😊
@MyExcelOnline
Ай бұрын
You are welcome 😊
@nicoleplatt6658
2 жыл бұрын
This one proved extremely helpful in a large spreadsheet with lots of data. Thank you so much. The content of the spreadsheet was easy to understand so that the formula may be understood for the interpretation and research of other data sources. Loved It!
@MyExcelOnline
2 жыл бұрын
I am so glad we were able to help you. Hope you keep watching! We have weekly videos.
@ranimaharaj-sharma4332
5 жыл бұрын
One of the best trainer and great Training Company
@MyExcelOnline
5 жыл бұрын
Thanks for your kind words Rani, you rock buddy :)
@bambie381
5 жыл бұрын
Very informative. You did an excellent job explaining everything. Thank you !
@MyExcelOnline
5 жыл бұрын
Thanks for the positive Excel feedback, we appreciate it :)
@mosesgiticha9719
5 жыл бұрын
well said simple,loud and clear.
@MyExcelOnline
4 жыл бұрын
Thanks for your comments and I hope that you learned lots of new Excel Formulas!
@AliciaAli7270
4 жыл бұрын
I thoroughly enjoyed this video, Mr Kyle Pew, you are an excellent teacher.
@MyExcelOnline
4 жыл бұрын
Thanks Alicia for your kind words!
@lancerichard7120
Жыл бұрын
Outstanding trainer.
@MyExcelOnline
Жыл бұрын
Thanks!
@jerrymilesmiles9313
Жыл бұрын
Outstanding! Best regards from Limón, Costa Rica!
@MyExcelOnline
Жыл бұрын
Thank you very much! So glad you liked it!
@milies3613
2 жыл бұрын
Thank you so much. It's a brilliant video. More ppl should see it!
@MyExcelOnline
2 жыл бұрын
Glad you enjoyed it! Thanks for the feedback!
@brandoncarlson1508
5 жыл бұрын
I'm learning functions in excel and this video is phenomenal. I haven't seen another like it!!
@MyExcelOnline
5 жыл бұрын
Glad we were able to help you learn Excel functions Brandon :)
@whysoserious3784
2 жыл бұрын
Thank you for sharing your knowledge - stay health and again thank you - humanity can work together
@MyExcelOnline
2 жыл бұрын
You;re welcome. Hope you stay healthy as well. You are right, we should always be working together to share what we know and learn from each other.
@oliverw3646
11 ай бұрын
Very well taught! Thank you.
@MyExcelOnline
11 ай бұрын
You're very welcome!
@RiteshRG-v1t
3 жыл бұрын
Absolutely clear, Thanks a lot man!!!
@MyExcelOnline
3 жыл бұрын
You are welcome
@melissaverea1875
5 жыл бұрын
This was awesome and super helpful. THANK YOU.
@MyExcelOnline
5 жыл бұрын
You are welcome Melissa and keep on learning Excel and Formulas!
@hoanggiacompany5996
2 жыл бұрын
Thanks ! From Vietnam
@MyExcelOnline
2 жыл бұрын
You are welcome! Thanks for telling us where you are from. It's nice to see so many people from around the world using Excel!
@sandeepkothari5000
5 жыл бұрын
A great webinar!
@MyExcelOnline
5 жыл бұрын
I am glad you enjoyed our Excel Formula webinar Sandeep!
@ghadaragab9073
3 жыл бұрын
Thank you so much for the great course
@MyExcelOnline
3 жыл бұрын
Glad you liked it!
@bouasonephouikhambay4081
4 жыл бұрын
I think that you should call the dollar symbol " freeze " the cell you wish not to carry down as apart of the replicate command which interferes with the command. It would help new learners understand the reason for the dollar symbol
@MyExcelOnline
4 жыл бұрын
Thanks for the suggestion and it makes sense :)
@bouasonephouikhambay4081
4 жыл бұрын
@@MyExcelOnline I learned that from my instructor. I took the basic course and am seeking to expand my knowledge in the use and functions. I would like to be able to help my kids of and when they come across school work that involves using word and excel
@MyExcelOnline
4 жыл бұрын
@@bouasonephouikhambay4081 I am sure that your kids will become Excel gurus!
@fikruhabte8166
2 жыл бұрын
You are a great teacher .
@MyExcelOnline
2 жыл бұрын
Thanks for that!
@lawrencekamau9221
2 жыл бұрын
BRAVO. I LOVED IT
@MyExcelOnline
2 жыл бұрын
Thanks!
@sakshisaini3201
2 жыл бұрын
To the point and easy to understand, thank you for these videos, they are helping a lot in my company work project
@MyExcelOnline
2 жыл бұрын
Great to hear!
@oanhluong7051
3 жыл бұрын
Thank you so much for all of your lectures. I would greatly appreciate it if you could please do more videos that related to using excel formula to estimate student hourly payroll bi-weekly? Thanks
@MyExcelOnline
3 жыл бұрын
Thanks. We will consider that.
@Kate-tx4zk
3 жыл бұрын
I'm not even halfway done but have already learned so much. The instructor is amazing. Thank you so much for posting this video. ❤️
@MyExcelOnline
2 жыл бұрын
Glad you are liking it! We also have a blog at www.myexcelonline.com/blog/ if you would like to learn more.
@angelabarreneche5709
3 жыл бұрын
Great video!
@MyExcelOnline
3 жыл бұрын
Glad you enjoyed it
@diachpriscilla6154
2 жыл бұрын
excellent teacher bravo for the great video
@MyExcelOnline
2 жыл бұрын
Glad you liked it!
@sandravaldez1241
2 жыл бұрын
Very easy to follow , Thanks
@MyExcelOnline
2 жыл бұрын
You are welcome! Glad it was helpful!
@ricollchung
4 жыл бұрын
very good tips and training. well presented. very useful. thx.
@MyExcelOnline
4 жыл бұрын
Glad you liked our Excel Formulas webinar. Check out more free VLOOKUP tutorials over at our blog here: www.myexcelonline.com/category/formulas/lookup/vlookup/
@antuwarule6740
5 жыл бұрын
Nice Explanation
@MyExcelOnline
5 жыл бұрын
Im glad you liked our Excel Formulas tutorial Antu!
@wrlomprez3802
Жыл бұрын
WooHoo Love ya man excellent Training by far
@MyExcelOnline
Жыл бұрын
Thanks! So glad you liked it!
@hesboniuos
3 жыл бұрын
excellent teaching i have really gained a lot
@MyExcelOnline
2 жыл бұрын
That's great! Hope you keep learning more and adding to your Excel skill set.
@bestfireplace4173
5 жыл бұрын
U r awesome!! Gd teacher
@MyExcelOnline
5 жыл бұрын
Im glad you liked this Excel Formulas tutorial!
@abayomi-alliolusola6477
2 жыл бұрын
I really enjoyed the video. Thank you so much
@MyExcelOnline
2 жыл бұрын
You're welcome! Glad you enjoyed it!
@sharmahemkanta1898
2 жыл бұрын
Sir, thank you for this video.The is extremely clear....
@MyExcelOnline
2 жыл бұрын
You are most welcome
@sagehousecondominium5985
2 жыл бұрын
good presentation and very helpful
@MyExcelOnline
2 жыл бұрын
Glad it was helpful! Thanks for watching!
@shaiksufiya4927
3 жыл бұрын
AMAZING
@MyExcelOnline
3 жыл бұрын
Thanks Shaik!
@seattlestunna
2 жыл бұрын
Thank you!!!!!
@MyExcelOnline
2 жыл бұрын
You're welcome!
@RubenRodriguez-jx4sc
5 жыл бұрын
Kyle did an excellent job! Now I know how to use these functions 👌🏻
@MyExcelOnline
5 жыл бұрын
Great to see you getting better at Excel formulas Ruben! Keep the momentum going :)
@frankys1820
3 жыл бұрын
How did you select a large range of cells without scrolling with the mouse to select them? Thank you.
@MyExcelOnline
3 жыл бұрын
If you click on a cell, on the bottom right there is a box. If you double click that box, everything below it with data will be selected. Hope that helps!
@logeshs3067
3 жыл бұрын
hi sir your videos are really cool . your teaching style is also unique. i have a doubt sir. how to put rank for changing numbers. for eg- if number is changing every second rank1 if number is changing every 2 seconds rank2 if number is changing every 3 seconds rank3 if number is changing every 4 seconds rank4 like this
@MyExcelOnline
3 жыл бұрын
Do you think a Nested IF would work for what you are trying to do? We just released a video on that topic last week. Check it out on our channel!
@logeshs3067
3 жыл бұрын
@@MyExcelOnline how to use nested if in relation to time
@logeshs3067
3 жыл бұрын
can u help me out with those formulae
@--Franklin--
Жыл бұрын
*Can you guide me??? what should I use at **21:33**, to sum up the Total Units (H3 cell) whenever I change Store# (G3 cell)??? I typed =SUMIF(G3,C3:C272,E3:E272) but it shows **#SPILL**... By the way, your lessons are so understandable even for a beginner like me!* 😊😊
@MyExcelOnline
Жыл бұрын
Sure. Thanks for the comment. Glad you find out videos helpful. So for any sum cell, you can just use the SUM function if you would like. Try =SUM(the cells you want). For the cells you want, just select the cells after the first parenthesis (. Hope that helps!
@shaiksufiya4927
3 жыл бұрын
Could you make a video on excel functions.
@MyExcelOnline
3 жыл бұрын
We have plenty of Excel functions in our Playlist
@flyguywhoeye4892
2 жыл бұрын
I learned so much! One question I have a Mac and when i hit the FX button only insert function pops up and not the Function Argument menu. Wondering is there a fix to correct this problem I am having?
@MyExcelOnline
2 жыл бұрын
Glad you liked it. We actually have a blog entry for shortcut tips for a Mac and PC. Maybe you'll find that helpful? www.myexcelonline.com/blog/333-excel-shortcuts-for-windows-and-mac/
@atosuleman606
2 жыл бұрын
the 3rd one iny workin
@MyExcelOnline
2 жыл бұрын
Hi. I am not sure what you mean. Could you please clarify? Thanks.
@lawrence.m.katongo3117
2 жыл бұрын
Excellent job my dear. I've learned a lot. kindly help me with the formula on how to pick only the highest scores in a range of scores and sum them up. For example, a student wrote NINE subjects, and out of this, a student managed to score above 50% which is the Pass Mark in all the NINE subjects. Now you only want to PICK and add the Subjects with the Best Marks leaving out those with low marks. Kindly help as this has always been giving me problems whenever I want to fill up the Report Books for my students at the end of each term as end up doing it manually every time.
@MyExcelOnline
2 жыл бұрын
Hi. Thanks so much for watching! It sounds like you may benefit from the SUMIF function. Would you like to look that one up and get back to us if you need further help?
@mansourdiop7216
3 жыл бұрын
Great video! How to get the excel files?
@MyExcelOnline
3 жыл бұрын
The workbook is in the description!
@vikashahlawat9036
3 жыл бұрын
This video is very helpful for me , but sir this video is very long. Kindly make it short
@MyExcelOnline
3 жыл бұрын
We have some shorter ones that go into detail for several formulas. Please check our channel for that and feel free to make suggestions on which shorter videos you would like to see!
@vikashahlawat9036
3 жыл бұрын
@@MyExcelOnline Dear Sir, can you make a video on work and time , how to calculate time and work efficiency in excel .
@zeerakkhan6980
4 жыл бұрын
27:50 Why excel asks for true or false? every one wants exact figures, ...! can you please describe the phenomenon behind this "true or false" i really don't get this
@MyExcelOnline
4 жыл бұрын
Great question! I explain it in this tutorial: www.myexcelonline.com/blog/vlookup-approximate-match-in-excel/
@culvuil
2 жыл бұрын
Because if you have a large data set, and you don't want absolute values sometime. For example, you want to know all the Honda models being sold at your dealership, then you can look up Honda without the absolute value and it will show up all the models listed
@MB-wt7vw
3 жыл бұрын
Nice
@MyExcelOnline
3 жыл бұрын
Thanks
@michelyu7.
2 жыл бұрын
Where can I find the file where in I can practice using the values given in the video? Superl helpful video! Thank you!
@michelyu7.
2 жыл бұрын
Got it already thank you
@MyExcelOnline
2 жыл бұрын
Cheers!
@nevinsronald8728
Жыл бұрын
👌
@MyExcelOnline
Жыл бұрын
Thanks!
@rheylfrheya6811
2 жыл бұрын
hi how to count date automatically? sample if you enter the date today, it will count automatically how many columns having date today.
@MyExcelOnline
2 жыл бұрын
Hi. Thanks for the question. You could try =COUNTIF(A1:A8,TODAY()) or replace the Today() with a specific date.
@phumzilenxumalo5517
2 жыл бұрын
where did you get the =12 from the function or what is the 12 represents need little detail
@MyExcelOnline
2 жыл бұрын
Could you please tell me the time stamp in the video that you are referring to? Thanks.
@mosesgiticha9719
5 жыл бұрын
How can one COMBINE Multiple Excel WORKBOOKS into One .For INSTANCE in the above example given assuming VLOOKUP, INDEX, MATCH, SUMIF,are our workbooks?
@MyExcelOnline
4 жыл бұрын
You will need to use Power Query as I show here: www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/
@punitsalwey7178
2 жыл бұрын
Hey , from where I can download practice sheet to practice along with watching the video
@MyExcelOnline
2 жыл бұрын
We just have the free worksheets for this one: myexcelonline.lpages.co/youtube-formulas-webinar-workbook-downloads/
@MyExcelOnline
2 жыл бұрын
Glad it was helpful.
@maryrasch8679
Жыл бұрын
How can I access the files to be able to practice ?
@MyExcelOnline
Жыл бұрын
If you register on our site, we'll email it to you: www.myexcelonline.com/ and click Register Now
@ArmenArmenjs
5 жыл бұрын
what if its horizontal sumif. for example Months July, Aug sept...
@MyExcelOnline
5 жыл бұрын
If you are using the horizontal cells in your "criteria" argument, then you will need to select those cells. The sales will also have to be in a horizontal alignment for this to work.
@vanessanghiem4586
2 жыл бұрын
hi, I can not download the practice file through the link, please help
@MyExcelOnline
2 жыл бұрын
Hi. You can follow this link and then hit the Download Now button and put in your email and it will be sent to you: myexcelonline.lpages.co/youtube-formulas-webinar-workbook-downloads/
@shadreckkakumba7784
4 жыл бұрын
Hello, how can i link up to excel lesson
@MyExcelOnline
4 жыл бұрын
Hello Shadreck, what exactly do you want to learn in Excel?
@shadreckkakumba7784
4 жыл бұрын
@@MyExcelOnline I want have access your lessons
@MyExcelOnline
4 жыл бұрын
@@shadreckkakumba7784 You can view access our Excel Academy online course here: www.myexcelonline.com/academy/enroll-now/
@isaacweah2780
2 жыл бұрын
How did get the sum of?
@MyExcelOnline
2 жыл бұрын
=SUM(all the cells you want to sum). So if you want to sun cells A1 through A5 it would be this: =SUM(A1:A5)
@atosuleman606
2 жыл бұрын
can i pls have the second sheet of formula 16:58 there is no sheet for it thank u
@MyExcelOnline
2 жыл бұрын
Are you able to sign up for the free course on our website? www.myexcelonline.com/
@chandrakantkamble3091
2 жыл бұрын
short cuts for Mac ?
@MyExcelOnline
2 жыл бұрын
Sure! Check this out: www.myexcelonline.com/blog/333-excel-shortcuts-for-windows-and-mac/
@sandravaldez1241
Жыл бұрын
How to download the spreadsheet?
@MyExcelOnline
Жыл бұрын
Hi! Thanks for asking. Please fill out your email on myexcelonlone.com and we'll send it to you.
@vocalrange7294
5 жыл бұрын
beginning sound needs improvement
@MyExcelOnline
5 жыл бұрын
Thanks for your input :)
@judegomez6901
Жыл бұрын
"GURU"
@MyExcelOnline
Жыл бұрын
Cheers!
@raydrayson2992
5 жыл бұрын
Hi, How do I ger the 2nd, 3rd, 4th, etc. instance in a List of Data
@MyExcelOnline
5 жыл бұрын
Hey Ray, can you please expand on your question. Which part of the video are you referring to?
@sandra8g
2 жыл бұрын
Vlookup is a formula I struggle with.
@MyExcelOnline
2 жыл бұрын
Thanks for watching! Yes, it can be complicated. Do you have Office 365? If so, XLOOKUP is available there and is so much better! We have a bunch of VLOOKUP videos, too. Check out this link: kzitem.info/door/PLWSweFpA2PEh_sGEH4jKWELe9V04A-wLz. At the bottom, videos 17 and 18 are just for VLOOKUP. If you have XLOOKUP, there is a video for just that function as well.
@shirleygoodwin1327
2 жыл бұрын
Credit card payment tine how do you do this
@MyExcelOnline
2 жыл бұрын
That would be an add in and a little more complicated to type here. If you'd like, you could refer this question to our consultants at www.myexcelonline.com/microsoft-excel-consulting-services/
@ElizabethKairuz-x4e
22 күн бұрын
Sum Macro
@MyExcelOnline
19 күн бұрын
I am not sure what you are asking here. Could you please rephrase your question? Thanks.
@Rashi-bw3mb
3 жыл бұрын
How to solve problem having Multiple Results For Single Query In Excel using Vlookup formula For Eg. in the question we have to find out the name of the students who get minimum marks ? the answer having Multiple Results how to solve the help of Vlookup formula
@MyExcelOnline
3 жыл бұрын
Please check out our Blog here for the answer: www.myexcelonline.com/blog/
@shoppersdream
4 ай бұрын
Can you please send the exercise file? I have submitted my email 3 times and still haven't received it. You should just put it in the Description rather than waiting for you to send a file to us.
@MyExcelOnline
4 ай бұрын
Hi! Could you check out your spam folder? As the mail could have went there. Cheers. Hope the exercise workbooks help!
@shoppersdream
4 ай бұрын
@@MyExcelOnline Thanks! I have checked my spam folder. Looks like if a person gets the file one time and then for some reason you can't find your files and try to get it again, you don't send it again. Thanks
@MyExcelOnline
4 ай бұрын
Do you happen to have another email address you could try?
@naifsaif1772
2 жыл бұрын
I DONT UNDER STAND SUM IF
@MyExcelOnline
2 жыл бұрын
Hi. Basically, it's a way to sum values only if they meet a certain criteria. Check out this blog entry for more info on SUMIF: www.myexcelonline.com/blog/sumifs-function-introduction/
Пікірлер: 163