The biggest problem I have with Excel is remembering the correct functions for which equations, and how to type them in correctly. I completely blank with anything that has to do with math, and then the panic sets it. I am an English student and can write essays in my sleep, but math/functions/equations? no thanks. Thanks for this video Prof, your calmness makes me believe that I actually am learning and not to overthink the questions. (:
That’s a great point! You totally just made me realize a trick you can use if your mind goes blank because of test anxiety and functions like mine does….I’ll show this in the next one, but you can type in a description of the function in Excel and look up what function to use. It’s not cheating just smart!
Just passed my Excel 2019/365 exam about 1 hour ago with a score of 925/1000. Your video helped me greatly. God bless and thanks for sharing your knowledge and guidance.
I've started studying for the Excel exams. I've had Office 365 (including Excel 365) for over a year, but the online training is apparently done on Excel 2019. The ribbon layout and other details are quite different. How should I deal with this disconnect?
I have failed twice in the past, and am required to pass for my Junior year classes! I been watching your excel videos for two months, and have memorized your tips and tricks! I took it last week and scored a 965, one of the highest scores of the Summer! Thank you so much for your help, and easy access to prepping for the exam. You are such an encouragement to students!
I just finished taking my certification exam and passed with a 981/1000! I had taken the exam about a week before, failed, and ran out of time. Just from watching your videos, I was able to not only pass but make almost a perfect score! With time to spare! Thank you, Mike! Definitely look into these videos if you need help!
Connot thank you enough, last week I failed both excel(669) and word(597), and retook them yesterday and pass them both by just watching your videos (word:900, excel:887), thank you Mike!
You are brilliant man. Just passed the exam and get 91. Whatever we study in our class is nothing compare to exam. I fail first time and then watch your two video and get pass toady. I have to say I learn more about excel by watching your two video then doing the class last two months. Thank you.
Thank you Professor Mike!! Just passed my MOS Excel Exam today with a score of 900/1000 after failing the first time with a score of 626/1000. Thanks for sharing your knowledge and skills the MOS was exactly like the material you covered in Videos 1 & 2.
I PASSED WITH A PERFECT SCORE 1000 THANKS TO YOUR VIDEOS!!! As a college student, the part one, part two, and the 7 formulas video were more helpful than my professors entire course! Thank you so much!!
The most challenging task for me was task 4 in the Check Your Worksheet chapter. It's actually not the task that's challenging but more of how the instruction is worded; "swap the data over the axis" doesn't sound anywhere near "switch row/column" and so I had a hard time trying to figure out what the task was asking me to do. But this video helped to clarify how tasks would possibly be worded on the exam, which I appreciate because the task might be written in a way that is difficult to understand but is actually just asking for a simple action.
Hey I just passed my Excel certification thanks to you with a score of 800 and I wanted to thank you! I was doing this stupid experienced software thing for my school and it didn’t teach me much but once I watched your videos it was like everything made sense!
The most difficult part for me in excel is using ' IF ' formula . I always confused about the exact formula in excel. Sometimes I always forget to put (=) sign between them. Then I start practicing about excel and the way you explained everything is awesome. Like in task 3 question 4, modify the formula to display the letter in upper case is so interesting, I always loved this one , whenever I make datasheets or etc. Through your videos its been so easy to use excel and the person who don't know anything about excel I would suggest to follow your instructions only. By using formulas , its been so easy to calculate several type of data.
Im taking my test tomorrow and my excel teacher told us that we should all watch this video to prepare us for the exam! She even linked them on her page
I am having my Certiport Exam, next Monday and freaking out right now. I'm watching lots of your videos and they help. I just need to remember them when doing the exam. Thanks for all you do!
Thank you so much Mike! I passed my Excel certification with 925 yesterday thanks to your videos that I used to prepare myself. I watch the entire série of the excel exam: Part 1 and 2. I would also recommend the 7 functions in excel video. Again, thank you, your videos are useful and helpful ☺️
One of the biggest problem for me is to remember all the formulas. Actually, I love biology and mathematics for me is hardest thing to do. For becoming master in excel, I need to be good in mathematical functions. However, your videos are very beneficial for me to in understanding the concepts and formulas of excel. For understanding and memorizing all the formulas I need to practice daily and I am doing practice regularly to use excel easily and functionally. According to me, who want to know about excel, he or she can watch your videos. Your tips and tricks are really blessings for me because they can assist me in MOS exam.
Almost the end of 2023 and I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part two. Thank you! Now on to the Expert!
One of my biggest problems with Excel has to be remembering all the functions. There are so many, and I get confused with what one to use. When doing the MOS exam, I already get so anxious and I overthink everything. This was a wonderful video to remind me of what to use and why. I like how you phrase the questions in the language that could potentially be used in the exam. From past experience, they do word things differently and I find this very helpful.
After studying for less than 2 days only by watching 2 of your videos and taking some notes I decided to take the exam to see where I was at, and to my surprise I passed with a score of 725/1000. Thank you so much for making this video and helping me pass my Excel cert exam.
I definitely find remembering the correct functions to use in the correct settings the most difficult, but watching these videos is great, because you make it seem so straightforward and accessible! It definitely gives me more confidence and peace of mind having these step by step videos!
Hi Prof Mike, This was a great way to refresh myself with all the equations and possible tasks that we may get on the Exel Exam. I think the most difficult task for me would be having to remember which formula goes with what. I believe that memorizing the formula is the hardest part because you must pay attention to the task details and what they are asking for. For example, in the task with the average bestseller, reading the task carefully was important so that the correct formula is used. What I had done as I was watching the video was taking notes of all the formulas and tasks that I need help with so that those are the tasks I focus on prior to the Excel exam. Thanks for such an amazing and detailed explanation video. It was very helpful.
Amazing work!! Doesn’t it feel great to be certified?? I’m glad this video could help. That’s the best feeling as an educator so thank you so much for sharing your success with us! Do you think you will take the Excel expert exam?
Thank you!! I brought the course and watched the two last videos and did the practice attachments/walk thoughts and I passed with an 850!! I took the test two days before and 486. (certiport)
Hello Mike! I would like to thank you. Because of you I passed all my MOS Exams with a great score. Today I passed my Excel Exam with a great score of 850 points. Outlook: 737 Points Word: 850 Points PowerPoint: 940 Points Excel: 850 Points
A huge thanks to you Mike. Now I've got a 925 score on my Microsoft Office Specialist Excel exam. Your guide is very effective and most of the questions in the exam are covered in your videos. Thank you so much!
Passed my Excel 2019 Certiport exam with a 868/1000 and I thank you for your videos! Everything you went over was what was needed to pass. I had difficulty with the server, my instructor had to reboot the program a few times but even with all that going on I was able to get a good score! Thank you thank you thank you!!
I just passed my MOS Excel exam with an 850 score. That's pretty good for me because Excel is my weakest program in the MS Office Suite. Your videos helped me tremendously in my studies prior to taking the exam. Thank you for putting these together!
The most difficult thing for me in excel is to remember shortcuts and formulas. It always become difficult for me to remember formulas while doing assignments or tasks. I have to watch videos again and again to solve the tasks. And through your video it has become so easy to use the excel and I will suggest to those who want to know about excel, they can watch this video as it is really helpful.
Thank you so much Mike. I prepared for the exam using your videos only and got 943/1000 in the very first attempt. Please keep sharing such amazing and using videos. Thank you.
These were amazing!!! I was so nervous going into my excel certification test but you explained everything so well and all of the problems were so similar. I would’ve been nowhere without your videos, thank you so much!!!😁
Took the exam today 01.07.2024. and passed it (940/1000). One minor mistake because a question was not that clear. (To me) Want to say that your videos still up to date regarding the content and your tips! Anyone who’s looking forward to passing the exam, should have a look at your videos 😉
Hey Mike! I just want to thank you for your channel. I was able to pass my Word and Excel certification exam that’s required for my job. Thank you and god bless!
The biggest struggle I have is remembering formulas especially when there is more than one step. In this video, the second task is what I felt was most difficult. I overthink it when it comes to using formulas and seeing the instructions to use the range instead of just selecting the cell had me confused at first. Like always, once I try it out or watch your demonstration it becomes clearer!
I think the most difficult part for me is to remember the formulas in excel. During assignments sometimes, I forget the exact formula but when I watched your videos its easy for me to do tasks. Your way of teaching helps me a lot. Your tips of formulas makes test easy for me. Sometime, I am confused between the formulas but your instructions made it easy. In some tasks I forget = sign while started writing formula in the formula bar but now keep doing practicing helps me to remember all formulas. Thanks to you for videos tis made easy everything.
You save my life sir I pass the exam today 831/1000 🎉if I can’t pass this exam today I can’t be graduated tmr thank you so much for your exam video part 1 and 2
All of it's tough to me man. Just started learning Excel, spent 5 hours on 46 minutes of a video tutorial the other day, loved your video as well provided a nice sneak peak at what I still have left to learn. Thanks for the content
I just took and exam and passed only because of you 🙏🙏🙏🙏your video helped me a lot, it I wouldn't watch this video I would definitely fail... Thanks again 😊
I think the most difficult task for me is to remember the formulas. As every time I start using Excel, I get confused with the formulas especially CONCAT and IF functions. But Thanks to you Mike. Your videos help me a lot in doing the Excel tasks. I am getting accurate day by day in formulas.
The problems i struggle with Excel is the functions and the different use for them. I'm personally not great a math, but im super happy how easy excel makes it easier to give accurate calculations. Understanding standing the different functions can be difficult , but when practiced is super cool and easy. The video was super formative and great examples. Also paying attention to the keywords really help in order to put in the proper functions which really helps. This video is way better than Gmetrix . Thanks!
I watched these videos but still failed my excel exam today, I'm very slow, I skipped a few questions and didn't have time to do project 6, so I bought your excel exam practice guide so I really hope it helps!! I'll be starting tomorrow 🙏
This video is really helpful, especially since I'm going to take my certification this week. The struggle is remembering some formulas but overall, the tutorial is very informative.
Our MOS Exam is just around the corner. I really have a hard time with formulas, and these video tutorials really helped me to further understand Excel functions. Thank you Prof Mike!
I agree with Danielle-Tori, remembering the formulas is the most difficult, but I know there is a search function that helps you decide what formula to use, which is super helpful in a pinch!
This was a great video confirming what I have learned in an Excel class in college and preparing for my MOS Associate Exam in Excel. Professor's kind of made me doubt myself a bit, but thank you for confirming and giving a whole lot of insight into what to expect on the Associate Exam. Getting ready to take the expert in two weeks too and like several have mentioned, functions can be tricky and confusing.
I found difficult to use formulas and remembering them, but throughout this course I learned really well and your videos really helped me for preparing my MOS excel certification exams. Your tips are very helpful and time saving. Through your videos excel became easy to use, thank you for posting videos.
The most tricky part for me is about inserting formula. Sometimes I forget the correct command if it is sum, average, etc. Much more on the more advance part which includes the If, upper, etc. I do have hard time in inserting the correct cell if prompted to do so. One more thing, I am most of the time confused on inserting formula within existing formula. Sometimes I forget to put the open and close brackets and that always mess up the results. But honestly, your videos are really helpful in preparing us for the MOS exam. I do hope to pass it Prof.
I wish I would have watched this before my exam. I had the CONCAT function with the e-mails and I was like..???. I am taking it again tomorrow and glad I found this!!!
The most difficult part for me was the entering formulas. If function is confusing, especially what information to insert in fields to get the correct formula at the end. Also I found challenging for me putting the brackets inside the formula. In your video there were tasks where you used formula without brackets and with brackets. Thank you for your detailed explanations!
The toughest task was project 3 that is the mad world publishing project. In this project, the IF function is very difficult to remember and use in the correct way but the videos presented by you are very helpful to use the functions and clear each and every function for me. It really gives more confidence and strength to have these step-by-step videos. All projects videos presented by you are very easy and helpful. Practice tasks every day on excel worksheets give us more opportunity to learn new things. Thanks for this video professor and I am very glad to have a professor like you.
The most difficult part for me is using the 'IF' function. I find there are a lot of steps to remember as well as knowing when to use it. Thank you for posting these videos. I find them extremely helpful as I prepare for my Excel certification.
Hey!!! I took my Excel Associates exam and got a 831/1000!!! I kid you not!!! The Sports task was the exact same one as on my exam. What was hard for me was the IF function on the exam because I forgot to put the " " around the words like: "Books Sold" > 10,000. I was so nervous and also the proctor kinda shook me up before the test so I feel like it might've made me more nervous. Causing me to forget.
The most challenging part for me is using the formula "IF" because, suddenly it does not come in to mind that how we apply this formula. Every formula in Excel is a challenge for me. I am not so quick in applying the formulas but Your videos are always helpful. Second thing which I have done first time is the Screen tip feature in using hyperlink so, thank you so much for the practice video.
I definitely think the hardest thing about Excel is staying up to date with the formulas! I would have never known that you can just add UPPER and it would make everything uppercase. I feel a little nervous going into the exam not being clear on the functions but now that I've heard there is a cheat sheet ;p it'll definitely come in handy! haha.
The hardest part for me is to remember the full name of functions and how to write them. For example, about the task where we have to count the number of columns with no information. I remembered that it's something blank, but it's hard to remember the exact name. But I fully understand the meaning of most of functions and I'm really happy with it. Thank you, professor!
The most challenging part for me, is the proper functions. There are so many formulas and functions to remember, but with all your videos it really gives me a lot of tips on how to use Excel function and all other task . Thanks!
The biggest problem I have with Excel is that keeping in touch with formulas. Remembering the formula is really tough and keeping track of all the functions of excel. This video is really helpful to keep track and to pass the MOS exam.
The biggest difficulty I have with excel is the functions and dont know what some of them are used for and how to exactly use some of them correctly. Also trying to follow the instructions can be a little difficult at times i have to re-read them or read them very carefully. By watching your video it makes things a little easier to follow and understand. - Catherine Cornish
Like many other students have commented, the hardest part is remembering the formulas. The formula I get most confused with are the 'if' and 'sumif' formulas. Excel is the primary program I use at work and the sumif and if formulas still get me!
Hello Mike, Thank you for sharing the video. It provided valuable insights and proved to be quite beneficial. I recently passed the exam and would highly recommend it to others.
The hardest thing for me was to apply functions and i must mention that i am slow learner. I learnt everything quickly because of your videos. A s i am more comfortable with learning through videos as compared to reading material.
The most challenging part for me was remembering the functions and formulas in Excel since I don't usually use them. But with the help of this video, I have something to look through or review incase I have difficulties in utilizing the Excel. I'm one of the fortunate students of Professor Mike who's been taught on how to use MS and discover things that I haven't known before. Thanks Professor :)
I struggle most with the CONCAT formula. I find most functions are straightforward because the name of the function coordinates with what it does. But, I have never heard the word concat in my life, and I am constantly forgetting what it does! I also tend to forget how to use two functions simultaneously, like you did when making something uppercase and also using the left 3 function. but practice makes perfect! Thank you for the comp[rehensive video!
I found this video informative and interesting. The only thing which makes me feel anxious is remembering formulas and putting them at right place. I always struggle while doing this thing as I am not good at memorizing things. But, the tips and tricks given my you are really great and helpful. Thanks!
The most difficult task for me was choosing or remembering which function to use based on the task or question asked. I find it takes me longer to recognize what is actually needed, however your videos and tips are extremely helpful.
A couple of things that are challenging with Excel is remembering the correct functions for which equations, or what formula to use based on the question can sometimes be confusing. Normally when it comes to exams with numbers, equations, and formulas I tend to blank out or get so nervous I can remember anything, especially if I'm being timed. I can follow the screen tip in the videos when entering the formulas, but tables can always post a challenge for me, as one mistake and it's like you have fallen off a cliff. For myself writing down or printing out how to do a task helps me to better remember or practice for it to actually stick in my head. Hopeful in the MOS exam I will be able to remember everything from the videos to help me pass or even get a good grade. Very educating in this video how you educate the steps with each detail.
Hi Professor! Learning the fundamentals of MS Excel was quite challenging indeed. I always struggle with the conditional formatting, memorizing all the formulae, and making charts because they can all be tricky and susceptible to errors. I can't thank you enough Professor for every tutorial video you uploaded and making our learning fun and easier!
I would say the problem I often face when using excel is remembering the formulas used to calculate. I often forget to use brackets and I will try to submit the formula and it will not work because of this. I have now written down all of the formulas and this helps me as a reference when doing my work.
The only problem which I think, I would face are the formulas, especially the 'if' formulas. Maths and functions are sometimes very frustrating, professor's video will help me alot to score the good marks as he has explained eveything very well.
I will be taking the test this week and I am hoping to pass. Will update you. Thank you for this video it helped me a lot. The best thing you taught was the dinosaur image that you added. The hardest task is on the last one with the bookstores task but I will study this video again. Thank you.
Thank you Mike, your Excel practice video is really useful. Today I was able to complete my Excel exam with a very satisfactory score. Once again thank you so muchhh!!!!
I think the most challenging part for me is remembering all the functions and formulas as well as conditional formatting. Nevertheless, with the help of this video, I know I can pass my certification exam. It is really more conducive and fun to learn with Prof Mike's videos because they are presented step-by-step and are very detailed. Skills in excel will help me in meeting the different accounting needs of my future career. MS Excel will surely help me get my stuff done with ease and in a more organized manner.
Task 5 in the last project which says "On the Bookstores worksheet, perform a multi-level sort. Sort the table by "Bookstores" (A to Z) then by "Total Q1 Revenue" (Largest to Smallest)
I think that the most difficult task for myself displayed in this exam practice will be remembering the formula and what each function is used for. I am no excel expert but I have become more confident in my skills throughout this course.
This was a staggering strategy for restoring myself with the circumstances in general and potential endeavors that we may get on the Excel Exam. I figure the most irksome part for me would be the need to review which equation goes with what. I acknowledge that holding the equations is the hardest part since you should zero in on the part that what has been asked in the inquiry. In the event that is most troublesome capacity for me as its requirements practice. Disregarding the way that I have started to work and practice the recipes regular, and simultaneously there are a couple of them that I need to manage. With the assistance of these sort of recordings, I am certain that I will actually want to dominate every one of the troublesome recipes too
When it comes to creating tables, spreadsheets, and accurate data analysis, working with Excel is a prerequisite. However, the most interesting and difficult part is remembering the functions, as I am always confused, but after watching this video, I understand how to do the function formula correctly. There are also other parts that are difficult for me, such as conditional formulas and function arguments, as I am sometimes confused about when and how to use Sumif, Averageif, Countif, and Sumif formulas, but after watching this video, I understand fully. Thank you for uploading this video and I will do more practice in order to acquire good marks in the exam.
Only problem I face when using excel is putting correct formulas and values. Of ten when I enter the formulas and values in the cell it displays error message. I have to make several tries to get it right. But once it is correct it is all perfect. The IF and Alphabet formatting functions like CONCAT, UPPER etc. were particularly new to me but I am slowly learning to use them. So excel is once again fun for me.
This was an incredible method for reviving myself with all of the situations and potential undertakings that we might get on the Excel Exam. I figure the most troublesome part for me would be the need to recall which formula goes with what. I accept that retaining the formulas is the hardest part since you should focus on the part that what has been asked in the question. IF is most difficult function for me as its needs practice. In spite of the fact that I have begun to work and practice the formulas everyday, yet at the same time there are a few of them that I want to deal with. With the help of these kind of videos, I am sure that I will be able to master all the difficult formulas as well.
The videos overall are so Helpful! I like how you make mistakes and are able to correct them - just as like we would. I alwasy struggle with trying to figure out what the heck excel is actually asking me to do, there are so many formuals and options out there that you have to really read to eliminate alot of the jargon - to figure out clearly what your task is. My only advice is sometimes your excel maybe formatted to something ours isn't. like the fx function, your automatically goes to the "if true" option, mine I have to set up and I struggle with figuring out what it is to get there. The other thing, is when we use a formula and you go to start typing it in, and it comes up, what do we press to use that function instead of writting it all out still. ANYWAY AWESOME semester and thank you! I am WAY less afarid of excel then when I began!
Thank you for this wonderful video brother. I just passed the exam. You are brilliant man. Its very easy to understand because you explained it very well. Kudos brother, cheers!
Aside from the functions, I think I will have a hard time with the language or words being used by Microsoft. Some times I have a different understanding of the instructions that makes my mistakes. I like how Prof Mike, in his videos, try to explain what would each project mean and what are the output of it.
The biggest problem I have with Excel is remembering the correct functions for which equations, and how to type them in correctly. I completely blank with anything that has to do with math, and then the panic sets it. I am an English student and can write essays in my sleep, but math/functions/equations? no thanks. Thanks for this video Prof, your calmness makes me believe that I actually am learning and not to overthink the questions. (:
That’s a great point! You totally just made me realize a trick you can use if your mind goes blank because of test anxiety and functions like mine does….I’ll show this in the next one, but you can type in a description of the function in Excel and look up what function to use. It’s not cheating just smart!
Me too
Just passed my Excel 2019/365 exam about 1 hour ago with a score of 925/1000. Your video helped me greatly. God bless and thanks for sharing your knowledge and guidance.
I've started studying for the Excel exams. I've had Office 365 (including Excel 365) for over a year, but the online training is apparently done on Excel 2019. The ribbon layout and other details are quite different. How should I deal with this disconnect?
How to apply for the exam ? where to apply ? Do you have link/website ?
HI @carlosivan34 , could you pls guide me for the exam
I have failed twice in the past, and am required to pass for my Junior year classes! I been watching your excel videos for two months, and have memorized your tips and tricks! I took it last week and scored a 965, one of the highest scores of the Summer! Thank you so much for your help, and easy access to prepping for the exam. You are such an encouragement to students!
I just finished taking my certification exam and passed with a 981/1000! I had taken the exam about a week before, failed, and ran out of time. Just from watching your videos, I was able to not only pass but make almost a perfect score! With time to spare! Thank you, Mike! Definitely look into these videos if you need help!
How many projects are there?
Connot thank you enough, last week I failed both excel(669) and word(597), and retook them yesterday and pass them both by just watching your videos (word:900, excel:887), thank you Mike!
You are brilliant man. Just passed the exam and get 91. Whatever we study in our class is nothing compare to exam. I fail first time and then watch your two video and get pass toady. I have to say I learn more about excel by watching your two video then doing the class last two months. Thank you.
Thank you Professor Mike!! Just passed my MOS Excel Exam today with a score of 900/1000 after failing the first time with a score of 626/1000. Thanks for sharing your knowledge and skills the MOS was exactly like the material you covered in Videos 1 & 2.
I PASSED WITH A PERFECT SCORE 1000 THANKS TO YOUR VIDEOS!!! As a college student, the part one, part two, and the 7 formulas video were more helpful than my professors entire course! Thank you so much!!
The most challenging task for me was task 4 in the Check Your Worksheet chapter. It's actually not the task that's challenging but more of how the instruction is worded; "swap the data over the axis" doesn't sound anywhere near "switch row/column" and so I had a hard time trying to figure out what the task was asking me to do. But this video helped to clarify how tasks would possibly be worded on the exam, which I appreciate because the task might be written in a way that is difficult to understand but is actually just asking for a simple action.
Hey I just passed my Excel certification thanks to you with a score of 800 and I wanted to thank you! I was doing this stupid experienced software thing for my school and it didn’t teach me much but once I watched your videos it was like everything made sense!
The most difficult part for me in excel is using ' IF ' formula . I always confused about the exact formula in excel. Sometimes I always forget to put (=) sign between them. Then I start practicing about excel and the way you explained everything is awesome. Like in task 3 question 4, modify the formula to display the letter in upper case is so interesting, I always loved this one , whenever I make datasheets or etc. Through your videos its been so easy to use excel and the person who don't know anything about excel I would suggest to follow your instructions only. By using formulas , its been so easy to calculate several type of data.
Im taking my test tomorrow and my excel teacher told us that we should all watch this video to prepare us for the exam! She even linked them on her page
Mike! You're a homie. I just passed with a perfect score of 1000/1000! Your videos helped me remember how to do everything! Thank you so much!
Just got 981/1000 on my exam. Exam was just like the skills taught in your videos. Thanks for the help!
I totally blank out when it comes to the functions. I would have to watch this over and over. Thank you ! you are a calm teacher, much appreciated.
I am having my Certiport Exam, next Monday and freaking out right now. I'm watching lots of your videos and they help. I just need to remember them when doing the exam. Thanks for all you do!
Thank you so much Mike! I passed my Excel certification with 925 yesterday thanks to your videos that I used to prepare myself. I watch the entire série of the excel exam: Part 1 and 2. I would also recommend the 7 functions in excel video. Again, thank you, your videos are useful and helpful ☺️
One of the biggest problem for me is to remember all the formulas. Actually, I love biology and mathematics for me is hardest thing to do. For becoming master in excel, I need to be good in mathematical functions. However, your videos are very beneficial for me to in understanding the concepts and formulas of excel. For understanding and memorizing all the formulas I need to practice daily and I am doing practice regularly to use excel easily and functionally. According to me, who want to know about excel, he or she can watch your videos. Your tips and tricks are really blessings for me because they can assist me in MOS exam.
Almost the end of 2023 and I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part two. Thank you! Now on to the Expert!
One of my biggest problems with Excel has to be remembering all the functions. There are so many, and I get confused with what one to use. When doing the MOS exam, I already get so anxious and I overthink everything. This was a wonderful video to remind me of what to use and why. I like how you phrase the questions in the language that could potentially be used in the exam. From past experience, they do word things differently and I find this very helpful.
After studying for less than 2 days only by watching 2 of your videos and taking some notes I decided to take the exam to see where I was at, and to my surprise I passed with a score of 725/1000. Thank you so much for making this video and helping me pass my Excel cert exam.
wow congrats! but did u had any previous experience
@@noideawhatsthis thank you! And honestly no I hadn’t had any previous experience other than some practice tests found on Gmetrix.
I definitely find remembering the correct functions to use in the correct settings the most difficult, but watching these videos is great, because you make it seem so straightforward and accessible! It definitely gives me more confidence and peace of mind having these step by step videos!
Hi Prof Mike,
This was a great way to refresh myself with all the equations and possible tasks that we may get on the Exel Exam. I think the most difficult task for me would be having to remember which formula goes with what. I believe that memorizing the formula is the hardest part because you must pay attention to the task details and what they are asking for. For example, in the task with the average bestseller, reading the task carefully was important so that the correct formula is used. What I had done as I was watching the video was taking notes of all the formulas and tasks that I need help with so that those are the tasks I focus on prior to the Excel exam. Thanks for such an amazing and detailed explanation video. It was very helpful.
I passed my exam!!! This vid really made a difference and gave me those points I needed to achieve this certificate. Thanks a lot!
Amazing work!! Doesn’t it feel great to be certified?? I’m glad this video could help. That’s the best feeling as an educator so thank you so much for sharing your success with us! Do you think you will take the Excel expert exam?
Thank you!! I brought the course and watched the two last videos and did the practice attachments/walk thoughts and I passed with an 850!! I took the test two days before and 486. (certiport)
Hello Mike!
I would like to thank you. Because of you I passed all my MOS Exams with a great score. Today I passed my Excel Exam with a great score of 850 points.
Outlook: 737 Points
Word: 850 Points
PowerPoint: 940 Points
Excel: 850 Points
A huge thanks to you Mike. Now I've got a 925 score on my Microsoft Office Specialist Excel exam. Your guide is very effective and most of the questions in the exam are covered in your videos. Thank you so much!
Passed my Excel 2019 Certiport exam with a 868/1000 and I thank you for your videos! Everything you went over was what was needed to pass. I had difficulty with the server, my instructor had to reboot the program a few times but even with all that going on I was able to get a good score! Thank you thank you thank you!!
I just passed my MOS Excel exam with an 850 score. That's pretty good for me because Excel is my weakest program in the MS Office Suite. Your videos helped me tremendously in my studies prior to taking the exam. Thank you for putting these together!
Because of you I passed with a 925/1000, you are amazing
For me the toughest part was to remove hidden properties and personal information from the workbook..
But the way of your teaching is awesome 👍
The most difficult thing for me in excel is to remember shortcuts and formulas. It always become difficult for me to remember formulas while doing assignments or tasks. I have to watch videos again and again to solve the tasks. And through your video it has become so easy to use the excel and I will suggest to those who want to know about excel, they can watch this video as it is really helpful.
Thank you so much Mike. I prepared for the exam using your videos only and got 943/1000 in the very first attempt. Please keep sharing such amazing and using videos. Thank you.
These were amazing!!! I was so nervous going into my excel certification test but you explained everything so well and all of the problems were so similar. I would’ve been nowhere without your videos, thank you so much!!!😁
Thanks, Mike for your help!
I got 831 on my excel exam!
I got the exact score too!!! I passed today.
Thanks Mike .. today i have cleared Ms 200 exam with 925 score, thanks for alll your videos which have helped me clear the exam....
Took the exam today 01.07.2024. and passed it (940/1000). One minor mistake because a question was not that clear. (To me)
Want to say that your videos still up to date regarding the content and your tips!
Anyone who’s looking forward to passing the exam, should have a look at your videos 😉
Hey Mike! I just want to thank you for your channel. I was able to pass my Word and Excel certification exam that’s required for my job. Thank you and god bless!
The biggest struggle I have is remembering formulas especially when there is more than one step. In this video, the second task is what I felt was most difficult. I overthink it when it comes to using formulas and seeing the instructions to use the range instead of just selecting the cell had me confused at first. Like always, once I try it out or watch your demonstration it becomes clearer!
I think the most difficult part for me is to remember the formulas in excel. During assignments sometimes, I forget the exact formula but when I watched your videos its easy for me to do tasks. Your way of teaching helps me a lot. Your tips of formulas makes test easy for me. Sometime, I am confused between the formulas but your instructions made it easy. In some tasks I forget = sign while started writing formula in the formula bar but now keep doing practicing helps me to remember all formulas. Thanks to you for videos tis made easy everything.
You save my life sir I pass the exam today 831/1000 🎉if I can’t pass this exam today I can’t be graduated tmr thank you so much for your exam video part 1 and 2
Passed by MS Excel 2019 Beginner Exam today on the first try! Thanks so much for your videos, they helped me prepare for success!
All of it's tough to me man. Just started learning Excel, spent 5 hours on 46 minutes of a video tutorial the other day, loved your video as well provided a nice sneak peak at what I still have left to learn. Thanks for the content
I just took and exam and passed only because of you 🙏🙏🙏🙏your video helped me a lot, it I wouldn't watch this video I would definitely fail... Thanks again 😊
Hello Mike, I passed excel exam from your videos.
Thank you very much for your time and support very useful knowledge to everyone.
I think the most difficult task for me is to remember the formulas. As every time I start using Excel, I get confused with the formulas especially CONCAT and IF functions. But Thanks to you Mike. Your videos help me a lot in doing the Excel tasks. I am getting accurate day by day in formulas.
Thank you Mike. I passed all my Certiport Exams with your videos. I really appreciated.
The problems i struggle with Excel is the functions and the different use for them. I'm personally not great a math, but im super happy how easy excel makes it easier to give accurate calculations. Understanding standing the different functions can be difficult , but when practiced is super cool and easy. The video was super formative and great examples. Also paying attention to the keywords really help in order to put in the proper functions which really helps. This video is way better than Gmetrix . Thanks!
I watched these videos but still failed my excel exam today, I'm very slow, I skipped a few questions and didn't have time to do project 6, so I bought your excel exam practice guide so I really hope it helps!! I'll be starting tomorrow 🙏
Thank you! Passed my exam today with a 975/1000 with the help from your videos!!!
This video is really helpful, especially since I'm going to take my certification this week.
The struggle is remembering some formulas but overall, the tutorial is very informative.
Our MOS Exam is just around the corner. I really have a hard time with formulas, and these video tutorials really helped me to further understand Excel functions. Thank you Prof Mike!
I agree with Danielle-Tori, remembering the formulas is the most difficult, but I know there is a search function that helps you decide what formula to use, which is super helpful in a pinch!
Did my MOS Excel yesterday and got 950/1000 because of this video and Part 2 video!🎉
Just passed the test with a 962/1000. These videos really helped. Thank you
This was a great video confirming what I have learned in an Excel class in college and preparing for my MOS Associate Exam in Excel. Professor's kind of made me doubt myself a bit, but thank you for confirming and giving a whole lot of insight into what to expect on the Associate Exam. Getting ready to take the expert in two weeks too and like several have mentioned, functions can be tricky and confusing.
I found difficult to use formulas and remembering them, but throughout this course I learned really well and your videos really helped me for preparing my MOS excel certification exams. Your tips are very helpful and time saving. Through your videos excel became easy to use, thank you for posting videos.
The most tricky part for me is about inserting formula. Sometimes I forget the correct command if it is sum, average, etc. Much more on the more advance part which includes the If, upper, etc. I do have hard time in inserting the correct cell if prompted to do so. One more thing, I am most of the time confused on inserting formula within existing formula. Sometimes I forget to put the open and close brackets and that always mess up the results. But honestly, your videos are really helpful in preparing us for the MOS exam. I do hope to pass it Prof.
I wish I would have watched this before my exam. I had the CONCAT function with the e-mails and I was like..???. I am taking it again tomorrow and glad I found this!!!
The most difficult part for me was the entering formulas. If function is confusing, especially what information to insert in fields to get the correct formula at the end. Also I found challenging for me putting the brackets inside the formula. In your video there were tasks where you used formula without brackets and with brackets. Thank you for your detailed explanations!
THANK YOU SO MUCH!! I PASSED THE TEST THE SECOND TIME BY WATCHING YOUR VIDEO. I LOVE YOU!!!!!
The toughest task was project 3 that is the mad world publishing project. In this project, the IF function is very difficult to remember and use in the correct way but the videos presented by you are very helpful to use the functions and clear each and every function for me. It really gives more confidence and strength to have these step-by-step videos. All projects videos presented by you are very easy and helpful. Practice tasks every day on excel worksheets give us more opportunity to learn new things. Thanks for this video professor and I am very glad to have a professor like you.
The most difficult part for me is using the 'IF' function. I find there are a lot of steps to remember as well as knowing when to use it. Thank you for posting these videos. I find them extremely helpful as I prepare for my Excel certification.
Hey!!! I took my Excel Associates exam and got a 831/1000!!! I kid you not!!! The Sports task was the exact same one as on my exam. What was hard for me was the IF function on the exam because I forgot to put the " " around the words like: "Books Sold" > 10,000.
I was so nervous and also the proctor kinda shook me up before the test so I feel like it might've made me more nervous. Causing me to forget.
The most challenging part for me is using the formula "IF" because, suddenly it does not come in to mind that how we apply this formula. Every formula in Excel is a challenge for me. I am not so quick in applying the formulas but Your videos are always helpful. Second thing which I have done first time is the Screen tip feature in using hyperlink so, thank you so much for the practice video.
I definitely think the hardest thing about Excel is staying up to date with the formulas! I would have never known that you can just add UPPER and it would make everything uppercase. I feel a little nervous going into the exam not being clear on the functions but now that I've heard there is a cheat sheet ;p it'll definitely come in handy! haha.
The hardest part for me is to remember the full name of functions and how to write them. For example, about the task where we have to count the number of columns with no information. I remembered that it's something blank, but it's hard to remember the exact name. But I fully understand the meaning of most of functions and I'm really happy with it. Thank you, professor!
The most challenging part for me, is the proper functions. There are so many formulas and functions to remember, but with all your videos it really gives me a lot of tips on how to use Excel function and all other task . Thanks!
The biggest problem I have with Excel is that keeping in touch with formulas. Remembering the formula is really tough and keeping track of all the functions of excel. This video is really helpful to keep track and to pass the MOS exam.
Hi! 2024 here! This video is still accurate! I passed with an 831. Thank you for posting!
The biggest difficulty I have with excel is the functions and dont know what some of them are used for and how to exactly use some of them correctly. Also trying to follow the instructions can be a little difficult at times i have to re-read them or read them very carefully. By watching your video it makes things a little easier to follow and understand. - Catherine Cornish
Like many other students have commented, the hardest part is remembering the formulas. The formula I get most confused with are the 'if' and 'sumif' formulas. Excel is the primary program I use at work and the sumif and if formulas still get me!
Hello Mike,
Thank you for sharing the video. It provided valuable insights and proved to be quite beneficial. I recently passed the exam and would highly recommend it to others.
The hardest thing for me was to apply functions and i must mention that i am slow learner. I learnt everything quickly because of your videos. A s i am more comfortable with learning through videos as compared to reading material.
The most challenging part for me was remembering the functions and formulas in Excel since I don't usually use them. But with the help of this video, I have something to look through or review incase I have difficulties in utilizing the Excel. I'm one of the fortunate students of Professor Mike who's been taught on how to use MS and discover things that I haven't known before. Thanks Professor :)
I struggle most with the CONCAT formula. I find most functions are straightforward because the name of the function coordinates with what it does. But, I have never heard the word concat in my life, and I am constantly forgetting what it does!
I also tend to forget how to use two functions simultaneously, like you did when making something uppercase and also using the left 3 function. but practice makes perfect!
Thank you for the comp[rehensive video!
I found this video informative and interesting. The only thing which makes me feel anxious is remembering formulas and putting them at right place. I always struggle while doing this thing as I am not good at memorizing things. But, the tips and tricks given my you are really great and helpful. Thanks!
The most difficult task for me was choosing or remembering which function to use based on the task or question asked. I find it takes me longer to recognize what is actually needed, however your videos and tips are extremely helpful.
A couple of things that are challenging with Excel is remembering the correct functions for which equations, or what formula to use based on the question can sometimes be confusing. Normally when it comes to exams with numbers, equations, and formulas I tend to blank out or get so nervous I can remember anything, especially if I'm being timed. I can follow the screen tip in the videos when entering the formulas, but tables can always post a challenge for me, as one mistake and it's like you have fallen off a cliff. For myself writing down or printing out how to do a task helps me to better remember or practice for it to actually stick in my head. Hopeful in the MOS exam I will be able to remember everything from the videos to help me pass or even get a good grade. Very educating in this video how you educate the steps with each detail.
Hi Professor!
Learning the fundamentals of MS Excel was quite challenging indeed. I always struggle with the conditional formatting, memorizing all the formulae, and making charts because they can all be tricky and susceptible to errors. I can't thank you enough Professor for every tutorial video you uploaded and making our learning fun and easier!
I would say the problem I often face when using excel is remembering the formulas used to calculate. I often forget to use brackets and I will try to submit the formula and it will not work because of this. I have now written down all of the formulas and this helps me as a reference when doing my work.
The only problem which I think, I would face are the formulas, especially the 'if' formulas. Maths and functions are sometimes very frustrating, professor's video will help me alot to score the good marks as he has explained eveything very well.
I will be taking the test this week and I am hoping to pass. Will update you. Thank you for this video it helped me a lot. The best thing you taught was the dinosaur image that you added. The hardest task is on the last one with the bookstores task but I will study this video again. Thank you.
Thank you Mike, your Excel practice video is really useful. Today I was able to complete my Excel exam with a very satisfactory score. Once again thank you so muchhh!!!!
I passed my excel exam!!! Thanks a lot for your videos.
I think the most challenging part for me is remembering all the functions and formulas as well as conditional formatting. Nevertheless, with the help of this video, I know I can pass my certification exam. It is really more conducive and fun to learn with Prof Mike's videos because they are presented step-by-step and are very detailed. Skills in excel will help me in meeting the different accounting needs of my future career. MS Excel will surely help me get my stuff done with ease and in a more organized manner.
Task 5 in the last project which says "On the Bookstores worksheet, perform a multi-level sort. Sort the table by "Bookstores" (A to Z) then by "Total Q1 Revenue" (Largest to Smallest)
I think that the most difficult task for myself displayed in this exam practice will be remembering the formula and what each function is used for. I am no excel expert but I have become more confident in my skills throughout this course.
This was a staggering strategy for restoring myself with the circumstances in general and potential endeavors that we may get on the Excel Exam. I figure the most irksome part for me would be the need to review which equation goes with what. I acknowledge that holding the equations is the hardest part since you should zero in on the part that what has been asked in the inquiry.
In the event that is most troublesome capacity for me as its requirements practice. Disregarding the way that I have started to work and practice the recipes regular, and simultaneously there are a couple of them that I need to manage. With the assistance of these sort of recordings, I am certain that I will actually want to dominate every one of the troublesome recipes too
When it comes to creating tables, spreadsheets, and accurate data analysis, working with Excel is a prerequisite. However, the most interesting and difficult part is remembering the functions, as I am always confused, but after watching this video, I understand how to do the function formula correctly. There are also other parts that are difficult for me, such as conditional formulas and function arguments, as I am sometimes confused about when and how to use Sumif, Averageif, Countif, and Sumif formulas, but after watching this video, I understand fully.
Thank you for uploading this video and I will do more practice in order to acquire good marks in the exam.
Only problem I face when using excel is putting correct formulas and values. Of ten when I enter the formulas and values in the cell it displays error message. I have to make several tries to get it right. But once it is correct it is all perfect. The IF and Alphabet formatting functions like CONCAT, UPPER etc. were particularly new to me but I am slowly learning to use them. So excel is once again fun for me.
This was an incredible method for reviving myself with all of the situations and potential undertakings that we might get on the Excel Exam. I figure the most troublesome part for me would be the need to recall which formula goes with what. I accept that retaining the formulas is the hardest part since you should focus on the part that what has been asked in the question.
IF is most difficult function for me as its needs practice. In spite of the fact that I have begun to work and practice the formulas everyday, yet at the same time there are a few of them that I want to deal with. With the help of these kind of videos, I am sure that I will be able to master all the difficult formulas as well.
The videos overall are so Helpful! I like how you make mistakes and are able to correct them - just as like we would. I alwasy struggle with trying to figure out what the heck excel is actually asking me to do, there are so many formuals and options out there that you have to really read to eliminate alot of the jargon - to figure out clearly what your task is. My only advice is sometimes your excel maybe formatted to something ours isn't. like the fx function, your automatically goes to the "if true" option, mine I have to set up and I struggle with figuring out what it is to get there. The other thing, is when we use a formula and you go to start typing it in, and it comes up, what do we press to use that function instead of writting it all out still. ANYWAY AWESOME semester and thank you! I am WAY less afarid of excel then when I began!
the running t-rex got me off guard
Thank you for this wonderful video brother. I just passed the exam. You are brilliant man. Its very easy to understand because you explained it very well. Kudos brother, cheers!
Thank you very much, got a 632 the first time I took the test. I'm going to take it again tomorrow and hoping to pass it with at least a 800.
Good luck!!
Thanks so much for all your videos! I passed my excel exam today 962/1000 :D
Hey we're the questions same?
How many projects you have to do?
@@TheWanderingMind4 most of the questions were very similar
This video helped me get a 925/1000! Thank you for the incredibly accurate video! This video did the most for me when preparing to take the exam!
Aside from the functions, I think I will have a hard time with the language or words being used by Microsoft. Some times I have a different understanding of the instructions that makes my mistakes. I like how Prof Mike, in his videos, try to explain what would each project mean and what are the output of it.
Just passed my exam like 5 mins ago making a 943/1000 im beyond grateful for this video and this video still helps years later ✨🥲