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.
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. Спасибо, прекрасный темп речи, произношение и воодушевляющие комментарии.
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!
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!
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!
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.
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!
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 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!
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!
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. 🙏
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!
Thank you for getting to the point so fast. So many other channels talk and talk before they get to the teaching. I really appreciate the way you cut to the chase.
Thank you for watching Anita and leaving such kind 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! 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!
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!
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!
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!
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!
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!
A good extra tip about text to column is that this is a great way to convert a column of text to numbers. You don’t even need to create another column. Highlight the column with numbers formatted as text, then run through all of the steps of text to columns without choosing anything which means you are going to stay in that one column since you only have the one number per cell. The magic of text to columns is that numbers become numbers so just by running through text to columns your whole column is numbers as numbers. If your text is the result of a formula you can use NUMBERVALUE to convert the result of that formula to a number 😊 so if you extracted text before/after delimiter and want the result to be number. The text to columns track wood actually show the text of your formula hee hee Thank you for the great summary I am getting ready for an interview tomorrow!!!
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!
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!
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!
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!
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 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!
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!
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!
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 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!
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!
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!
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!
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!
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!
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!
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!
Glad you think so Kristy! Thank you for watching and leaving such a kind comment as well. Please check out my other videos ua-cam.com/users/OnlineTrainingforEveryone You can also check out my website for the extra materials if needed 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!
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!
Most welcome Jamal! Thank you for watching and leaving a kind 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!
You're welcome Danielle! 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!
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!
My pleasure Mayar 😊 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 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 you think so! Most welcome 😊 Thank you for watching and leaving a comment as well. Please check out my newer video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html Many other great tutorials are 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 to hear that! I'm really glad you liked it! Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think about it ua-cam.com/video/Op0Kdemme_w/v-deo.html Many other great tutorials are 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, 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!
You're welcome Irina! 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 including the apptitude questios 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 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?????
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,%," ")
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!
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!
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 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!
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!
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!
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 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!
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 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!
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!
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!
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!
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!
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!
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 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!
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!
You are doing fine work but please do more closeups/body-shots/movements of yourself to keep the pace energetic and dynamic. Also use extreme high res. Thanks again and keep up the equality work.
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!
![Excel Online Tutorial [ Excel in The Browser ]](http://i.ytimg.com/vi/8hrXcpM0lVo/mqdefault.jpg)
![Excel Online Tutorial [ Excel in The Browser ]](/img/tr.png)
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.
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. Спасибо, прекрасный темп речи, произношение и воодушевляющие комментарии.
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!
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!
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?🍀🤞🏾
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
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!
You are doing such a great service. God bless you.. ❤From south africa 🌍
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 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!
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!
🤣🤣🤣
in sumif function example , why did you use B2:B11 instead of B2:B12. thank you
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. 🙏
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!
thank you for the lesson.
Thank you for getting to the point so fast. So many other channels talk and talk before they get to the teaching. I really appreciate the way you cut to the chase.
Thank you for watching Anita and leaving such kind 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!
Thank you for making Videos to educate us and prepare for interview. May God Bless you !
Great videos and easy to follow, learnt so much from them
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!
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!
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!
It would have been good explain why there is a random 0 at the end of the Index & Match string.
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!
Great video - my only issue is the frequent stops asking us to subscribe to your channel :(
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!
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!
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!
A good extra tip about text to column is that this is a great way to convert a column of text to numbers. You don’t even need to create another column. Highlight the column with numbers formatted as text, then run through all of the steps of text to columns without choosing anything which means you are going to stay in that one column since you only have the one number per cell. The magic of text to columns is that numbers become numbers so just by running through text to columns your whole column is numbers as numbers.
If your text is the result of a formula you can use NUMBERVALUE to convert the result of that formula to a number 😊 so if you extracted text before/after delimiter and want the result to be number. The text to columns track wood actually show the text of your formula hee hee
Thank you for the great summary I am getting ready for an interview tomorrow!!!
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!
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!
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!
Thank you, it is very concise and informative. Priscilla
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!
Thank you so much for this video! This is amazing! Will help me for my interview
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!
Question, We just have to answer the choices or also solve the same on computer?
Practice Microsoft Excel Assessment Test www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/
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 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!
I found this very helpful. Thanks so much!
Please keep learning!!!!
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 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!
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!
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 ❤❤❤
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!
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.
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!
Thank you very much for your hard work for this wonderful informative video!
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 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!
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!
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!
Super session sir ❤
This is great!
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 am wondering which questions might be tested in excel assessment for purchasing analysis position. Where could I download it? Thanks
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!
This video was amazing and very helpful
Glad you think so Kristy! Thank you for watching and leaving such a kind comment as well. Please check out my other videos
ua-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for the extra materials if needed
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!
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!
Thank you so much sir.
Most welcome Jamal! Thank you for watching and leaving a kind 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!
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! 😀
You're welcome Danielle! 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!
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!
Thank yoooou for video my dear
My pleasure Mayar 😊 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 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!
Excellent learning
Glad you think so! Most welcome 😊 Thank you for watching and leaving a comment as well. Please check out my newer video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
Many other great tutorials are 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 to hear that! I'm really glad you liked it! Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think about it
ua-cam.com/video/Op0Kdemme_w/v-deo.html
Many other great tutorials are 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, 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!
Thank you !!!!!!!!!!!!
You're welcome Irina! 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 including the apptitude questios
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 video
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?????
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,%," ")
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!
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!
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!
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!
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!
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!
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!
Thank u
Glad it was helpful! 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 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!
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!
Easier way to Auto Filter.-->Highlight the column headers you want to use filter feature on--> Data--> Filter. Done.
I know how to do all this , how much am I looking to get paid?
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 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!
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!
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!
Hm, the commands shown in the video do not work in my XLS. Why?
When I try CTRL + ;, it shows the current time, rather than current date. Anyone know how to change it?
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!
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!
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!
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!
I found this video after struggling in an interview where all the questions were on excel🙂
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.
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!
Can you send me books of computer
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!
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 🙏🏽🕉🔥
You are doing fine work but please do more closeups/body-shots/movements of yourself to keep the pace energetic and dynamic. Also use extreme high res. Thanks again and keep up the equality work.
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!