Listen, I'm a junior this year in high school and this is my first year ever taking certification test. I just wanted to thank you a lot because your videos have helped me pass my Powerpoint, and word certification tests. Today, i'm taking excel and pray that I pass it. Never thought I would able to ever pass one of the certification test but your videos has helped me pass them. Also, I passed my word and powerpoint with more than a 828 on word & 868 on powerpoint. Just pray I pass excel today!! THANK YOU SO MUCH!
Hi Van Le Thanh. Thank you very much to share the practice files. I have added all tasks' guide to one excel sheet. Then I practiced before I compared and confirmed with your solutions. It helps a lot. I am more confident to have the exam. I will let you know once I pass. Grace Zhang
Hello, I truly believe there is a miskate in the solution of project 4 task 4. There is explicitly stated fill cells f5:f43, however you fille only f7 and on. Cells f6 and f5 were left out.
This is a mistake in the question. The exactly task is: "On the "Math" worksheet, use an Excel feature to copy the formula in cell F7 so that it fills F8:F43." (not F5:F43)
@@vanlethanh I get it. However it doesnt matter if mistake is in the question. In the test you are supposed to complete exactly as you are asked, otherwise you dont get points. Even if it doesnt make sense. This way you couldnt get 100% I believe.
Hello Le, I truly beileve that project 1 remove duplicate is not correct. In your case your actions removed entire rows. However it was stated clearly - do not remove anything besides duplicate names. Please comment on that a find better solution. This is clearly not according to what they wanted. Thank you kindly
@@josefhlava9575 "...remove all records with duplicate "CustomerName" values from the table. Do not remove any other records." This is mean you have to delete all the records (rows) which have duplicate "CustomerName" value. Record is Row not Cell.
Hello again ':D. I believe task 1 in project 5 doesnt make any sense... There not 5 years, only year 2014, it is not clear one should insert sparklines in column H. I solved it different way. However it doesnt matter how I solved it. This question is flawed I believe.
I have fixed all the mistakes you told in my application last year. This video is just a beta version, so it will have some mistakes (may be in file, in task content..).
Listen, I'm a junior this year in high school and this is my first year ever taking certification test. I just wanted to thank you a lot because your videos have helped me pass my Powerpoint, and word certification tests. Today, i'm taking excel and pray that I pass it. Never thought I would able to ever pass one of the certification test but your videos has helped me pass them. Also, I passed my word and powerpoint with more than a 828 on word & 868 on powerpoint. Just pray I pass excel today!! THANK YOU SO MUCH!
Yo bro did you pass?
I can confirm a good amount of the questions are like these. I got a solid 800! Thank you
Thank you so much!! I'm Fiqa from Indonesia, and yesterday is my first certification of excel. I have skor 1000 because your video❤❤🙏🙏
Congratulation!!!!
Want to thank you. Just passed my exam with a 907 score all thanks to this video
Congratulations! This is the first video i have seen with comments in the last few months, it is good to know.
Hi Van Le Thanh.
Thank you very much to share the practice files. I have added all tasks' guide to one excel sheet. Then I practiced before I compared and confirmed with your solutions. It helps a lot. I am more confident to have the exam. I will let you know once I pass.
Grace Zhang
Did you pass?
@@pwnagenuss ong did these people pass?
Yessir I passed 💯 thanks bro your video was helpful👍
I just made a 914 on my retake thanks to your video. Thank you!!!
Guys this is the REAL one! i just passed my excel exam. It is like 80% accurate.
Ad ơi phần mềm đầu tiên ad dùng là ad tự viết ạ ??
bài ad làm hay lắm ạ. E cảm ơn !
However I am still convinced you do great job ↑
I only watched this video and I got 940 omg thanks !!!!!!
Tks cô nhiều, đề thi của em có nhiều câu giống cô
Có câu nào ngoài không bạn. Nếu nhớ thì note lại giúp mình để mình cập nhật thêm cho mọi người
Great video my Friend, but... where are the instructions for each file or book?
You can see the questions on the video.
@@vanlethanh Obrigada! !!
Phần mềm đầu tiên cô sử dụng để hiển thị yêu cầu của project là gì vậy cô?
Cảm ơn cô!
Phần mềm tự viết nhé bạn.
Where could I get this exercises? Thx
Hello,
I truly believe there is a miskate in the solution of project 4 task 4. There is explicitly stated fill cells f5:f43, however you fille only f7 and on. Cells f6 and f5 were left out.
This is a mistake in the question. The exactly task is: "On the "Math" worksheet, use an Excel feature to copy the formula in cell F7 so that it fills F8:F43." (not F5:F43)
@@vanlethanh I get it. However it doesnt matter if mistake is in the question. In the test you are supposed to complete exactly as you are asked, otherwise you dont get points. Even if it doesnt make sense. This way you couldnt get 100% I believe.
Hello Le, I truly beileve that project 1 remove duplicate is not correct. In your case your actions removed entire rows. However it was stated clearly - do not remove anything besides duplicate names. Please comment on that a find better solution. This is clearly not according to what they wanted. Thank you kindly
However other solutions as I search are complicated and cumbersome...like long nested formulas and like.
@@josefhlava9575 "...remove all records with duplicate "CustomerName" values from the table. Do not remove any other records." This is mean you have to delete all the records (rows) which have duplicate "CustomerName" value. Record is Row not Cell.
What software are you using? And are we able to download it?
You can go to Facebook : Training Mos Online. I found out this software from here
@@vanlethanh thank very much
cho em hỏi cái project cuối task cuối đề đâu kêu print đâu ạ , gthich giúp em vs ạ
đề yêu cầu tùy chỉnh 3 sheet vào 1 page. Page đây là page khi in ra đó bạn.
@@vanlethanh dạ em cảm ơn ạ
How do I convert .rar file?
Extract it with Winrar.
can someone confirm that this is accurate to the exam?
can confirm that this is mostly accurate to what i saw on the exam
@@seanvaz3438 like 80-90% real exam
Is this the Test for Excel or Excel Expert?
Test for excel, not expert. You can get more in description.
Cô để nhạc hay quá thành ra ko tập trung được vào bài
Hello again ':D. I believe task 1 in project 5 doesnt make any sense... There not 5 years, only year 2014, it is not clear one should insert sparklines in column H. I solved it different way. However it doesnt matter how I solved it. This question is flawed I believe.
I have fixed all the mistakes you told in my application last year. This video is just a beta version, so it will have some mistakes (may be in file, in task content..).
@@vanlethanh Your work is still great and helps a lot of people. I love your work! Would you create Publisher videos? And also Outlook videos? :)
please share course files also
Does anyone have the data?
Cô ơi có file thực hành k ạ
Dưới phần mô tả có file excel thực hành đó bạn
Cô ơi có Tiếng Việt k ạ!???
Để mình đi thi xem ntn rồi sẽ cập nhật sau nhé bạn. Tiếng anh dễ đậu hơn đó bạn.
Van Le Thanh này thi ở IIG đề tiếng anh vẫn giống vậy đúng ko ạ
@@kristpham898 giống 80-90%, khác file thôi nhé
Van Le Thanh các yêu cầu bằng tiếng anh vẫn vậy đúng ko ạ
@@kristpham898 Đúng vậy bạn
Is this the real test?
Like 90% real test.
hello
Boring vedio ever🤣🤣