How to Pass Intermediate Excel Employment Test: Questions and Answers

@samflynn3670 8 ай бұрын

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.

@Sushihead 5 ай бұрын

Did you pass and get the job?

@samflynn3670 5 ай бұрын

@@Sushihead I passed the test but took another job.

@mohddilshad5025 3 ай бұрын

Is it monitored in any way?

@samflynn3670 3 ай бұрын

@@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.

@crazy_wb 3 жыл бұрын

If I hear "now let's continue and get ready for excel interview and assessment test" one more time ima cry

@OnlineTrainingforEveryone 3 жыл бұрын

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 kzfaq.info You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

@crazy_wb 3 жыл бұрын

@@OnlineTrainingforEveryone your video was very helpful thankful! I was just joking around

@lannyltp 3 жыл бұрын

I even started saying it.. 😂 Overall very helpful video

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@sinosakambana 8 ай бұрын

🤣🤣🤣

@ttuzlova9672 Жыл бұрын

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. Спасибо, прекрасный темп речи, произношение и воодушевляющие комментарии.

@kristinamelnichenko5775 Жыл бұрын

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!!!

@SonofD3co 2 жыл бұрын

This is great! Your pace and how you have formatted each example really is class!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@vashvon327 3 жыл бұрын

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

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infosearch?query=excel

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@margaretdsouza3782 2 жыл бұрын

Thank you for making Videos to educate us and prepare for interview. May God Bless you !

@AM-cr6gg 2 жыл бұрын

Vadim is a great instructor! All the Excel tricks were understood and applied easily!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@yazialmarzooqi6017 2 жыл бұрын

Thank you so much for this video! This is amazing! Will help me for my interview

@Marusela66 3 жыл бұрын

There videos are SO helpful. I am currently applying for jobs that require Excel tests and this is definitively helping me along. Thank you.

@OnlineTrainingforEveryone 3 жыл бұрын

Glad it was helpful! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzfaq.infosearch?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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@quickview3 2 жыл бұрын

Good to know the subtle difference between substitute function & Replace.😀 Thank you!!

@OnlineTrainingforEveryone 2 жыл бұрын

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! kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@nikhatkamal8908 2 жыл бұрын

Thank you very much for your hard work for this wonderful informative video!

@user-kg7cs4fk2f Жыл бұрын

Great videos and easy to follow, learnt so much from them

@vaulics Жыл бұрын

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!

@myjumanji1583 10 ай бұрын

Did you get the job?🍀🤞🏾

@josephineiwatani5987 3 жыл бұрын

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...

@OnlineTrainingforEveryone 3 жыл бұрын

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 kzfaq.infosearch?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 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@StaceyMONeale Жыл бұрын

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.

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@woowootodd 3 жыл бұрын

Thanks for your time and energy. I appreciated the video.

@OnlineTrainingforEveryone 3 жыл бұрын

My pleasure!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@allysonpamplin4044 Жыл бұрын

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.

@Lisainny Жыл бұрын

Is it the tosa test?

@Codiac17 11 ай бұрын

Could you help me cheat I'll pay you

@Lay_Lady_Lay 2 ай бұрын

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!! 🤓🙏

@nokwazinkosikazi2584 Жыл бұрын

You are doing such a great service. God bless you.. ❤From south africa 🌍

@anitadulany661 2 жыл бұрын

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.

@OnlineTrainingforEveryone 2 жыл бұрын

Thank you for watching Anita and leaving such kind comment as well. Please check out my other videos kzfaq.info 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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@miriambonilla6407 3 жыл бұрын

Thank you for sharing your knowledge. Much appreciate it.

@OnlineTrainingforEveryone 3 жыл бұрын

Glad it was helpful!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@bingbangbon 3 жыл бұрын

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!

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infovideos

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@lmutukisna3183 2 жыл бұрын

Thank you , I am trying improve my excel programming. You know how to reach student with simplicity but very professional at high level.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@MKunks 2 жыл бұрын

Thank you for these informative video's. Very, very helpful!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@brits6251 2 ай бұрын

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. 🙏

@anyakawaiix 2 жыл бұрын

I found this very helpful. Thanks so much!

@OnlineTrainingforEveryone 2 жыл бұрын

Please keep learning!!!!

@annkk5037 3 жыл бұрын

