Learn Ms. Office easy & fun with me. I
want to share my knowledge with others. I will upload the next
next learning video. Please wait for my next video. Thank you
thank you for watching my videos.
Like, Subscribe, Comment, Share All my videos @EvaWahyuni-Learn-IT
How to create a simple invoice/expression/shopping receipt.
kzread.info/dash/bejne/mqmmyK2BXbCneJM.html
4 Tricks to Set Row & Column Size in Excel.
kzread.info/dash/bejne/dWaax9ijYs6uhMY.html
Tricks on how to quickly add blank rows in each cell.
kzread.info/dash/bejne/aIiEydiCmtOZfqg.html
8 Tricks to Create Sequential Numbers in Ms. Excel 2021/365.
kzread.info/dash/bejne/oXWpzLmFgbSxeco.html
GMetrix Excel Expert 365 MOS - 211 :
Practice Exam Training :
kzread.info/dash/bejne/eZdm1amEhNHNidY.html
kzread.info/dash/bejne/jGummbdtfbzIdc4.html
kzread.info/dash/bejne/p6SDl9qtdNvScqg.html
Skill Review Training :
kzread.info/dash/bejne/lHx20tmFf66rY9I.html
kzread.info/dash/bejne/m6Bostt6f9i4irg.html
#exceltricks #excel #exceltutorial #excel365 #excelfunctions #exceltips #excelformula #videoyoutube #microsoft #microsoftexcel
Пікірлер
Got a question for you. Does the Gmetrix practice exams help with a Certiport exam? I am preparing for a MO-211 Excel Expert exam. Thank you!
@lifeprojectG GMetrix is a system for practice. For the Mo-211 exam, another system is used which must be downloaded according to the exam schedule. MO-211 exam results will be integrated into Certiport. Thank you
@@EvaWahyuni-Learn-IT thank you! So you would say Gmetrix is a good study tool for the MOS-211 exam?
@@lifeprojectG Of course, GMetrix provides tools that teach us menus & functions from Excel Expert 365, and GMetrix also provides incorrect or correct information as well as step by step "helps" to answer them.
@@EvaWahyuni-Learn-IT Thank you very much! I'll plan on ordering their practice tests.
Share excel expert exam 211 videos
@zuhairhaq1 Maybe someday I'll make a video and I'll share it.
For Project 2 Task 1, shouldn't Adult Annual Pass (US $) be formatted as an area chart instead of a column chart? This is very helpful, thank you for posting.
Hi @kimijones8710 Yes, you are right, I answered incorrectly according to the question, but the answer desired by the GMetrix system turned out to be a column chart. it was corrected (checklist) at the end of project 2
Ditunggu ya @ubaidillahmuhammad20
lampirkan file nya kak. enak banget penjelasannya
docs.google.com/spreadsheets/d/1M3DyMyxt80CJYtf1SDe7mzKhmmU6O-ee/edit?usp=sharing&ouid=114967402657052806817&rtpof=true&sd=true
@@EvaWahyuni-Learn-IT Trims, untuk materi materi lain nya yang ada di video ini tentang excel
Last project; how did you drill down tablets data?
@Saiftalk4s Double click on the cell
@@EvaWahyuni-Learn-IT Thanks.
bedanya concat sama concatenate apa ya?
CONCAT bisa diblok. Tunggu video selanjutnya ya Kak. Atau silakan klik link video panjangnya.
Lembaga sertifikasi di Indo untuk ambil MO-211 exam apa namanya ya kak? Kakak dulu ujiannya dimana? Boleh dispill kak, terima kasih🙏
@umarsyahrum287 Ada beberapa Test Center, salah satunya bisa kunjungi link ini ya itc-indonesia.com/ . Semoga membantu🙂
Terima kasih atas infonya kak🙏
Pls share exam vid
hi dude again))) I guess you did mistake at 3:00, maybe you should select Formulas---Formula auditing---Error Checking for done task
Hi @mushfiqsuleymanli9064 Please see the correction results from the gmetrix system. That was correct. The answer results have been checked in the Gmetrix system. Thank you
P 5/5 task 4 - I guess you did error, you moved up product name up to country name? pls check it when you have the time
Hi @mushfiqsuleymanli9064 Please see the correction results from the gmetrix system. The answer results have been checked in the Gmetrix system. That was correct. Thank you
Office 2019 pleasee
Hi @braydenhurst1673 Let's upgrade to Office 365
Could you do the gmetrix excel expert practice exam 1 and 2 testing modes?
GMetrix Excel Expert 365 MOS - 211 : 1. Practice Exam 1 Training kzread.info/dash/bejne/eZdm1amEhNHNidY.html 2. Practice Exam 2 Training kzread.info/dash/bejne/jGummbdtfbzIdc4.html 3. Practice Exam 3 Training kzread.info/dash/bejne/p6SDl9qtdNvScqg.html 4. Skill Review 1 Training kzread.info/dash/bejne/lHx20tmFf66rY9I.html 5. Skill Review 2 Training kzread.info/dash/bejne/m6Bostt6f9i4irg.html
Be careful!!! you did mistake on the project 3 task 2
@mushfiqsuleymanli9064 Yes, you are right, the results were not as expected. However, that is the answer the system wants, if the Feedback from "Grade Project" is checked, it means it is correct
@@EvaWahyuni-Learn-IT thx, I sent you a e-mail can u answer it?
@@mushfiqsuleymanli9064 Previously I tried the correct method, but in the GMetrix system it turned out to be incorrect. Thank you for your attention, Sir
You are right. To fix the error: instead of selecting whole A column at the beginning, select only range of cells from A3.
hi, thx for help. I sent a e-mall to your e-mail box adreess - which you type in youtube profile. Answer it if u can.
Mantab, bermanfaat sekali
@killsammy372 Aku ikut senang. Terimakasih😊
No se oye
Yes, because I've never made a video using sound, Sir
Hi @Yohago-nu7qx Now I've given subtitle in English😊
In project 4/5, task 3, you sorted the table by Region and then Country, while the question was stated to sort it by Region then City.
@ahmedhamouda1795 Yes, that's right Sir, because I have tried following the question instructions but it turned out to be incorrect and in GMetrix's "Help" it turned out to sort it by Region then Country.
How can I do a practice exam myself?
@merykassis Watch and wait for my next learning videos. For Gmetrix, you could contact the Microsoft team.
I mean, practicing a test needs purchase or is it free?
I watched your videos and now I need to practice a test before the real one
@@merykassis Purchase order, GMetrix is not free.
Thanks alot for your help with exam practices❤❤ These videos were big help to me
@merykassis I'm happy to help. I hope my videos are useful for you.🙏🏻
Watching my video. Simak video saya, ada 8 trik cara membuat nomor urut di ms.excel.
Thank you so much and thank you for not putting any annoying background sound so I can concentrate
I'm happy to help. Hopefully my videos are useful for you.
Pls share 3xam. Thank you
Hi @zuhairhaq1 The exam excel is similiar to the practice on GMetrix, Sir. Repeat these 5 practices often until you proficient and get a passing grade. Thanks
Hi I need help as I am unable to schedule my MO 211 exam
Hi @siddhantgupta8863 Have you confirmed scheduling with the MOS exam provider partner? Prepare yourself by practicing until you are proficient and stay healthy.
@@EvaWahyuni-Learn-IT hello I have trying to schedule the exam from Microsoft and when I clicking to schedule exam I was routed to certiport. Is Ceritiport the MOS exam partner ??
Yes that's right. Certiport is a certification provider, for the exam you must download the "compass" application. If you had some trouble with your computer, you should contact the mos exam service provider and ask for help in carrying out the exam at their office. After the exam, you can download a transcript of your scores and certificate at certiport.com. Good luck Sir.
The MOS exam provider's office is where we purchased the MOS exam package and answered our questions about exam issues.
Could you please provide me the link of the website as I am able to purchase the Power BI course but not the MoS excel expert 😢