Thank you for posting these test questions and tips. I had just one evening to prepare for the intermediate word and excel tests; i've been watching your youtubetips for 5 hours straight and passed both tests on "skills" after being out of school for over 15 years. Спасибо, прекрасный темп речи, произношение и воодушевляющие комментарии.
Great to hear that! 😊 Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for these. Can I ask if the same commands and shortcuts are applicable to Mac PC/laptops and yes I do have Microsoft 365? I'm about to have the exam and it's been over a year since I was last employed and hence lacking in confidence though I have been using excel for over 20 years for just regular tables - no pivots. graphs, or complicated comparatives.
You're so welcome Lili! Very sorry just seeing your comment -somehow UA-cam was hiding it from me. How is your Excel learning going and thank you again for watching & leaving a comment as well. Have you been able to find the job ? Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you very much for taking time to leave a feedback and ask a questions. Using Excel Macros can speed up work and save you a lot of time. If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. Excel Macro Examples: Unhide All Worksheets at One Go. Hide All Worksheets Except the Active Sheet. Sort Worksheets Alphabetically Using VBA. Protect All Worksheets At One Go. Unprotect All Worksheets At One Go. Unhide All Rows and Columns. Unmerge All Merged Cells. Save Workbook With TimeStamp in Its Name. Good luck in your learning journey!
Why did only use the range B2:11 when solving the Jason SUMIF question? Why didn't you add B12 in the range when you included C12 in the range to get the answer?
Most likely just an error on my side - I'm not perfect :) Just trying to do too many things on my own and all by myself How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I'm very sorry it happened to you Jennifer! The best way to contact is email via the website. Do you have a different last name on your paypal account? I'm looking for the exact match as your UA-cam user name but there's nothing there. However, I do see two identical transactions. Please let me know and we'll refund it. Thanks!
Thank you for watching, Zach, and leaving a comment with your honest feedback as well. I stopped doing this in my new videos since I do read the comments and take them seriously. Please check out my newer videos ua-cam.com/users/OnlineTrainingforEveryone You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Recently I completed an intermediate excel test sent by the employer. The test was 30+ questions, set up by SkillCheck and it was a software simulation test (the worst kind, imo). To my surprise, about two thirds of the test was pretty simple and straight forward. It was comprised of copying and pasting cells, formatting and saving worksheets. The more difficult questions were about creating a formula to multiply different cells, creating slicers and a couple more formula questions. Hope this helps anyone taking these tests during the interview process.
@@mohddilshad5025 I don't think there was any monitoring of the assessment that I took with the exception of how many questions i answered correctly or incorrectly, of course. I don't think it was monitored for time or anything like that.
I used to have a co-worker who changed my excel work (yearly end closing) and sabotaged me. She refused me to do password protection. I ended up losing my job because of her. Its important to do password protection if your excel work is shared to other people...
I'm very sorry this has happened to you Josephine! Thank you very much for sharing your experience with everyone! You're absolutely correct about password protecting your work. Hope everything will work out for you. Please keep us updated on your journey. Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for other extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
ive been using excel for years and I could say im really proficient with it. But seeing your videos about excel really opened new prespectives on how dynamic this software really is and your videos taught me things that I havent even thought of using before. Keep up the with the videos mate :) Really really really appreciate it
Thank you very much for watching Vashvon and for leaving such a positive comment! It's greatly appreciated when my humble expertise is recognized. Means a world to me and inspires me to work harder so I can help my dear viewers! Please check out my other Excel videos - and let me know what you think about those tutorials. Thanks again for watching and please don't ever stop learning - keeps you employed and allows you to advance your carrier. Good luck in your journey! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I understand! Very sorry about it ! Please check my newer videos - I stopped doing it so hopefully, you'd give my tutorials another chance. Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it was helpful! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for this great video. I did not know the how to use "Concatenating" and "Text to Colum". I tried both these formulae and it worked in my file! Thanks again. I had an excel test 2 years ago in which they asked the formats in the longer way such as Select the cell and then click "copy" and then click on the new cell and then click "paste" etc..... But I always use the right-click of the mouse and all components I get very quickly and I move on. Even though you are very smart in your work, when you give a test, it becomes tough because you do not remember, where can you find the proper icon, because you have no option to use the right-click during the test. That test taught me that, when you go for a test, you better learn the longer route method!
Thanks for the tutorial , I have an assessment to take and my excel knowledge is limited. I no some of the basics. I still am not sure I am ready for the assessment; however, I think your video will help.
You are welcome Dolphine! Glad you liked it and I'm sure you'd do great! Try to prepare as much as you can - it always helps to pass. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I'm grinding for a job interview I have tomorrow and thought I would just shoot a comment out to say hello. I'm subbing strictly on the no-nonsense description of your content, which aims to help people like me find the job they want. Thanks for helping us all out and wish me luck tomorrow!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them - I stopped doing the interraptions ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you very much for watching and for pointing it out Sabina!!! I'll need to look into this. Please make sure to watch my other video tutorials - lots of great information there and I add new ones regularly. Good luck in your journey! ua-cam.com/users/OnlineTrainingforEveryonevideos
Very sorry for confusing you!!! I do everything myself so errors do happen - hope you understand. I'm not perfect just trying to be but as you can see not very successful :) How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You're very welcome! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment with your opinion! I greatly appreciate that! Please check out my newest video - no interruptions there and let me know what you think - really hope you'd give it a try ua-cam.com/video/Op0Kdemme_w/v-deo.html Please look at the rest of my videos as well - lots of great and helpful information in each and every one of them. ua-cam.com/users/OnlineTrainingforEveryone You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey! Keep on learning please! Knowledge helps you to advance your carrier and your life to the new heights!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad to help! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Most likely a typo Clare - I'm just a human. Very sorry for confusing you! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Yes I am and feel blessed living in such a great city! Go Brewers, Bucks, and Packers :) Thank you very much for watching Diva! Please make sure to watch my other video tutorials on this topic and my other helpful video tutorials - lots of great information there. The more prepared you're the easier it is to find the right position or do whatever you're already doing more efficiently. ua-cam.com/users/OnlineTrainingforEveryonesearch?query=aptitude You can also check out my website for any additional information you might find helpful. Good luck in your journey and please don't ever stop learning - knowledge keeps you employed and helps you to advance your carrier to the new heights! www.howtoanalyzedata.net/resources/
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
This video is 10 minutes of very valuable information and 36 minutes of crap. Please try to cut ot all the 'please subscribe', 'how to learn' and 'do me a favour' drivel. Keep the content concentrated and the subscribers would come, without all the begging.
Thank you for the honest comment Sophia! I listened and in my newer videos no crap :) How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for this helpful video. This was a great refresher for me. I purchased your Microsoft course bundle through your website, and I look forward to learning more.
You're very welcome Stacey and thank you for watching, the purchase and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Can you do me a favor and Stop Advertising? Your constant advertising made this video 45 mins when it was probably only half that time. Make all the statements at the end of the video and say it once instead of several times throughout the video. Thank you.
Sorry about that J'adore- you watched my older videos - one of the very first ones I made. Would you please give it another try and watch my newer videos - I don't do it anymore as much - I do listen to my viewers :) Please let me know how it goes. Very sorry again for frustrating you - good luck in your journey! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Thank you again for watching and leaving a comment as well. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it was helpful! Thank you for watching and leaving a comment as well! Please keep in mind that you can change the speed of the video. Also check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Appreciate your work in putting out these videos. But there is tooooooo many interruptions on top ot the adds someone has to look at. :.( Sorry, it takes up too much time.
I'm very sorry for the interaptions! Please watch my other videos - I stopped doing it as I do listen to the feedback my viewers provide. Thank you very much for giving it another chance!
Just wanted to let you know that I listened and my newer videos don't have interruptions, so I hope you'd give me another chance. How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching Matt and leaving an honest comment as well. I'll look into this video. Please check out my other videos on Excel ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching Jo and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great and valid point! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for your feedback! Unfortunately I can’t update the old videos but definitely will use different approach in the new videos. Hopefully you will reconsider about subscribing 😀! All the best on your job interview and assessment test!
Glad you liked it! Thank you for watching and leaving a kind comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Very sorry it's too fast for you Margaret, however please keep in mind that the speed of UA-cam videos can be modified by using the video settings in the bottom right corner of each video. There are multiple options for you to choose from. Hope it helps but please feel free to reach out with any of your suggestions - I greatly appreciate the feedback my viewers provide. Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Sorry just seeing your comment. You probably have an older version of Excel. You need to update it and then all the features I discuss in my tutorials will be available for you as well. Hope it makes sense. How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for watching and very sorry for the bald dude popups! Please check out other Excel videos - perhaps you'll find them helpful in your situation and there shouldn't be the bald dude popups. Good luck! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it - almost no dude there till the very end so no creeping out! ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Whoever wrote this comment, respect the person helping us out to pass interview. He is teaching us for free. He was very kind to you in his response. May God Bless him!
If the cell is already formatted as percent and you enter "0.5", it will be 0.5%. If you enter 0.5 and then format the cell to percent, then it would be 50%. I think the answer to your question is wrong.
Thank you for watching and leaving a comment as well, Erica I'll look into this. Please check out my other videos on Excel - I appreciate your constructive criticism ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You got this! Thank you for watching and leaving your comment as well. Please check out my other videos on Excel ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for other extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
on the substitute function you put SUBSTITUTE(A1,%," ")..... are we supposed to literally type ALL of that exactly in that form? and then I assume hit "enter"? or just click onto your next column? I've never used excel really and I have a test for probations this weekend which im quite positive will have these types of assessments and I'm praying to God it doesn't.. or praying I pass if it does.. helllllp. so confused on that SUBSTITUTE(A1,%," ")
Very sorry about that! Thank you for watching and leaving a comment as well! I stopped doing it in my new videos. Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you again for watching and leaving a comment as well. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You are absolutely wonderful! :) Thankfully, I clicked "pause" and tried each task for each question that you asked and, luckily, I already knew most of these. That said, I must admit... I have thoroughly enjoyed watching this video! I love your teaching method & the way you go about explaining things! I have no doubt this video has helped a lot of people out. One thing that I'm most concerned with is that I know nothing about the test that I am getting ready to take (which is what lead me to your video) so even though I have been working in Excel for many years and am usually the "go-to" person at work anytime anyone has Excel questions and I've built many super awesome spreadsheets for folks that are actually still being used to this day, I still get so nervous before taking assessment tests, so I'm a bit worried that there will be trick questions or perhaps multiple methods of gathering the same info or arriving at the same answer, that I'm scared I'll get a question wrong that I actually would have gotten correct if I was working on an real Excel spreadsheet! lol Nevertheless, I do feel much more comfortable about testing my skills now that I've worked alongside you, while watching your video! And I'm super excited that I got nearly all of your questions correct. :) Thank you so much for your assistance! I'm definitely going to subscribe to your channel & follow you for more Excel tips & tricks!! 100% =D Thanks again & have a wonderful week!! 🤓🙏
Glad to hear that! You're very welcome! Thank you for watching and leaving a comment as well! Please check out my new video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Another fantastic video. I love your excel for employment video too. This is the best tutorial for intermediate excel!! It’s empowering, and I really appreciate it. 🙏
I have a series of number, but i want to add prefix number to the series of number, so how do i Auto the prefix. For example 975544 i want to add 080 to the front of the different series of numbers. What formula do i use?????
Thank you very much for your kindness AM ! Happy New Year! How's the learning in the new year going for you ? Thank you for watching and leaving a comment as well. Please check out my other newer video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You're welcome Stewart! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad you like them! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I had an employment test today for word and excel. I watched 2 videos on word and 2 videos on excel. I passed both tests! Thank you so much for these videos. They really really helped me.
Great job!!! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for watching Olaitan ! Please check out my other videos - lots of great information there as well good luck in your journey! Please never stop learning! Keeps you employed and helps you to advance your carrier. All the best! ua-cam.com/users/OnlineTrainingforEveryonevideos
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Just try to watch as many videos as you can. Perhaps, change the speed of the video to accomodate your learning style. You can visit my website and see if you find anything there that might be helpful for you. Just be confident and do try to prepare - the more prepare you're the more confident you'd be while taking the tests thus the better the end result. You got it! Good luck! www.howtoanalyzedata.net/resources/
Thank you again for watching and leaving a comment as well. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here's how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete. Please let me know if it helped. Thanks 4 watching!
Hi, I am sorry I didn't get your name. I am following your videos these days, which I find very instructive, to prepare for a test which is a one day exam (excel is one of the thinks I will be tested for). So my question is what kind of excel test questions do you think we can get for a 24 hour test? I was told that for all the parts of the exam the time to work on it would be about 3-4 hours, so I guess for excel only is one hour. But as i said I have a day to hand in the exam. Thank you very much for any suggestion.
My name is Vadim. Glad it was helpful Simona! Please feel free to watch my other video tutorials when you get a chance to learn even more as all my videos are geared toward helping people to get employed and stay there ua-cam.com/users/OnlineTrainingforEveryone you can access Excel videos here ua-cam.com/users/OnlineTrainingforEveryone/search?query=excel It's hard to say which exactly questions you'd be getting so just try to prepare as much as you can as it's usually much easier to pass tests when you're ready for them and know what to expect. Good luck! Just be cofindent! Don't panic! Everything will be great, but please don't ever stop learning as knowledge is the best investement anyone can do. Thanks for stopping by!
Anytime Simona! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great point Rachid! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How did you test go Josy? Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
ALWAYS!!! Great point!!! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you sir for these useful videos which are so so much helpful for students and jobbers like us.keep it up.subscribed and downloaded as well.love from India.
You're so welcome Jayeeta! Thank you for watching and leaving a comment. Please check out my other videos on Excel ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for other extra materials that would help you to get ready for your interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad to help! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
My pleasure Antonia and thanks for watching! Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it helped! Cyn G! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad you think so! Thank you for watching and leaving a kind comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I'm very sorry Christina it's not working for you! Please try doing the following and let me know if it helped. Thanks! elect the date column. Go to the Data-tab and choose "Text to Columns". On the first screen, leave radio button on "delimited" and click Next. Unselect any delimiter boxes (everything blank) and click Next. Under column data format choose Date. Click Finish.
Thank you again for watching and leaving a comment as well. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great point Andrew! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for the idea! Great point! Please check out my other tutorials - perhaps you'd find something there that wasn't covered in this video. Good luck! ua-cam.com/users/OnlineTrainingforEveryonevideos
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You're so welcome Shannon! Thanks for watching! Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Sorry about that Joanne! Thank you for watching and leaving your honest comment as well! Please check out my other videos - the sound should be better in my newer videos. I figured out the sound and now it's much better: ua-cam.com/users/OnlineTrainingforEveryone You can also check out my website for other extra materials www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you again for watching and leaving a comment as well. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad you liked it Kristina! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
My pleasure Prafful Sharma! Thank you very much for your kind words! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for other extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
It's my pleasure Arshi! Thanks for watching Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey! ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You're very welcome Arshi! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html other videos Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for posting these test questions and tips. I had just one evening to prepare for the intermediate word and excel tests; i've been watching your youtubetips for 5 hours straight and passed both tests on "skills" after being out of school for over 15 years. Спасибо, прекрасный темп речи, произношение и воодушевляющие комментарии.
Thank you , I am trying improve my excel programming. You know how to reach student with simplicity but very professional at high level.
Great to hear that! 😊 Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for your time and energy. I appreciated the video.
My pleasure!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Great video - my only issue is the frequent stops asking us to subscribe to your channel :(
Thank you for these. Can I ask if the same commands and shortcuts are applicable to Mac PC/laptops and yes I do have Microsoft 365? I'm about to have the exam and it's been over a year since I was last employed and hence lacking in confidence though I have been using excel for over 20 years for just regular tables - no pivots. graphs, or complicated comparatives.
You're so welcome Lili! Very sorry just seeing your comment -somehow UA-cam was hiding it from me. How is your Excel learning going and thank you again for watching & leaving a comment as well. Have you been able to find the job ? Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
So helpful could you please explain to me the importance of macros and where they are applied
Thank you very much for taking time to leave a feedback and ask a questions.
Using Excel Macros can speed up work and save you a lot of time.
If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.
Excel Macro Examples:
Unhide All Worksheets at One Go.
Hide All Worksheets Except the Active Sheet.
Sort Worksheets Alphabetically Using VBA.
Protect All Worksheets At One Go.
Unprotect All Worksheets At One Go.
Unhide All Rows and Columns.
Unmerge All Merged Cells.
Save Workbook With TimeStamp in Its Name.
Good luck in your learning journey!
Why did only use the range B2:11 when solving the Jason SUMIF question? Why didn't you add B12 in the range when you included C12 in the range to get the answer?
Most likely just an error on my side - I'm not perfect :) Just trying to do too many things on my own and all by myself
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I was charged twice for the ebook and cannot find who to contact about this.
I'm very sorry it happened to you Jennifer! The best way to contact is email via the website.
Do you have a different last name on your paypal account? I'm looking for the exact match as your UA-cam user name but there's nothing there. However, I do see two identical transactions. Please let me know and we'll refund it. Thanks!
@@OnlineTrainingforEveryone THANK YOU, IT'S JENNIFER TYNDALL.
If I hear "now let's continue and get ready for excel interview and assessment test" one more time ima cry
Thank you for watching, Zach, and leaving a comment with your honest feedback as well. I stopped doing this in my new videos since I do read the comments and take them seriously. Please check out my newer videos
ua-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
@@OnlineTrainingforEveryone your video was very helpful thankful! I was just joking around
I even started saying it.. 😂
Overall very helpful video
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
🤣🤣🤣
Recently I completed an intermediate excel test sent by the employer. The test was 30+ questions, set up by SkillCheck and it was a software simulation test (the worst kind, imo). To my surprise, about two thirds of the test was pretty simple and straight forward. It was comprised of copying and pasting cells, formatting and saving worksheets. The more difficult questions were about creating a formula to multiply different cells, creating slicers and a couple more formula questions. Hope this helps anyone taking these tests during the interview process.
Did you pass and get the job?
@@Sushihead I passed the test but took another job.
Is it monitored in any way?
@@mohddilshad5025 I don't think there was any monitoring of the assessment that I took with the exception of how many questions i answered correctly or incorrectly, of course. I don't think it was monitored for time or anything like that.
I used to have a co-worker who changed my excel work (yearly end closing) and sabotaged me. She refused me to do password protection. I ended up losing my job because of her. Its important to do password protection if your excel work is shared to other people...
I'm very sorry this has happened to you Josephine! Thank you very much for sharing your experience with everyone! You're absolutely correct about password protecting your work. Hope everything will work out for you. Please keep us updated on your journey. Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
ive been using excel for years and I could say im really proficient with it. But seeing your videos about excel really opened new prespectives on how dynamic this software really is and your videos taught me things that I havent even thought of using before. Keep up the with the videos mate :) Really really really appreciate it
Thank you very much for watching Vashvon and for leaving such a positive comment! It's greatly appreciated when my humble expertise is recognized. Means a world to me and inspires me to work harder so I can help my dear viewers!
Please check out my other Excel videos - and let me know what you think about those tutorials. Thanks again for watching and please don't ever stop learning - keeps you employed and allows you to advance your carrier.
Good luck in your journey!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Hello. In the very first question the sumif range was b2:b11. Why is it not b2:b12? I'm not an expert at all so honestly just trying to understand....
I think it's because the last Jason ended at B10 so he just added one more to make it b11. He could've actually ended at b10 though.
in sumif function example , why did you use B2:B11 instead of B2:B12. thank you
great video but your constant ads are very annoying. We don't need to see your add after every answer.
I understand! Very sorry about it ! Please check my newer videos - I stopped doing it so hopefully, you'd give my tutorials another chance. Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
for the 1st example, wouldn't it be from B2, B12? instead of B11?
Exactly... My take as well.. But all the same we are grateful to you sir ❤❤❤
There videos are SO helpful. I am currently applying for jobs that require Excel tests and this is definitively helping me along. Thank you.
Glad it was helpful! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Practice Microsoft Excel Assessment Test www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/
It would have been good explain why there is a random 0 at the end of the Index & Match string.
Thank you for this great video. I did not know the how to use "Concatenating" and "Text to Colum". I tried both these formulae and it worked in my file! Thanks again. I had an excel test 2 years ago in which they asked the formats in the longer way such as Select the cell and then click "copy" and then click on the new cell and then click "paste" etc..... But I always use the right-click of the mouse and all components I get very quickly and I move on. Even though you are very smart in your work, when you give a test, it becomes tough because you do not remember, where can you find the proper icon, because you have no option to use the right-click during the test. That test taught me that, when you go for a test, you better learn the longer route method!
Thanks for the tutorial , I have an assessment to take and my excel knowledge is limited. I no some of the basics. I still am not sure I am ready for the assessment; however, I think your video will help.
You are welcome Dolphine! Glad you liked it and I'm sure you'd do great! Try to prepare as much as you can - it always helps to pass. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I'm grinding for a job interview I have tomorrow and thought I would just shoot a comment out to say hello. I'm subbing strictly on the no-nonsense description of your content, which aims to help people like me find the job they want. Thanks for helping us all out and wish me luck tomorrow!
Did you get the job?🍀🤞🏾
why do u keep interupting with ads. you kill the concentration, very bad when teaching.
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them - I stopped doing the interraptions
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
32.12 the answer is text to column but you first say 'the answer here is split to columns' that's confusing...i suppose is a mistake?
Thank you very much for watching and for pointing it out Sabina!!! I'll need to look into this. Please make sure to watch my other video tutorials - lots of great information there and I add new ones regularly. Good luck in your journey!
ua-cam.com/users/OnlineTrainingforEveryonevideos
Yes. You first mention Split to Column and later on answer is text to column. I got confused there.
Thank you. You're videos are helpful.
Very sorry for confusing you!!! I do everything myself so errors do happen - hope you understand. I'm not perfect just trying to be but as you can see not very successful :) How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
You are doing such a great service. God bless you.. ❤From south africa 🌍
Good to know the subtle difference between substitute function & Replace.😀 Thank you!!
You're very welcome! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Example questions and answers very useful but the number and frequency of interruptions is enough to prevent me watching more of your videos.
Thank you for watching and leaving a comment with your opinion! I greatly appreciate that! Please check out my newest video - no interruptions there and let me know what you think - really hope you'd give it a try
ua-cam.com/video/Op0Kdemme_w/v-deo.html
Please look at the rest of my videos as well - lots of great and helpful information in each and every one of them.
ua-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey! Keep on learning please! Knowledge helps you to advance your carrier and your life to the new heights!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Great videos and easy to follow, learnt so much from them
Excellent presentation. style is difficult things made easy
Glad to help! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
B2:B12 rather? Why C2:C12 and not B2:B12?
Most likely a typo Clare - I'm just a human. Very sorry for confusing you! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this detailed video sir, much appreciated 🙏🏽💯👌🏾! And shoutouts to the Brewers and the Mil! Are you a fellow Milwaukean??
Yes I am and feel blessed living in such a great city! Go Brewers, Bucks, and Packers :) Thank you very much for watching Diva! Please make sure to watch my other video tutorials on this topic and my other helpful video tutorials - lots of great information there. The more prepared you're the easier it is to find the right position or do whatever you're already doing more efficiently.
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=aptitude
You can also check out my website for any additional information you might find helpful. Good luck in your journey and please don't ever stop learning - knowledge keeps you employed and helps you to advance your carrier to the new heights!
www.howtoanalyzedata.net/resources/
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
This video is 10 minutes of very valuable information and 36 minutes of crap. Please try to cut ot all the 'please subscribe', 'how to learn' and 'do me a favour' drivel. Keep the content concentrated and the subscribers would come, without all the begging.
Thank you for the honest comment Sophia! I listened and in my newer videos no crap :)
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this helpful video. This was a great refresher for me. I purchased your Microsoft course bundle through your website, and I look forward to learning more.
You're very welcome Stacey and thank you for watching, the purchase and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Can you do me a favor and Stop Advertising? Your constant advertising made this video 45 mins when it was probably only half that time. Make all the statements at the end of the video and say it once instead of several times throughout the video. Thank you.
Sorry about that J'adore- you watched my older videos - one of the very first ones I made. Would you please give it another try and watch my newer videos - I don't do it anymore as much - I do listen to my viewers :)
Please let me know how it goes. Very sorry again for frustrating you - good luck in your journey!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Thank you again for watching and leaving a comment as well. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
This goes way too fast for me, a beginner. Hard to digest all the information spoken so quickly.
Glad it was helpful! Thank you for watching and leaving a comment as well! Please keep in mind that you can change the speed of the video. Also check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Appreciate your work in putting out these videos. But there is tooooooo many interruptions on top ot the adds someone has to look at. :.( Sorry, it takes up too much time.
I'm very sorry for the interaptions! Please watch my other videos - I stopped doing it as I do listen to the feedback my viewers provide. Thank you very much for giving it another chance!
Just wanted to let you know that I listened and my newer videos don't have interruptions, so I hope you'd give me another chance. How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Great questions but this could have been 20 minutes shorter.
Thank you for watching Matt and leaving an honest comment as well. I'll look into this video. Please check out my other videos on Excel
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Peter, I like when you spaz out and do the thumbs up weird stuff 😂😜😁👌🏽🔫
Thank you for watching Jo and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
@@OnlineTrainingforEveryone it is my pleasure. Keep up your very good work. It has helped me immensely 🙏🏽🕉🔥
Stupidest way of asking questions ever. It's better to give the task rather than tricking the candidate into something.
Great and valid point! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for sharing your knowledge. Much appreciate it.
Glad it was helpful!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I liked and subscribed to your video but when I saw the 5th like and subscribe beg button i removed it
Thanks for your feedback! Unfortunately I can’t update the old videos but definitely will use different approach in the new videos. Hopefully you will reconsider about subscribing 😀! All the best on your job interview and assessment test!
This is great! Your pace and how you have formatted each example really is class!
Glad you liked it! Thank you for watching and leaving a kind comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I can get the iffuntion for jason
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for making Videos to educate us and prepare for interview. May God Bless you !
I turned down the speed of the speaker. I am NOT a speedo. A little slower?
Very sorry it's too fast for you Margaret, however please keep in mind that the speed of UA-cam videos can be modified by using the video settings in the bottom right corner of each video. There are multiple options for you to choose from. Hope it helps but please feel free to reach out with any of your suggestions - I greatly appreciate the feedback my viewers provide.
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Split to Column not working for me. My version ask for destination cells, which I provided, but names not showing in separate columns. Please advise.
Sorry just seeing your comment. You probably have an older version of Excel. You need to update it and then all the features I discuss in my tutorials will be available for you as well. Hope it makes sense. How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
This was a helpful video but the bald dude popping up every two seconds creeped me out
Thanks for watching and very sorry for the bald dude popups! Please check out other Excel videos - perhaps you'll find them helpful in your situation and there shouldn't be the bald dude popups. Good luck!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it - almost no dude there till the very end so no creeping out!
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Whoever wrote this comment, respect the person helping us out to pass interview. He is teaching us for free. He was very kind to you in his response. May God Bless him!
If the cell is already formatted as percent and you enter "0.5", it will be 0.5%. If you enter 0.5 and then format the cell to percent, then it would be 50%. I think the answer to your question is wrong.
Thank you for watching and leaving a comment as well, Erica I'll look into this. Please check out my other videos on Excel - I appreciate your constructive criticism
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I know it's 7 months late but you are correct Erika. Was looking to see if anyone made this comment.
I tried it both ways just now and came up with 50% each time.
What is the name of your website sir? I really want to download the PDF file. A huge help for me💯
www.howtoanalyzedata.net/resources/
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this! Even though my hiring manager only gave me until next day to complete & I'm pretty much at beginner level and rusty. 😑
You got this! Thank you for watching and leaving your comment as well. Please check out my other videos on Excel
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I know how to do all this , how much am I looking to get paid?
on the substitute function you put SUBSTITUTE(A1,%," ")..... are we supposed to literally type ALL of that exactly in that form? and then I assume hit "enter"? or just click onto your next column? I've never used excel really and I have a test for probations this weekend which im quite positive will have these types of assessments and I'm praying to God it doesn't.. or praying I pass if it does.. helllllp. so confused on that SUBSTITUTE(A1,%," ")
Its very irritating that you ask for help after any 1 minute...
Very sorry about that! Thank you for watching and leaving a comment as well! I stopped doing it in my new videos.
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Today I have an excel assessment. Thank u so much for the assistance.
You are most welcome! Good luck!
How did the interview go? Any tips?
Thank you again for watching and leaving a comment as well. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Easier way to Auto Filter.-->Highlight the column headers you want to use filter feature on--> Data--> Filter. Done.
Worst excel tutorial. Better simplify it
Can you send me books of computer
You are absolutely wonderful! :) Thankfully, I clicked "pause" and tried each task for each question that you asked and, luckily, I already knew most of these. That said, I must admit... I have thoroughly enjoyed watching this video! I love your teaching method & the way you go about explaining things! I have no doubt this video has helped a lot of people out. One thing that I'm most concerned with is that I know nothing about the test that I am getting ready to take (which is what lead me to your video) so even though I have been working in Excel for many years and am usually the "go-to" person at work anytime anyone has Excel questions and I've built many super awesome spreadsheets for folks that are actually still being used to this day, I still get so nervous before taking assessment tests, so I'm a bit worried that there will be trick questions or perhaps multiple methods of gathering the same info or arriving at the same answer, that I'm scared I'll get a question wrong that I actually would have gotten correct if I was working on an real Excel spreadsheet! lol Nevertheless, I do feel much more comfortable about testing my skills now that I've worked alongside you, while watching your video! And I'm super excited that I got nearly all of your questions correct. :) Thank you so much for your assistance! I'm definitely going to subscribe to your channel & follow you for more Excel tips & tricks!! 100% =D Thanks again & have a wonderful week!! 🤓🙏
I am excel beginner, but its really wonderful and beneficial class, thank you Vadim.
Glad to hear that! You're very welcome! Thank you for watching and leaving a comment as well! Please check out my new video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Another fantastic video. I love your excel for employment video too. This is the best tutorial for intermediate excel!! It’s empowering, and I really appreciate it. 🙏
37:35 my outcome states that it’s 18/10/2109 I’ve gone over and over what you’ve done but this is always the end result, anything I’m doing wrong?
I have a series of number, but i want to add prefix number to the series of number, so how do i Auto the prefix. For example 975544 i want to add 080 to the front of the different series of numbers. What formula do i use?????
Vadim is a great instructor! All the Excel tricks were understood and applied easily!
Thank you very much for your kindness AM ! Happy New Year! How's the learning in the new year going for you ? Thank you for watching and leaving a comment as well. Please check out my other newer video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
When I try CTRL + ;, it shows the current time, rather than current date. Anyone know how to change it?
microsoft holds a world excel championship.
You're welcome Stewart! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for these informative video's. Very, very helpful!
Glad you like them! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I had an employment test today for word and excel. I watched 2 videos on word and 2 videos on excel. I passed both tests! Thank you so much for these videos. They really really helped me.
Is it the tosa test?
Could you help me cheat I'll pay you
how can I download practice examples
Great job!!! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Hm, the commands shown in the video do not work in my XLS. Why?
So happy I saw this post, good job, God bless you
Thanks for watching Olaitan ! Please check out my other videos - lots of great information there as well good luck in your journey! Please never stop learning! Keeps you employed and helps you to advance your carrier. All the best!
ua-cam.com/users/OnlineTrainingforEveryonevideos
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I have an Excel and Word employment tests coming in 1 day, I have been studying but there are too many thins to learn in short time, need help.
Just try to watch as many videos as you can. Perhaps, change the speed of the video to accomodate your learning style. You can visit my website and see if you find anything there that might be helpful for you. Just be confident and do try to prepare - the more prepare you're the more confident you'd be while taking the tests thus the better the end result. You got it! Good luck!
www.howtoanalyzedata.net/resources/
Thank you again for watching and leaving a comment as well. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you, it is very concise and informative. Priscilla
how to delete a pre-marked table in excel?
If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here's how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete. Please let me know if it helped. Thanks 4 watching!
Hi, I am sorry I didn't get your name. I am following your videos these days, which I find very instructive, to prepare for a test which is a one day exam (excel is one of the thinks I will be tested for). So my question is what kind of excel test questions do you think we can get for a 24 hour test? I was told that for all the parts of the exam the time to work on it would be about 3-4 hours, so I guess for excel only is one hour. But as i said I have a day to hand in the exam. Thank you very much for any suggestion.
My name is Vadim. Glad it was helpful Simona! Please feel free to watch my other video tutorials when you get a chance to learn even more as all my videos are geared toward helping people to get employed and stay there
ua-cam.com/users/OnlineTrainingforEveryone
you can access Excel videos here
ua-cam.com/users/OnlineTrainingforEveryone/search?query=excel
It's hard to say which exactly questions you'd be getting so just try to prepare as much as you can as it's usually much easier to pass tests when you're ready for them and know what to expect. Good luck! Just be cofindent! Don't panic! Everything will be great, but please don't ever stop learning as knowledge is the best investement anyone can do. Thanks for stopping by!
@@OnlineTrainingforEveryone Thank you Vadim
Anytime Simona! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
you are as high as kite if you think i am spending $89 a moth for a practice test
I found this very helpful. Thanks so much!
Please keep learning!!!!
You could use Flash Fill instead of Concatenate.
Great point Rachid! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
i have formatting interview test tomorrow
How did you test go Josy? Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Now I believe that there is much more to learn
ALWAYS!!! Great point!!! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Should formula for first question be SUMIF(B2:B12 ..... for first part and not SUMIF(B2:B11 ... ?
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Question, We just have to answer the choices or also solve the same on computer?
I truly enjoy your videos.
Thanks Elsien! Glad you like them - hopefully they are helpful as well! All the best on your job interview and assessment test!
Thank you sir for these useful videos which are so so much helpful for students and jobbers like us.keep it up.subscribed and downloaded as well.love from India.
You're so welcome Jayeeta! Thank you for watching and leaving a comment. Please check out my other videos on Excel
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for your interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
presentation and info are really nice thank you
Glad to help! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for the great way to teach this valuable content!
My pleasure Antonia and thanks for watching! Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
million thumbs up. thank you ❤️
Glad it helped! Cyn G! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
This is the greatest guide…thanks so much
Glad you think so! Thank you for watching and leaving a kind comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
the format custom for date doesn't work on my computer
I'm very sorry Christina it's not working for you! Please try doing the following and let me know if it helped. Thanks!
elect the date column.
Go to the Data-tab and choose "Text to Columns".
On the first screen, leave radio button on "delimited" and click Next.
Unselect any delimiter boxes (everything blank) and click Next.
Under column data format choose Date.
Click Finish.
Thank you again for watching and leaving a comment as well. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
2
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
TextJoin() would be better
Great point Andrew! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Hi, love the videos. It would also be great if you demonstrate what all the other options would do to the data as well. Thanks!
Thanks for the idea! Great point! Please check out my other tutorials - perhaps you'd find something there that wasn't covered in this video. Good luck!
ua-cam.com/users/OnlineTrainingforEveryonevideos
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
This is so great!!! thank you so much!!
You're so welcome Shannon! Thanks for watching! Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I found this video after struggling in an interview where all the questions were on excel🙂
B
B
I am wondering which questions might be tested in excel assessment for purchasing analysis position. Where could I download it? Thanks
thanks for the training but you are talking too softly - a little louder would be nice.
Sorry about that Joanne! Thank you for watching and leaving your honest comment as well!
Please check out my other videos - the sound should be better in my newer videos. I figured out the sound and now it's much better:
ua-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for other extra materials
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you again for watching and leaving a comment as well. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Your formula on first example does not work on Excel 2013. I created the same worksheet and my result is 0. What am I doing wrong?
Please upgrade your Excel - 2013 version needs to go :)
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Very good, thank you!
Glad you liked it Kristina! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for sharing your invaluable knowledge with everyone.
My pleasure Prafful Sharma! Thank you very much for your kind words! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
@@OnlineTrainingforEveryone When I can, in future, I will make sure to give back. Thank you.
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
thnx sir for providing that awesome content
It's my pleasure Arshi! Thanks for watching Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey!
ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You're very welcome Arshi! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
other videos
Many other great videos are also available here ua-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!