Thank you for the great way to teach this valuable content!

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infosearch?query=excel

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@lsoliman9 3 жыл бұрын

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.

@OnlineTrainingforEveryone 2 жыл бұрын

You're so welcome Lili! Very sorry just seeing your comment -somehow KZfaq 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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@73TruBlu 2 жыл бұрын

This is the greatest guide…thanks so much

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@marikat-tr2wi 4 ай бұрын

Thank you, it is very concise and informative. Priscilla

@janiellewalker8021 2 жыл бұрын

Great video - my only issue is the frequent stops asking us to subscribe to your channel :(

@elsien_3779 Жыл бұрын

I truly enjoy your videos.

@OnlineTrainingforEveryone Жыл бұрын

Thanks Elsien! Glad you like them - hopefully they are helpful as well! All the best on your job interview and assessment test!

@Sunshine-pl2hp 3 жыл бұрын

This is so great!!! thank you so much!!

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infosearch?query=excel

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@brendamg7298 2 жыл бұрын

This is great!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@shuxiajing4669 3 жыл бұрын

I am wondering which questions might be tested in excel assessment for purchasing analysis position. Where could I download it? Thanks

@kristinamelnichenko5775 Жыл бұрын

Very good, thank you!

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@michaeldemetry4077 2 жыл бұрын

presentation and info are really nice thank you

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@jamalnuman105 3 жыл бұрын

Thank you so much sir.

@OnlineTrainingforEveryone 3 жыл бұрын

Most welcome Jamal! Thank you for watching and leaving a kind comment as well. Please check out my other videos on Excel kzfaq.infosearch?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!

@cyng.6521 2 жыл бұрын

million thumbs up. thank you ❤️

@OnlineTrainingforEveryone 2 жыл бұрын

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! kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@shabbirahmad9888 2 жыл бұрын

Excellent presentation. style is difficult things made easy

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@olaitanuche1607 3 жыл бұрын

So happy I saw this post, good job, God bless you

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infovideos

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@praffulsharma5615 3 жыл бұрын

Thank you for sharing your invaluable knowledge with everyone.

@OnlineTrainingforEveryone 3 жыл бұрын

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 kzfaq.infosearch?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!

@praffulsharma5615 3 жыл бұрын

@@OnlineTrainingforEveryone When I can, in future, I will make sure to give back. Thank you.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@hamdiabdurhmandungus6379 Жыл бұрын

I am excel beginner, but its really wonderful and beneficial class, thank you Vadim.

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@jayeetadey3399 3 жыл бұрын

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.

@OnlineTrainingforEveryone 3 жыл бұрын

You're so welcome Jayeeta! Thank you for watching and leaving a comment. Please check out my other videos on Excel kzfaq.infosearch?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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@dolphinebrooks7601 2 жыл бұрын

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.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info You can also check out my website for extra materials that would help you 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 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@RaviKumar-ce2nh 4 ай бұрын

Great video

@DivaDivine88 3 жыл бұрын

Thank you for this detailed video sir, much appreciated 🙏🏽💯👌🏾! And shoutouts to the Brewers and the Mil! Are you a fellow Milwaukean??

@OnlineTrainingforEveryone 3 жыл бұрын

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. kzfaq.infosearch?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/

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@sreelakshmi9485 3 жыл бұрын

Today I have an excel assessment. Thank u so much for the assistance.

@OnlineTrainingforEveryone 3 жыл бұрын

You are most welcome! Good luck!

@izzydoesstuff6341 3 жыл бұрын

How did the interview go? Any tips?

@OnlineTrainingforEveryone 2 жыл бұрын

Thank you again for watching and leaving a comment as well. Please check out my other videos kzfaq.info 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!

@mandela349 2 жыл бұрын

in sumif function example , why did you use B2:B11 instead of B2:B12. thank you

@kristy122206 3 жыл бұрын

This video was amazing and very helpful

@OnlineTrainingforEveryone 3 жыл бұрын

Glad you think so Kristy! Thank you for watching and leaving such a kind comment as well. Please check out my other videos kzfaq.info 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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@irinabergstrom337 Жыл бұрын

Thank you !!!!!!!!!!!!

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here including the apptitude questios kzfaq.info 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!

@katrinah95 2 жыл бұрын

Thank you for this

@OnlineTrainingforEveryone 2 жыл бұрын

My pleasure Kat! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzfaq.infosearch?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 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@daniellegonsalves6809 3 жыл бұрын

Thank you! 😀

@OnlineTrainingforEveryone 3 жыл бұрын

You're welcome Danielle! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzfaq.infosearch?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 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@theterminaldave 6 ай бұрын

It would have been good explain why there is a random 0 at the end of the Index & Match string.

@chezalepresents 3 жыл бұрын

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. 😑

@OnlineTrainingforEveryone 3 жыл бұрын

You got this! Thank you for watching and leaving your comment as well. Please check out my other videos on Excel kzfaq.infosearch?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 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@arshisohi8829 3 жыл бұрын

thnx sir for providing that awesome content

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infosearch?query=excel

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@dilshadmotivates 2 жыл бұрын

Excellent learning

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html Many other great tutorials are available here kzfaq.info 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 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html Many other great tutorials are available here kzfaq.info 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!

@shabbirahmad9888 2 жыл бұрын

Question, We just have to answer the choices or also solve the same on computer?

@ssekateraymond2446 4 жыл бұрын

So helpful could you please explain to me the importance of macros and where they are applied

@OnlineTrainingforEveryone 4 жыл бұрын

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!

@maureenwilberforce9129 4 жыл бұрын

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?

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@mayarwasily5610 2 жыл бұрын

Thank yoooou for video my dear

@OnlineTrainingforEveryone 2 жыл бұрын

My pleasure Mayar 😊 Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzfaq.infosearch?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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@oluwatobijunaid4675 2 жыл бұрын

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?????

@lennbuyoo2504 Жыл бұрын

Thank u

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@autumndroplet9776 2 жыл бұрын

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?

@khadigaelhassan6084 Жыл бұрын

Now I believe that there is much more to learn

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@h-pj7720 3 жыл бұрын

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....

@alexadefemi540 Жыл бұрын

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.

@sheilastevens5183 3 жыл бұрын

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.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@concernedcitizen7030 2 жыл бұрын

for the 1st example, wouldn't it be from B2, B12? instead of B11?

@nokwazinkosikazi2584 Жыл бұрын

Exactly... My take as well.. But all the same we are grateful to you sir ❤❤❤

@simonapalosan3208 3 жыл бұрын

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.

@OnlineTrainingforEveryone 3 жыл бұрын

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 kzfaq.info you can access Excel videos here kzfaq.info/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!

@simonapalosan3208 3 жыл бұрын

@@OnlineTrainingforEveryone Thank you Vadim

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@reine924 2 жыл бұрын

I found this video after struggling in an interview where all the questions were on excel🙂

@reply 3 жыл бұрын

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.

@OnlineTrainingforEveryone 3 жыл бұрын

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/

@OnlineTrainingforEveryone 2 жыл бұрын

Thank you again for watching and leaving a comment as well. Please check out my other videos kzfaq.info 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!

@nickblack4410 3 жыл бұрын

What is the name of your website sir? I really want to download the PDF file. A huge help for me💯

@OnlineTrainingforEveryone 3 жыл бұрын

www.howtoanalyzedata.net/resources/

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@rachellerose4952 Жыл бұрын

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,%," ")

