My professor actually suggested we watch your videos before we take the MOS Exam. I will be taking it today in roughly an hour and your videos are helping me solidify a few things that I didn't quite understand, so, Thank you! I plan to edit this with my score that I get edit: I got a 960 out of 1000. Thank you!
You are the best professor! for the first exam, I got 400 and after I watched this I got a 900 score on test 2. If u guys keep failing watch this it is really helpful!! Thank you, professor Mike
Hello Mike. Today I took the Excel test and got an excellent score 1000/1000. I watched your videos about the Excel and they have been very helpful. Thank you you are a great teacher 🎉
Dear Mike, I just did the MO-200 Excel test one hour ago and got 925 out of 1000. I was watching your videos this morning and before as well. You have added a lot of points to my score with your excellent teaching, thank you so much!
Congratulations, Haiya! That’s such a great score. Thank you for this nice comment. I’m just happy this video could help you study! The Excel test is a tough one but you passed it easily!
Failed my first exam a month ago because I was confused on some of the wording. Been studying but still needed some better explanations found your video today and watched both about 2 hours before my exam. You explained everything so clearly and I went in confident and scored a 975/1000 and finished with 20 minutes to spare Thank you!
I defiantly think the most challenging part for me was understanding the concept of F4 with the absolute cell reference. I rewatched it multiple times to pick up on what was going on but I think this would be one of those things I would totally forgot how to do during the exam and not remember the steps. There's so many shortcuts for each task to try and remember and I find that paying attention to the wording of the question is what will determine how to answer the question. Hopefully I remember all the important shortcuts and solutions for the exam!! These videos are very encouraging and easy to follow which is a nice thing to have as a learning resource.
The second part was as informative and interesting as the first one. The most difficult task that I found was to remember the formulas as I usually forget which formula to use. Once I get to know the formula that is supposed to be applied for solving a particular question, then it gets way easier for me to complete the task. However, the videos that you post are really helpful and make things much easier because earlier, apart from remembering the formulas, I had problem with applying them as well but now things have changed! Thanks to you Professor :)
Predicate the help, had no clue about the intricacies of excel until today. Took my exam after watching a couple videos, skipped about 3 problems and passed with a 825! Thanks Mike!
First of all, Thank you so much for such a amazing and detailed video to prepare for the final excel MOs exam. According to me, I think the challenging task for me was the cell reference and F4 is a little hard to remember what exactly it is for. IF function can be challenging in task 3 sometimes it is hard to get the formula correct. I watched it many times again and again. Then, finally I am successfully done with it. But somehow you make excellent fun in this video even in all videos.
The most challenging excel task for me was creating the "custom ;)" column chart, I found it pretty easy after you did it but I never knew how to do that. I really enjoyed how you presented your video, it was serious but had the funny elements that every video should have. I wish I payed more attention in your class because I love your persona.
Thank you so much for your expertise in Excel. I'm almost positive that if it wasn't for your incredible knowledge and skill in Excel, most of us would be doomed. I found these video exercises more easy and simple compared to the last. For me, the most challenging part for me here would be remembering how to properly insert the formulas to ensure that I get the correct answers. The second challenge for me would be remembering to use the Absolute cell reference. I've made notes to ensure that this is something I don't leave out!
No way I didn’t know you work at Centennial College! That’s my school! I’m having my MOS exam today. Your MOS Word Exam Prep was the only thing that helped me pass the test with a 92%! Thank you so much. Edit: 95% on my MOS Excel.🎉
For me, the most challenging task in this video is multiplying a value. Your tip about using F4 to correct the cell reference was very helpful. Thank you!
Thank you so much for making learning so much easier with your videos. It's difficult for me to remember certain MS Excel formulas that I haven't used previously, such as the IF, CONCAT, COUNT, and UPPER formulas. With the help of this video, I was able to master it quickly and easily, particularly the use of F4. I watched it several times to prepare for my MOS Exam, and it was fantastic and entertaining!
I find learning the little shortcuts like F4 to make an absolute cel reference or tab to complete the start of a formula so helpful as I worry about inputting things exactly correctly.
Hello Prof. Mike, I am grateful for the videos you create. It helps me in my studying about Excel. Excel is very tricky because of the formulas needed to remember and put on, however your videos made it so easy and clear to understand.
The most difficult part in excel is that I forget the formulas while doing tasks.I was always indenting and aligning the column incorrectly, but thanks to the tutorials you provided, I practised more and more until I was able to do it correctly. I practice a lot with the help of your videos and it works. Now I am perfect in doing tasks and assignments. The F4 key in my laptop is not working but as per your videos, I used shortcut for that and it helps me. I watched this video and its really very interesting and helpful.I learned so many new things. Thank you professor for your videos and step by step instructions.
Thank you so much Mike for your part 1 and part 2 of the Microsoft Excel certification exam videos! I just finished taking my exam and got an 887/1000.
Thank you so much for your informative and detailed videos. I never would have thought that watching videos on Excel would be so good! The aspect that I found most challenging is having to remember the absolute cell reference and F4. That tip was very helpful, so thanks for that. It is going down on the notepad :-D
Hi Professor Mike, Thanks again for such an amazing detailed video to prep for the Final Exel Mos Exam. The most challenging task that I found was to remember when there is a question about alignment and having to delete cells, you must remember not to just simply grab or cut and paste the cells where it is asked. You MUST select the cell that you want to be removed then right-click, delete, then click shift cells up. This way everything will get moved and placed accordingly without any errors.
First of all, I would like to thank you for the informative video about functions to use in Excel. I found this video interesting. I only struggled with the absolute cell reference and the use of F4. I had to watch the video many a times to completely understand that and then I managed to do it. The tips given in the video are really helpful for me. I have also made notes of the instructions given by the professor. Thank you again!
Thank you professor Mike. I really appreciate the efforts you make for us throughout this course. Your videos are really helpful for me to understand about Microsoft excel. However, I have some difficulties in remembering various formulas. Actually, there are so many formulas to remember. But, now I am doing work on it. I also have one small notebook, where I write all the formulas. This thing really helping me to remember formulas. Your way of teaching help me to grasp concepts and formulas of excel. I am sure that in future I will definitely become expert in excel. Thank you for your efforts and your efforts make the journey of semester smooth and easy for me.
I think the toughest task was correct alignment and indent because there is always confusion about how to indent in a different direction such as left, right, centre. I am always doing wrong whenever I indent and aligned the column but due to the videos presented by you I practice more and more and now I am done right . Again I thank you for your hard work towards us and I learned new things while doing the Excel project.
Thank you so much professor for creating such helpful videos for us. The most challenging task which I found was using F4 key in multiplication and the IF function.
Hi Professor, When it comes to excel the thing I find more difficult is still figuring out what functions are required. With the way the wording is put down it gets confusing but once those are cleared up the rest comes easily. Also having the F4 tip makes multiplying much easier!
Well, I don't think I have any more problems with Excel, except in circumstances where the queries are bent far beyond my comprehension. Your videos and demonstrations were excellent and answered almost all of my questions. The questions are usually simple to decipher, but occasionally they are so twisted that I am unsure what I am expected to do in response to them. But there is no longer a difficulty once I know what the task is. I am now confident in my MOS excel exam; all I need is Certiport to pass it. Well, I've had an awful experience with Certiport! I'm hoping everything goes smoothly.
I think the absolute cell reference was the most tricky because it's quite new to me and I have a feeling I'd make the mistake of not remembering when or how to use it (hopefully I will remember the F4 tip). The IF function is also still a little challenging, especially when it comes to % or leaving the cell blank.
The most challenging was the absolute cell reference, but after watching the video a few times I know that I need to practice the F4 function. I really like watching the videos and I get a better understanding on how all the functions work.
The most challenging task was the IF function, i learned through the course and by the informative videos to follow the key word in the instruction "IF" LOL. Performing the formula can be tricky, the easier way to have the dialogue box to perform the task easier. The most difficult task in Excel is adding tax .... i hate math .... but the great thing about Excel it does the work for you if the proper functions are put in place. The example files have made it easier to practice and to overcome that challenge. Thanks!! Most appreciated
Thanks a lot professor for this informational video on Excel in such a simple way. I found it very difficult to create a custom chart. I did practice and now I have good command on it. Thanks once again.
The curveball in the second project - changing the alignment by deleting cells - is probably something that would have been difficult for me without your explanation! I am awful about not fully reading a question and discerning what it is actually asking. I definitely would have manually moved it up. Also, the question about removing a row and now changing content outside the table - did not understand that it meant not to click the whole line! Very glad I watched this!
OUTSIDE-IN was the most difficult task of the review. I reminded the video several times and then laughed. Oh, they want the label on the OUTSIDE END. Thank you fir for the information.
Well, I do not think I have any more difficulties in excel except for cases when the questions are twisted far more than what I can understand. Your videos and demos were really good and solved almost all of my queries. Usually, the questions are easy to interpret but at times they are so twisted that I cannot understand what I am supposed to do for the question. But once I know what exactly the task is, there is no more problem. I am positive about my MOS excel exam now, just Certiport works fine for it. Well, I have a bad history with Certiport! Hope it goes well.
Hi Prof, thanks again for this video. I think in this video the most complicated thing I will have to remember is how to delete a table row/column without the tool that we use within Microsoft Word. I will also remember how to select multiple ranges on a mac as that is my preferred choice of computer.
This was fun! Definitely made me hungry! So, as a continuation from the previous video, the most challenging things for me are making sure to input the correct formula to get the correct answer, as well as understanding what the question is asking me. GMetrix sometimes words their questions to trick us into doing something completely different than what they are asking of us. I'll be the first to admit, sometimes I fall for it. Good luck to my fellow classmates on the upcoming GMetirx exam!
Thanks a lot professor for this informational video on Excel in such a simple way. I found it very difficult to create a custom chart. Cell reference was also seems to be difficult for me, but now I have good command over it after watching your video. Once again, Thanks a lot.
Really Nice Video, very informative like all your other videos. I appreciate your dedication. I would like to practice the IF function which is like the hardest task for me as well but your demonstration has totally helped me. Thanks!
The hardest task from this video for me will most likely be absolute cell reference. What would have been the hardest would be deleting a row or column in a table because as you mentioned if you use Word frequently for tables it might mess you up. Thankfully I now know that there is a different method in Excel and that type of question shouldn't be a problem anymore. Thank you for the videos, they are very helpful!
Thank you so much for the video! I think the most challenging part in this video was displaying something lower than 10%, the input of inventory column that is displayed as "low".
I think the challenging part for me is doing the absolute number reference. Sometimes I forget that the data added on the formula in the cell needs to be absolute to have the exact output. It is tricky in a sense that sometimes there won't be an error and it makes me think that I done it right.
Thank you for making these videos they are very helpful, especially around exam time. What I found most difficult is once again the formulas. I am still struggling to remember which formula to use, after watching your videos I have more clarification and I will continue to refer back to my notes if needed.
His music is garbage to me too but your videos are GOLD! ;) Thank you so much for your help, just got my certificate! I struggle with charts in general. Wish you the best!
I think the most difficult task was using the IF function formula for the Inventory Warning Column. It is hard to remember if you need to add the % sign or some other detail to get the correct answer. Also the Bite and Chiu task that asked to move the alignment. You have to really pay attention to the wording of the questions. I am going to watch lot of your videos in order to get a better grasp of things.
For me, the challenging task was the second task from project one. It was little bit hard for me to understand that how to put the formula and I need to work hard on the formulas. Thank you very much for this video and your videos are always very helpful.
First of all Thank you so much Professor for this knowledgeable video as it is really helpful. Furthermore, I think using IF function is little bit confusing for me and remembering absolute cell reference is more challenging and use of F4. But after watching your this video for 2 to 3 times, it becomes easier for me to remember it and is going to help me in my upcoming exam. Really it is very helpful. Thankyou !
This video was very informative and all of the questions were briefly explained so there was not any part that was too difficult for me to understand yet there was the third part in this video 4th and 5th question where I had to see the video twice to understand it. Rest everything was very fine and both the videos were very thoroughly explained and helped me with my excel understanding.
The most challenging task for me in this video was absolute cell reference and using the shortcut F4. I'm working on Mac and not sure if this short cut works fine. Also I didn't get at what point exactly to use it, so I need to watch this video again!
I found this one much simpler, and thanks for sharing the practice files! Maybe that's why I struggled less. I struggled with the function that added tax to the cost. My F4 button wasn't working, but I remembered you saying in a previous video if F4 doesn't work, you can just name the cell that has the tax and that works too. so that's what I did!
Definitely for me was the F4 function. I had to go back after the video just to rewatch it to ensure I get the correct answer the exam! Toooo many functions soooo little time 😂😂
I do agree with a lot of the others about the F4 absolute cell reference confused me at first, I had to re-watch that part of the video numerous times to be able to wrap my head around it haha. I think I get it now, but I do need to practice now to get it drilled in my mind :) -- Lisa Patton (Martel is my married name - sorry for the confusion)
Hey professor I found second task in first project difficult but got it after watching several times. To be honest at first it was hard to understand what's going on in that question and after watching the video thrice I was able to learn how to use that function in excel. Thanks
The second task would be the one I get stuck on. One thing that always gets me, is when using a formula and refencing a cell it copies down but does not work. One of the things I found very useful and had forgotten until watching this was to use F4 to hold the cell reference when it continues down. I will have to write this down for the exam.
For me, I find multiplying a value is a little bit tricky and complicated. Although, after 2/3 times practicing, it seems like it recovers automatically. It looks like I have to practice more and more to recover that tricky one. A little time with so much works!! Huh 😕. Thank you, professor, for your excellent video.
After watching this video F4 is a little hard to remember what exactly it is for. IF function can be challenging in task 3 sometimes it is hard to get the formula correct. Alignment also poses a bit of confusion for me sometimes I have to do it twice to ensure it is the right thing to do. But the toughest task was 4&5 this is very challenging for me as creating charts for me is like math and I completely despise math but somehow you make excellent fun!!
In my opinion, the two most tricky parts of this video were project 2- task 1 and project 3- part 3. These tasks were not necessarily difficult but they were tricky. If we did not pay attention to the question then we can easily make mistakes in these questions like the professor talks about in the video. Furthermore, in general, I find it very difficult to find different functions and options in the ribbon. I think it is something that can be improved over time with practice.
According to me, the question that asks to enter a formula that multiplies the Unit Price to cell H2 is most difficult. In one of your videos where I need to name the cell and then multiply was easier as compared to this one because I am not sure when to press F4. I have got an idea though how to answer this question, but I will surely practice on Excel as I do not want to make a mistake in my Exam.
It’s a gift, really. Haha I’m trying to limit the mistakes as I get more practice but maybe it’s not so bad? Teaches my people what mistakes NOT to make
Trying to remember all the steps for the IF function/formula and trying not to mess it up is challenging have to re watch a couple times just to understand and do it correctly. And again reading and understanding what to do for each question being asked to do and making sure im doing it properly. - Catherine Cornish
I think everything is ok with excel as per your videos, but I am still finding difficulty to use several formulas . Because sometimes I honestly forget like which formula I have to choose on the time . Secondly The F4 button is not working on my phone, then I thought you said that you just simply named the cell. Well professor with your videos and the way you explained everything seemed to be so easy and relaxing. I hope I would score good in Mos exam. Thank you professor for always guiding us......
MIKE! I just took my excel certification... I AM CERTIFIED. There was in fact a CONCAT question and it required combining an email and a first name. All thanks to you I got it right. #certified #962
The Hardest function I find in this video is the -Concat. I find it hard to keep it straight, I really enjoy that the function puts it all together but I do find this one a bit tricky. I have a bad habit of putting a small space or inbetween a formula or a comma where it shouldn't be. I have to review my work so often this becomes time consuming.
For me, remembering a formula are the most difficult to remember, but in this video cell reference and using F4 is the part that I have struggling to do. I had to practice more and rewatch it to understand it more
Hi, thank you for your video! i love it! i have a question about like add date to the pie chart, if you have something that can help with that i would love thank you
Great Instructional Video Mike! Is this all we need to take the MO-200 Exam, or are you going to release a Part 3? I went through and learned a lot from Part 1 and Part 2. Am I ready for the test now, or is there anything else I should be studying?
To me, creating a chart with 3 columns of data is the hardest to remember because intuitively i dont want to include the column name so i never know if i should highlight it or not
Hey! Would you say your Microsoft Excel certification exam parts 1 & 2 are sufficient wholistic prep for the Associate's exam? Are there any other resources I should take a look at? Also, another question, how much extra time would it take to prepare for the Expert exam?
I think the most challenging part for me was the absolute cell reference and the use of F4. I had to watch it a couple times to understand, but makes sense now! These are really helpful tips!
For me, in the first project: Tim biebs, I found difficult to multiplies the value as it shows error, even I tried to correct it by using F4, still shows me a error. Then I watched again carefully and after trying for two times I got it correct.
Let me know which task was the most challenging/difficult Excel task in this video! Thanks!
My professor actually suggested we watch your videos before we take the MOS Exam. I will be taking it today in roughly an hour and your videos are helping me solidify a few things that I didn't quite understand, so, Thank you!
I plan to edit this with my score that I get
edit: I got a 960 out of 1000. Thank you!
You are the best professor! for the first exam, I got 400 and after I watched this I got a 900 score on test 2. If u guys keep failing watch this it is really helpful!! Thank you, professor Mike
Hello Mike. Today I took the Excel test and got an excellent score 1000/1000. I watched your videos about the Excel and they have been very helpful. Thank you you are a great teacher 🎉
How to test? Plz help
what did you do to study? did you just watch these videos? please let me know! i have my exam this monday, thank you!
@@lisazalewski5761 I watched these videos and practiced on the computer different tasks that he show on videos. Good luck 🍀
@@joudzah1308 it is easy if you study Excel lessons, watch videos, and practice. The test is like watching on the video. Good luck 🍀
Dear Mike, I just did the MO-200 Excel test one hour ago and got 925 out of 1000. I was watching your videos this morning and before as well. You have added a lot of points to my score with your excellent teaching, thank you so much!
Congratulations, Haiya! That’s such a great score. Thank you for this nice comment. I’m just happy this video could help you study! The Excel test is a tough one but you passed it easily!
Life saver I just passed my excel with a 875/1000 after watching just two of your videos
thank you sir, i passed my exam with 943 score, this video helpful
Watched your videos the day before the exam 3 times and got 943/1000 first try!
I just passed my Microsoft Excel Certification exam after binge-watching your videos. Thank you for the help!
Failed my first exam a month ago because I was confused on some of the wording. Been studying but still needed some better explanations found your video today and watched both about 2 hours before my exam. You explained everything so clearly and I went in confident and scored a 975/1000 and finished with 20 minutes to spare Thank you!
Hello Mike, I passed excel exam from your videos.
Thank you very much for your time and support very useful knowledge to everyone.
I defiantly think the most challenging part for me was understanding the concept of F4 with the absolute cell reference. I rewatched it multiple times to pick up on what was going on but I think this would be one of those things I would totally forgot how to do during the exam and not remember the steps. There's so many shortcuts for each task to try and remember and I find that paying attention to the wording of the question is what will determine how to answer the question. Hopefully I remember all the important shortcuts and solutions for the exam!! These videos are very encouraging and easy to follow which is a nice thing to have as a learning resource.
The second part was as informative and interesting as the first one. The most difficult task that I found was to remember the formulas as I usually forget which formula to use. Once I get to know the formula that is supposed to be applied for solving a particular question, then it gets way easier for me to complete the task. However, the videos that you post are really helpful and make things much easier because earlier, apart from remembering the formulas, I had problem with applying them as well but now things have changed! Thanks to you Professor :)
Predicate the help, had no clue about the intricacies of excel until today. Took my exam after watching a couple videos, skipped about 3 problems and passed with a 825! Thanks Mike!
I passed my MOS exam thanks to these videos. I scored 943/1000!
First of all, Thank you so much for such a amazing and detailed video to prepare for the final excel MOs exam. According to me, I think the challenging task for me was the cell reference and F4 is a little hard to remember what exactly it is for. IF function can be challenging in task 3 sometimes it is hard to get the formula correct. I watched it many times again and again. Then, finally I am successfully done with it. But somehow you make excellent fun in this video even in all videos.
The most challenging excel task for me was creating the "custom ;)" column chart, I found it pretty easy after you did it but I never knew how to do that. I really enjoyed how you presented your video, it was serious but had the funny elements that every video should have. I wish I payed more attention in your class because I love your persona.
Thank you so much for your expertise in Excel. I'm almost positive that if it wasn't for your incredible knowledge and skill in Excel, most of us would be doomed. I found these video exercises more easy and simple compared to the last. For me, the most challenging part for me here would be remembering how to properly insert the formulas to ensure that I get the correct answers. The second challenge for me would be remembering to use the Absolute cell reference. I've made notes to ensure that this is something I don't leave out!
You do a great job teaching! Keep it up!
The trickiest part for me was the task, the absolute cell reference, and the striking F4.
No way I didn’t know you work at Centennial College! That’s my school! I’m having my MOS exam today. Your MOS Word Exam Prep was the only thing that helped me pass the test with a 92%! Thank you so much.
Edit: 95% on my MOS Excel.🎉
For me, the most challenging task in this video is multiplying a value. Your tip about using F4 to correct the cell reference was very helpful. Thank you!
Thank you so much for making learning so much easier with your videos. It's difficult for me to remember certain MS Excel formulas that I haven't used previously, such as the IF, CONCAT, COUNT, and UPPER formulas. With the help of this video, I was able to master it quickly and easily, particularly the use of F4. I watched it several times to prepare for my MOS Exam, and it was fantastic and entertaining!
I find learning the little shortcuts like F4 to make an absolute cel reference or tab to complete the start of a formula so helpful as I worry about inputting things exactly correctly.
Hello Prof. Mike, I am grateful for the videos you create. It helps me in my studying about Excel. Excel is very tricky because of the formulas needed to remember and put on, however your videos made it so easy and clear to understand.
The most difficult part in excel is that I forget the formulas while doing tasks.I was always indenting and aligning the column incorrectly, but thanks to the tutorials you provided, I practised more and more until I was able to do it correctly. I practice a lot with the help of your videos and it works. Now I am perfect in doing tasks and assignments. The F4 key in my laptop is not working but as per your videos, I used shortcut for that and it helps me. I watched this video and its really very interesting and helpful.I learned so many new things. Thank you professor for your videos and step by step instructions.
Hi Mike, I've been following you around because your videos for MOS are very helpful. Thank you so much.
Thanks for your sharing.
I am very happy with your explanation. Excel looks so much easier
Thank you so much Mike for your part 1 and part 2 of the Microsoft Excel certification exam videos! I just finished taking my exam and got an 887/1000.
thanks man your videos were a great help i scored 962/1000 in the test
Thank you so much for your informative and detailed videos. I never would have thought that watching videos on Excel would be so good! The aspect that I found most challenging is having to remember the absolute cell reference and F4. That tip was very helpful, so thanks for that. It is going down on the notepad :-D
Hi Professor Mike,
Thanks again for such an amazing detailed video to prep for the Final Exel Mos Exam. The most challenging task that I found was to remember when there is a question about alignment and having to delete cells, you must remember not to just simply grab or cut and paste the cells where it is asked. You MUST select the cell that you want to be removed then right-click, delete, then click shift cells up. This way everything will get moved and placed accordingly without any errors.
First of all, I would like to thank you for the informative video about functions to use in Excel. I found this video interesting. I only struggled with the absolute cell reference and the use of F4. I had to watch the video many a times to completely understand that and then I managed to do it. The tips given in the video are really helpful for me. I have also made notes of the instructions given by the professor. Thank you again!
Thank you professor Mike. I really appreciate the efforts you make for us throughout this course. Your videos are really helpful for me to understand about Microsoft excel. However, I have some difficulties in remembering various formulas. Actually, there are so many formulas to remember. But, now I am doing work on it. I also have one small notebook, where I write all the formulas. This thing really helping me to remember formulas. Your way of teaching help me to grasp concepts and formulas of excel. I am sure that in future I will definitely become expert in excel. Thank you for your efforts and your efforts make the journey of semester smooth and easy for me.
I think the toughest task was correct alignment and indent because there is always confusion about how to indent in a different direction such as left, right, centre. I am always doing wrong whenever I indent and aligned the column but due to the videos presented by you I practice more and more and now I am done right . Again I thank you for your hard work towards us and I learned new things while doing the Excel project.
Thank you so much professor for creating such helpful videos for us. The most challenging task which I found was using F4 key in multiplication and the IF function.
Hi Professor,
When it comes to excel the thing I find more difficult is still figuring out what functions are required. With the way the wording is put down it gets confusing but once those are cleared up the rest comes easily. Also having the F4 tip makes multiplying much easier!
Well, I don't think I have any more problems with Excel, except in circumstances where the queries are bent far beyond my comprehension. Your videos and demonstrations were excellent and answered almost all of my questions. The questions are usually simple to decipher, but occasionally they are so twisted that I am unsure what I am expected to do in response to them. But there is no longer a difficulty once I know what the task is. I am now confident in my MOS excel exam; all I need is Certiport to pass it. Well, I've had an awful experience with Certiport! I'm hoping everything goes smoothly.
Hi Mike! watching your videos and doing the practice test helped me passed on my 2nd try with a 850/1000
I think the absolute cell reference was the most tricky because it's quite new to me and I have a feeling I'd make the mistake of not remembering when or how to use it (hopefully I will remember the F4 tip). The IF function is also still a little challenging, especially when it comes to % or leaving the cell blank.
The most challenging was the absolute cell reference, but after watching the video a few times I know that I need to practice the F4 function. I really like watching the videos and I get a better understanding on how all the functions work.
The most challenging task was the IF function, i learned through the course and by the informative videos to follow the key word in the instruction "IF" LOL. Performing the formula can be tricky, the easier way to have the dialogue box to perform the task easier. The most difficult task in Excel is adding tax .... i hate math .... but the great thing about Excel it does the work for you if the proper functions are put in place. The example files have made it easier to practice and to overcome that challenge.
Thanks!! Most appreciated
Thanks a lot professor for this informational video on Excel in such a simple way. I found it very difficult to create a custom chart. I did practice and now I have good command on it. Thanks once again.
Awesome Video
watched these the day before my test and passed tysm
The curveball in the second project - changing the alignment by deleting cells - is probably something that would have been difficult for me without your explanation! I am awful about not fully reading a question and discerning what it is actually asking. I definitely would have manually moved it up. Also, the question about removing a row and now changing content outside the table - did not understand that it meant not to click the whole line! Very glad I watched this!
OUTSIDE-IN was the most difficult task of the review. I reminded the video several times and then laughed. Oh, they want the label on the OUTSIDE END. Thank you fir for the information.
Well, I do not think I have any more difficulties in excel except for cases when the questions are twisted far more than what I can understand. Your videos and demos were really good and solved almost all of my queries. Usually, the questions are easy to interpret but at times they are so twisted that I cannot understand what I am supposed to do for the question. But once I know what exactly the task is, there is no more problem. I am positive about my MOS excel exam now, just Certiport works fine for it. Well, I have a bad history with Certiport! Hope it goes well.
Hi Prof, thanks again for this video. I think in this video the most complicated thing I will have to remember is how to delete a table row/column without the tool that we use within Microsoft Word. I will also remember how to select multiple ranges on a mac as that is my preferred choice of computer.
This was fun! Definitely made me hungry! So, as a continuation from the previous video, the most challenging things for me are making sure to input the correct formula to get the correct answer, as well as understanding what the question is asking me. GMetrix sometimes words their questions to trick us into doing something completely different than what they are asking of us. I'll be the first to admit, sometimes I fall for it. Good luck to my fellow classmates on the upcoming GMetirx exam!
Hi, I just wanna say thank you so much. After watching your videos I got 923/1000 for my Microsoft Excel Exam 😊
Thank you for your help. your video helped me a lot..
Thanks a lot professor for this informational video on Excel in such a simple way. I found it very difficult to create a custom chart. Cell reference was also seems to be difficult for me, but now I have good command over it after watching your video. Once again, Thanks a lot.
Really Nice Video, very informative like all your other videos. I appreciate your dedication. I would like to practice the IF function which is like the hardest task for me as well but your demonstration has totally helped me. Thanks!
I would have to agree with what many others have said-that absolute cell reference/F4 would likely be my trickiest part of this video.
Thank you so much for sharing this video as it's going to help a lot in the MOS exam. The most difficult part is cell reference and the use of F4.
The hardest task from this video for me will most likely be absolute cell reference. What would have been the hardest would be deleting a row or column in a table because as you mentioned if you use Word frequently for tables it might mess you up. Thankfully I now know that there is a different method in Excel and that type of question shouldn't be a problem anymore. Thank you for the videos, they are very helpful!
Thank you so much for the video! I think the most challenging part in this video was displaying something lower than 10%, the input of inventory column that is displayed as "low".
I think the challenging part for me is doing the absolute number reference. Sometimes I forget that the data added on the formula in the cell needs to be absolute to have the exact output. It is tricky in a sense that sometimes there won't be an error and it makes me think that I done it right.
Thank you for making these videos they are very helpful, especially around exam time. What I found most difficult is once again the formulas. I am still struggling to remember which formula to use, after watching your videos I have more clarification and I will continue to refer back to my notes if needed.
Thank you so much for sharing ❤
His music is garbage to me too but your videos are GOLD! ;) Thank you so much for your help, just got my certificate! I struggle with charts in general. Wish you the best!
I Stan this channel, 943 isn't a perfect score but I'm very happy with it. Mike is goated in my books.
I think the most difficult task was using the IF function formula for the Inventory Warning Column. It is hard to remember if you need to add the % sign or some other detail to get the correct answer. Also the Bite and Chiu task that asked to move the alignment. You have to really pay attention to the wording of the questions. I am going to watch lot of your videos in order to get a better grasp of things.
For me, the challenging task was the second task from project one. It was little bit hard for me to understand that how to put the formula and I need to work hard on the formulas. Thank you very much for this video and your videos are always very helpful.
First of all Thank you so much Professor for this knowledgeable video as it is really helpful. Furthermore, I think using IF function is little bit confusing for me and remembering absolute cell reference is more challenging and use of F4. But after watching your this video for 2 to 3 times, it becomes easier for me to remember it and is going to help me in my upcoming exam. Really it is very helpful. Thankyou !
This video was very informative and all of the questions were briefly explained so there was not any part that was too difficult for me to understand yet there was the third part in this video 4th and 5th question where I had to see the video twice to understand it. Rest everything was very fine and both the videos were very thoroughly explained and helped me with my excel understanding.
The most challenging task for me in this video was absolute cell reference and using the shortcut F4. I'm working on Mac and not sure if this short cut works fine. Also I didn't get at what point exactly to use it, so I need to watch this video again!
I found this one much simpler, and thanks for sharing the practice files! Maybe that's why I struggled less. I struggled with the function that added tax to the cost. My F4 button wasn't working, but I remembered you saying in a previous video if F4 doesn't work, you can just name the cell that has the tax and that works too. so that's what I did!
my F4 button just asks me to save the project. Can you explain how you resolved it
Definitely for me was the F4 function. I had to go back after the video just to rewatch it to ensure I get the correct answer the exam! Toooo many functions soooo little time 😂😂
I do agree with a lot of the others about the F4 absolute cell reference confused me at first, I had to re-watch that part of the video numerous times to be able to wrap my head around it haha. I think I get it now, but I do need to practice now to get it drilled in my mind :) -- Lisa Patton (Martel is my married name - sorry for the confusion)
i liked and commented because u da man
Hey professor
I found second task in first project difficult but got it after watching several times. To be honest at first it was hard to understand what's going on in that question and after watching the video thrice I was able to learn how to use that function in excel. Thanks
The second task would be the one I get stuck on. One thing that always gets me, is when using a formula and refencing a cell it copies down but does not work. One of the things I found very useful and had forgotten until watching this was to use F4 to hold the cell reference when it continues down. I will have to write this down for the exam.
For me, I find multiplying a value is a little bit tricky and complicated. Although, after 2/3 times practicing, it seems like it recovers automatically. It looks like I have to practice more and more to recover that tricky one. A little time with so much works!! Huh 😕. Thank you, professor, for your excellent video.
After watching this video F4 is a little hard to remember what exactly it is for. IF function can be challenging in task 3 sometimes it is hard to get the formula correct. Alignment also poses a bit of confusion for me sometimes I have to do it twice to ensure it is the right thing to do. But the toughest task was 4&5 this is very challenging for me as creating charts for me is like math and I completely despise math but somehow you make excellent fun!!
In my opinion, the two most tricky parts of this video were project 2- task 1 and project 3- part 3. These tasks were not necessarily difficult but they were tricky. If we did not pay attention to the question then we can easily make mistakes in these questions like the professor talks about in the video.
Furthermore, in general, I find it very difficult to find different functions and options in the ribbon. I think it is something that can be improved over time with practice.
According to me, the question that asks to enter a formula that multiplies the Unit Price to cell H2 is most difficult. In one of your videos where I need to name the cell and then multiply was easier as compared to this one because I am not sure when to press F4. I have got an idea though how to answer this question, but I will surely practice on Excel as I do not want to make a mistake in my Exam.
Thank you, I like how you unintentionally made simple mistakes for which I suppose would-be doing, then how you correct the error.
It’s a gift, really. Haha I’m trying to limit the mistakes as I get more practice but maybe it’s not so bad? Teaches my people what mistakes NOT to make
Trying to remember all the steps for the IF function/formula and trying not to mess it up is challenging have to re watch a couple times just to understand and do it correctly. And again reading and understanding what to do for each question being asked to do and making sure im doing it properly. - Catherine Cornish
I think everything is ok with excel as per your videos, but I am still finding difficulty to use several formulas . Because sometimes I honestly forget like which formula I have to choose on the time . Secondly The F4 button is not working on my phone, then I thought you said that you just simply named the cell. Well professor with your videos and the way you explained everything seemed to be so easy and relaxing. I hope I would score good in Mos exam. Thank you professor for always guiding us......
The most challenging task is the IF function for me. I still get confused on what data to put into the formula.
Thanks so much for this video Mike. The hardest part of excel for me is CONCAT. #loveurhat
MIKE! I just took my excel certification... I AM CERTIFIED. There was in fact a CONCAT question and it required combining an email and a first name. All thanks to you I got it right. #certified #962
I just purchased your course on Udemy and really looking forward to going through it this week.
That’s great! I hope it helps!
The Hardest function I find in this video is the -Concat.
I find it hard to keep it straight, I really enjoy that the function puts it all together but I do find this one a bit tricky. I have a bad habit of putting a small space or inbetween a formula or a comma where it shouldn't be. I have to review my work so often this becomes time consuming.
For me, remembering a formula are the most difficult to remember, but in this video cell reference and using F4 is the part that I have struggling to do. I had to practice more and rewatch it to understand it more
Hi, thank you for your video! i love it! i have a question about like add date to the pie chart, if you have something that can help with that i would love thank you
Thank You so Much for such a wonderful video
Anytime Hira! Do you have an exam coming up?
@@MikesOffice I have Passed my exam with 925 Marks
Great Instructional Video Mike! Is this all we need to take the MO-200 Exam, or are you going to release a Part 3? I went through and learned a lot from Part 1 and Part 2. Am I ready for the test now, or is there anything else I should be studying?
This should be good! I also have earlier versions like the 2016 ones that could help.
To me, creating a chart with 3 columns of data is the hardest to remember because intuitively i dont want to include the column name so i never know if i should highlight it or not
Hey! Would you say your Microsoft Excel certification exam parts 1 & 2 are sufficient wholistic prep for the Associate's exam? Are there any other resources I should take a look at? Also, another question, how much extra time would it take to prepare for the Expert exam?
The most challenging was deleting the cells to move the data up. I had that on my exam. I think I did it correctly:) But it was challenging!!
Which videos to pass the Specialist certification exam? I want to focus on one exam then broaden my knowledge.
Will creating data tables ever be asked of me on the exam?
I think the most challenging part for me was the absolute cell reference and the use of F4. I had to watch it a couple times to understand, but makes sense now! These are really helpful tips!
For me, in the first project: Tim biebs, I found difficult to multiplies the value as it shows error, even I tried to correct it by using F4, still shows me a error. Then I watched again carefully and after trying for two times I got it correct.
In my opinion in Bite and Chin Chocolate number 3 is the most challenging to me
Why you didn’t use sum formula instad of pressing f4 in tax
How do you get the practice sheets?
It would be awesome if you could provide practice files so we could follow along in an actual document.
I post them all on my Patreon page.
The first project, the second task, with the taxes... eeek... I am so confused... I have some practicing to do!