@miall69 2 жыл бұрын

You could use Flash Fill instead of Concatenate.

@OnlineTrainingforEveryone 2 жыл бұрын

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! kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@agnieszkachojecka8836 9 ай бұрын

Hm, the commands shown in the video do not work in my XLS. Why?

@huangjane8301 Жыл бұрын

When I try CTRL + ;, it shows the current time, rather than current date. Anyone know how to change it?

@LouCook4531 3 жыл бұрын

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?

@OnlineTrainingforEveryone 3 жыл бұрын

Please upgrade your Excel - 2013 version needs to go :)

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@garnetstewart3461 Жыл бұрын

microsoft holds a world excel championship.

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@josyperez3047 2 жыл бұрын

i have formatting interview test tomorrow

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@sabinabianchi5469 3 жыл бұрын

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?

@OnlineTrainingforEveryone 3 жыл бұрын

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! kzfaq.infovideos

@mariegayo4412 3 жыл бұрын

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.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@innerpeace4516 Жыл бұрын

how can I download practice examples

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@muhammadahsan9740 2 жыл бұрын

how to delete a pre-marked table in excel?

@OnlineTrainingforEveryone 2 жыл бұрын

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!

@cathyboyd9071 2 жыл бұрын

Should formula for first question be SUMIF(B2:B12 ..... for first part and not SUMIF(B2:B11 ... ?

@OnlineTrainingforEveryone 2 жыл бұрын

Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning! kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@christinacheng5668 2 жыл бұрын

the format custom for date doesn't work on my computer

@OnlineTrainingforEveryone 2 жыл бұрын

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.

@OnlineTrainingforEveryone 2 жыл бұрын

Thank you again for watching and leaving a comment as well. Please check out my other videos kzfaq.info 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!

@aifosagarrazil1362 Жыл бұрын

I can get the iffuntion for jason

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@jobharath2812 Жыл бұрын

Peter, I like when you spaz out and do the thumbs up weird stuff 😂😜😁👌🏽🔫

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@jobharath2812 Жыл бұрын

@@OnlineTrainingforEveryone it is my pleasure. Keep up your very good work. It has helped me immensely 🙏🏽🕉🔥

@rhodambabila3312 Жыл бұрын

2

@OnlineTrainingforEveryone Жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@AlexMar-r Жыл бұрын

I know how to do all this , how much am I looking to get paid?

@margaretmcvey9858 Жыл бұрын

I turned down the speed of the speaker. I am NOT a speedo. A little slower?

@OnlineTrainingforEveryone Жыл бұрын

Very sorry it's too fast for you Margaret, however please keep in mind that the speed of KZfaq 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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@claremountfort2691 3 жыл бұрын

B2:B12 rather? Why C2:C12 and not B2:B12?

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@dakoitcave817 6 ай бұрын

Easier way to Auto Filter.-->Highlight the column headers you want to use filter feature on--> Data--> Filter. Done.

@oracam437 3 жыл бұрын

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.

@OnlineTrainingforEveryone 3 жыл бұрын

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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@sawaimalhi8439 3 жыл бұрын

where is Source Files sir??? please provides links

@OnlineTrainingforEveryone 2 жыл бұрын

Thank you again for watching and leaving a comment as well. Please check out my other videos kzfaq.info 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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@kjaan 2 жыл бұрын

great video but your constant ads are very annoying. We don't need to see your add after every answer.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?query=excel Many other great videos are also available here kzfaq.info 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!

@totallywired2723 2 жыл бұрын

Example questions and answers very useful but the number and frequency of interruptions is enough to prevent me watching more of your videos.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html Please look at the rest of my videos as well - lots of great and helpful information in each and every one of them. kzfaq.info You can also check out my website for extra materials that would help you 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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@user-arunsingh 6 ай бұрын

B

@mattbarber2923 2 жыл бұрын

Great questions but this could have been 20 minutes shorter.

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.infosearch?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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

@jennifermcdonnell8388 2 жыл бұрын

I was charged twice for the ebook and cannot find who to contact about this.

@OnlineTrainingforEveryone 2 жыл бұрын

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 KZfaq user name but there's nothing there. However, I do see two identical transactions. Please let me know and we'll refund it. Thanks!

@jennifermcdonnell8388 2 жыл бұрын

@@OnlineTrainingforEveryone THANK YOU, IT'S JENNIFER TYNDALL.

@frankstared 2 жыл бұрын

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.

@MrMocniMax 3 жыл бұрын

you sound so much Turkish ;-)

@OnlineTrainingforEveryone 3 жыл бұрын

You think so? Great to know - I wish I spoke Turkish! Good luck!

@MrMocniMax 3 жыл бұрын

@@OnlineTrainingforEveryone Wow, I was sure that you're Turkish citizen

@OnlineTrainingforEveryone 2 жыл бұрын

I'm not :) Thank you again for watching and leaving a comment as well. Please check out my other videos kzfaq.info 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!

@OnlineTrainingforEveryone 2 жыл бұрын

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 kzfaq.info/get/bejne/hdZgfseW0tPJj6s.html other videos Many other great videos are also available here kzfaq.info 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!

Ең жақсы KZfaq

How to Pass Intermediate Excel Employment Test: Questions and Answers

Пікірлер: 266