How To Pass Advanced Excel Test For Job Interview

[@OnlineTrainingforEveryone]

Practice Microsoft Excel Assessment Test www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/

[@jeremyholland4527]

Today I took an excel proficiency test. Because I was able to review with your content and familiarize myself with excel I was able to pass the test with a 94%. Thanks you for the awesome content! Liked, commented and subscribed!

[@OnlineTrainingforEveryone]

Excellent! Thanks for letting us know and congrats!!!

[@ga-tz4bp]

can you plz share the test link, i also want to give the test. Thankyou

[@robynministeri8062]

This is great you are a great speaker and teacher. You are so easy to follow you keep me motivated and that’s not an easy job

[@OnlineTrainingforEveryone]

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

[@josemor420]

have my test in 2 hours. wish me luck

[@OnlineTrainingforEveryone]

Best of luck Jose! Please let me know how goes -thanks!

[@nirvation1137]

How did it go bro?

[@OnlineTrainingforEveryone]

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

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

[@Rollacoastertycoon]

?

[@sharlenefjones]

I have been intimidated with Excel for years but this video has given me confidence and calm to give it a good go. You are a stand out teacher and I am enormously grateful for your videos but this one in particular.

[@OnlineTrainingforEveryone]

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

[@johnsonsmili9324]

i am looking for jobs and every time i had to pass through excel skill test hope after rigorous learning with all your sessions on youtube i will testify my victory in some time future.

[@OnlineTrainingforEveryone]

You got this! Please check my other video tutorials - theres lots of information that should help you to go through the interview processes with the flying colors. Don't stop learning as knowledge and development increases your chances of employment drastically. Thanks again for taking time to leave your feedback and good luck in your learning journey!

[@OnlineTrainingforEveryone]

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

[@jaynefranzinoromero1640]

I took an Excel test online and the questions were almost exactly the same questions you've posed here. However, I didn't understand the questions, for the most part. However, I'm coming to understand the lingo of Excel testers. I enjoy working with this software immensely. : )) To create a zip code that has a "0" (zero) in front of the zip, as in Connecticut, zip codes start with "0", such as 06798, for example. To do this you highlight the cell you want to put the zip code in, then go to Home tab, then to Number (aka data type), then hit pull down box, scroll down to and click onto "More number formats" , scroll and hit "Special", then hit Zip code. Phew! What an Easter egg hunt!

[@OnlineTrainingforEveryone]

😊 Thank you for watching and leaving such a detailed comment as well Jayne. Loved reading it! Please check out my other videos kzbin.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!

[@sreelekshmireveendran2666]

Yesterday as a part of skill test I got questions like Basic formulas Conditional Formatting Pivot Table Lookup Vlookup of large datas from different sheets and workbook

[@asherpaul2185]

The best Excel lesson I've seen on KZbin.

[@OnlineTrainingforEveryone]

Glad to hear that JP! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@bereniceandrews3083]

this was incredible! I wasn't even interested in in learning excel. I just watched it because i was bored at work. Now I'm hooked! Thank you!

[@OnlineTrainingforEveryone]

Great to hear! Knowing Excel is really helpfu! It's a great tool and I hope you'll find how to use it to optimize your efficiency! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@cmckay889]

You even put the time stamps for each section.. You are amazing! Thank you for making this :)

[@OnlineTrainingforEveryone]

Glad you like them! Thank you very much for a kind feedback! Good luck in your learning!

[@OnlineTrainingforEveryone]

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

[@MANiiWAVE]

I have an interview and used this for refreshment . Totally informational and very easy to understand. I thank you for making these videos x

[@OnlineTrainingforEveryone]

Glad it was helpful Imani! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@pizzazzjackson635]

Hello you asked for information that tests asks. Here is a description of what an assessment I had to take required. The Spreadsheets with Microsoft Excel module measures your ability to navigate and modify an Excel workbook, visualize trends and patterns using conditional formats and standard charts, analyze data, and create reports using PivotTables and PivotCharts. Your performance on this module demonstrates your skill in Spreadsheets with Microsoft Excel by sorting and filtering options as well as statistical functions; customizing the look and feel of a workbook using cell formatting tools; writing cell formulas to evaluate conditional statements; combining data from multiple worksheets; manipulating fields formatted as dates, values, or text; and nesting multiple functions together to create dynamic formulas.

[@IAMADWEBSTER]

Thank you very much for investing your time into such a helpful Excel video.

[@OnlineTrainingforEveryone]

Thanks A.D. Webster. Really appreciate your comment. It was a lot of work, but I was motivated with the though of helping other. Thanks for leaving the comment!

[@OnlineTrainingforEveryone]

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

[@tikajenna]

I have an advance excel assessment today. I'm trying to remember everything in here but all I can hear is " we can now mark this step as complete" wish me luck 🤪😜☺️😁.... Btw Thank you for the great work. You make it easy to understand. You helped me pass my intermediate excel assesment

[@tikajenna]

So I ended up failing cuz these mofos gave me the same intermediate assessment I had passed a few months ago. I forgot everything because I didn't need to use excel. Ugh! Nonetheless Great job on your tutorial!!

[@OnlineTrainingforEveryone]

I'm very sorry to hear it Kay! Please don't be to upset - sometimes when one door closes another one opens, so perhaps it was meant to happen. However, the lessons is hopefully learned here - try to find time to refresh what you already know. In today's world the amount of information we have to process is unreal! Our brain just puts some things on back burner in order to manage everything else. Please keep me in the loop and let me know where your journey will take you. Good luck and best wishes Kay!

[@tikajenna]

@@OnlineTrainingforEveryone Aww thank you so much for your message of encouragement. I completely agree that one door closes another opens. I will definitely continue learning from your videos that have been so been well explained. Thank you ao very much

[@OnlineTrainingforEveryone]

How is it going Kay? Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@johnmuigai1163]

You are a hero. Got hired after going through this. Perfect video

[@OnlineTrainingforEveryone]

Huge Congrats John on getting hired! So happy for you and your success! Please keep us posted on how it's going. Thank you for watching and leaving a comment with your answer as well. Please check out my newest video and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk other videos Many other great videos are also available here kzbin.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!

[@ayodelemuniru9405]

I learnt a whole lot considering i have been using excel for over 10 years. Wow!!!

[@OnlineTrainingforEveryone]

Great to hear this! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzbin.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!

[@skybluealice9643]

I have an excel interview tomorrow for analyst position. Thanks a lot for making this video.

[@OnlineTrainingforEveryone]

Good luck Alice! You got it! Please let us know how it goes. Thank you for watching and leaving a comment as well. Please check out my other videos kzbin.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!

[@skybluealice9643]

@@OnlineTrainingforEveryone I passed the exam. Thanks a lot for your effort in making this video. Will check out on your other videos to learn more about excel :)

[@anon12416]

I have an interview this Friday for an analyst position as well… what questions were you asked during your interview in regards to excel?? I was told I would have to a demonstration/test.

[@skybluealice9643]

@@anon12416 Hi...I'm so sorry I reply you a little bit late. But yeah it was a demostration exam. Anyway, how was your interview? I hope everything's good from your side

[@kirstiecampbell4000]

Many thanks. I utterly bombed an Excel test and got a good lesson in just how much I don't know.

[@OnlineTrainingforEveryone]

Oh bummer - sorry to hear that! Please get ready for the next time- I have other videos on this topic. Make sure to check them all out! Good luck!

[@ahmedal-wattar5624]

Any videos demonstrate the LOOKUP? Thanks

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzbin.infosearch?query=excel This link will show you videos on lookup kzbin.infosearch?query=lookup 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!

[@rcd954]

Taking an excel assessment for employment tomorrow. This is very helpful. Thank you

[@OnlineTrainingforEveryone]

Glad it was helpful! Best of luck! Please let me know how it goes - thanks!

[@OnlineTrainingforEveryone]

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

[@joyebot7371]

Thank you very much. I was looking to calculate my annual expenses in a monthly manner, so see how much fund I spend on different stores. And this was what I needed to get things rolling

[@OnlineTrainingforEveryone]

Glad it was helpful Joy! Thanks for sharing your experience! 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 kzbin.info/www/bejne/jaO7pqmKa5ugpZo Many other great tutorials are available here kzbin.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!

[@joyebot7371]

@@OnlineTrainingforEveryone thank prof, I won't hesitate to do so. Muchísimas gracias!!!🙏🙏👌👌

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@kamarasiakarifa6359]

Thanks very much,I have been watching many videos base on excel but yet still my level of understanding was below 50% but since I started watching your videos for the past week now am proud to say that i am at the level of 50% of understanding. I would like to request from you to please help me have more questions and how I can submit the answers to you for corrections. I really love the mode of your presentation which is backup by questions and steps,it really boosts my confidence in excel as a beginner.

[@lindailori1421]

hello. do you have any videos on monitoring performance in excel?

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

[@sheilairenecrystalmbabazi3799]

I have an interview on Thursday and I think this is making it more easy for me. Thanks for this awesome Video

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well Sheila. Good luck on your interview. Keep us posted on how it goes. Please check out my other videos on Excel kzbin.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]

How did the interview go? Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@adlaialmeida9815]

Excellent , was not expecting a power pivot in this video, extremely useful.

[@OnlineTrainingforEveryone]

Glad to hear that Adlai! Thank you very much for watching! 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. kzbin.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]

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

[@galaxycurls3919]

Loved It! Thank you! It refreshed me and I learned new things. I will be applying for a Financial Analyst job somewhere and they are already sending me excel tests.

[@OnlineTrainingforEveryone]

Glad it was helpful! Thank you for watching and leaving a comment as well! Keep learning! Please check out my other video tutorials on Excel and let me know what you think about them kzbin.infosearch?query=excel Many other great videos are also available here including the apptitude questios kzbin.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!

[@carlingas666]

At work I use excel. I use pivot tables, text to columns and basic formulas (ad, subtract, divide and multiply) I need to further my knowledge.

[@OnlineTrainingforEveryone]

Thank you for watching Carlos 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! kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@virginiaschmidt6062]

In a recent interview macros was a question for excel experience.

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

[@olgaivashenko8580]

On my last interview I had two tasks in Excel one was for usage of Vlookup and second one to customized formatting.

[@OnlineTrainingforEveryone]

Thank you very much for sharing your experience Olga! How did it go? Thanks!

[@OnlineTrainingforEveryone]

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

[@mariannapsyllou7908]

Thank you for all the help :) Went from 0 to 100 saving my money!Amazing job

[@OnlineTrainingforEveryone]

Glad I could help!

[@OnlineTrainingforEveryone]

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

[@mahiradolan4160]

One of the simple and useful video for excel learning. Thanks a lot! I hope you can make more videos in future.

[@OnlineTrainingforEveryone]

Thank you very much for the kind words! Please check out my other tutorials. Good luck in you learning!

[@OnlineTrainingforEveryone]

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

[@sylviamendoza6316]

This is wonderful! I finally get the chance to learn Excel. Thank you, so much!!

[@OnlineTrainingforEveryone]

Wonderful! My pleasure Sylvia! Thank you very much for your kind feedback! Please make sure to check out my other video tutorials - I add new materials regularly. Please never stop learning as it'd keep you employ and will help you to advance your carrier. Good luck! kzbin.infovideos

[@OnlineTrainingforEveryone]

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

[@teerealistic6325]

This is the training I needed for my interview assessment

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

[@sylviakamvumuleja1334]

I have an excel interview in few hours. Thx a lot

[@OnlineTrainingforEveryone]

Best of luck! Please let me know how it goes. 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@feriala.616]

very practical and clear instruction, hope to pass the test with a good percentage GRACE to this video, thank you

[@OnlineTrainingforEveryone]

Glad it was helpful! Good luck on your test! please let me know how it goes

[@OnlineTrainingforEveryone]

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

[@ashkanarshad2896]

Hi, could you please tell me how you filtered it by month, it does not show up on my pivot table.

[@paolavalles2377]

Very well explained, complete and to the point. I also like that content is split by intermediate and advanced exercises, so you can check your progress. Subscribed and liked of course, thank you! Keep them coming!

[@OnlineTrainingforEveryone]

Awesome, thank you! Love getting feedback from my viewers! Good luck in your learning journey!

[@OnlineTrainingforEveryone]

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

[@johnsonsmili9324]

i will continue to follow your study i am sure i will learn all techniques of Excel and will be efficient in excel . thanks a lot u are great help.

[@OnlineTrainingforEveryone]

You are most welcome! Please check out my other video tutorials - lots of useful information that will help you to learn. Good luck!

[@ontheroadwiththelord3159]

Thank you for this! Will be having my exam tomorrow. Please pray for me🙏❤️

[@OnlineTrainingforEveryone]

You got this! Please check out my other Excel videos that should be helpful as well. kzbin.infosearch?query=excel Be confident but do prepare as much as you can. Good luck and please let me know how it goes. Thanks!

[@kimeudennis8464]

This is a very educative tutorial,thanks for this sir God bless you

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

[@elisalopez5372]

THANK YOU SO MUCH!!! This is pure gold. Of course I'm subscribed and I liked!!

[@OnlineTrainingforEveryone]

Thanks for the sub Keli!

[@OnlineTrainingforEveryone]

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

[@ashanndalama4770]

Very nice ; but I have problem on how to work with pivot table’ I need help

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well! I have videos on how to work with Pivot tables - hopefully, you can find answers on your questions. Please check out my other video tutorials on Excel and let me know what you think about them kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@LubnaNaz-b2p]

would really appriciate if you can upload a video of ICDL database/access level 3 diagnostic

[@michaelvanna8982]

Hello, with my experience with IKM, SKILLSET, i did not encounter any of your examples esp from the download where we have to pay. We can discuss further to share my experience with IKM...i passed their advanced excel assessment but your youtube can still be improved and helped those who take IKM provided testing. Tnx

[@OnlineTrainingforEveryone]

Congrats Michael for successfully passing the advance excel assessment! It's huge! Thank you very much for your message and sharing your opinion as well! My goas is not necessarily to give my viewers the exact questions & answers in every single video, but help them prepare for the job interview and the ultimate goal is to get the job. Many think of Excel as a very scary beast and are afraid to touch it or don't believe they can specify it on their resume as one of the skills they poses. I'm very proud that my tutorials have helped people to refresh their knowledge, learn something new, get some hands on activities, and feel more confident with Excel and other available tools. Many has confirmed that they were able to pass the assessment test with the help of my tutorials. One of my favorite cases is when a person who worked as a deli clerk for many years has learned MS Office and Excel through my videos and was able to get a new job with much better pay. Stories like this one where someone's life was transformed keep me going and inspire to create better tutorials. I'm a huge believer that knowledge helps us to get better jobs, keep our employment, and enhance our carrier paths, which ultimately means better life for ourselves and our families. Thanks again for reaching out with your offer! We all would love to hear what your experience has been like if you're open to sharing it. The best way to contact me is through my website contact page. Congrats again on your success and best of luck in your journey!

[@turialennon1318]

You're a great teacher! I will refer to this video in the future! Thank You!

[@OnlineTrainingforEveryone]

Awesome, thank you!

[@OnlineTrainingforEveryone]

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

[@chessjugrant1311]

Your fantastic! Mahalo! Salamat! Gracias! Thank you so much for your knowledge!

[@OnlineTrainingforEveryone]

My pleasure! Glad it was helpful! Thank you very much for watching and your kind words! Please make sure to watch my other video tutorials - lots of great information available there. Please keep learning as it'd help you to stay employed and enhance your carrier. kzbin.infovideos

[@OnlineTrainingforEveryone]

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

[@waynehopwood]

Toward the end, there are a couple steps that say "using Power Pivot." But they don't actually show Power Pivot; it's just a regular pivot table. Power Pivot isn't even one of his menu items, which suggests it's not even installed on his system. Did I miss something? Great videos overall, just disappointed PP was missing (but correct me if I'm wrong).

[@ndelpurg]

these test videos are a great learning device I thank you keep it UP !

[@OnlineTrainingforEveryone]

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

[@moeedahmed4964]

Hi! I couldn't figure out how in the question where we had to check for sales by month using power pivot, how do we add the months column in our pivot table?

[@OnlineTrainingforEveryone]

Good question!

[@1dasefx]

@@OnlineTrainingforEveryone I missed that part too...

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@brettsimpson3048]

Great video and great speed for a refresher or warm-up before an interview. I appreciate your clearness and conciseness in providing useful and relevant information. The only advice (thing that bothers me with your videos) is the consistent "thumbs up" drop-in. No need to do that, your content is great and a simple/single reminder for that "like" would be quite sufficient. Well done and thanks for showing multiple ways of accomplishing similar tasks! KUDOS!

[@OnlineTrainingforEveryone]

Thank you for watching Brett and leaving an honest comment as well! I stopped doing this in my new videos so hoping you'd give my tutorials one more chance. Please check out my other video tutorials on Excel and let me know what you think about them kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@kirstenbeyoncepadthai]

Thank you so much for all your help, Vadim! You are an angel!!! 🙏

[@OnlineTrainingforEveryone]

Glad I could help Kirsten!! Thank you very much for your kind words ! Thank you for watching and leaving a comment as well. Please check out my other videos kzbin.info You can also check out my website for extra materials if needed that will help www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@robynministeri8062]

You are a great speaker and teacher. You are very easy to follow and for me that’s not an easy job. You have been a great help for me and I am so glad I found you,because everything is coming back to me again. Without your help it would have been such an uneasy task.Thank you so much for your help! Going to keep watching!!!

[@OnlineTrainingforEveryone]

Wow, thank you so much Robyn for your kind words! Means a lot and inspires me to work harder so I can keep helping people find themselves during such difficult time for everyone. Please make sure to watch my other video tutorials on this topic and 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. kzbin.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]

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

[@tiffanybell1154]

What if when you are separating the names Into separate columns they have multiple names or names that need to be kept in just the first or second column. When I tried this it created extra columns with each space, is there a trick or tip to get around it without going into each long name?

[@teressaladyofsteel9305]

This was a great 👍 video thank you. I learned alot of valuable functions.

[@OnlineTrainingforEveryone]

Thanks Teressa! Appreciate the feedback. All the best on your job interview and assessment test!

[@OnlineTrainingforEveryone]

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

[@abdidekmuhumed4510]

The most useful in excel , Thank you dear of dears

[@OnlineTrainingforEveryone]

You are most welcome Abdi Dek Muhumed! 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 kzbin.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!

[@irena9574]

Vadim, a big thank you for this video. The map function was extremely useful.

[@OnlineTrainingforEveryone]

Glad it helped! Grateful for your positive comment and liking the video! Your support is truly appreciated. Good luck on your job interview and assessment test - continue your journey of improvement and reaching for your goals!

[@paulmakin3007]

A question on a recent test was to profile the expected cash recipts over the year based on the exact date. The first receipt was 10th of Feb 2020 10,000 per month . So one formula that covers the pro rata receipt due in Feb and then then the full value in every other month of the year.

[@priyadas2406]

Hi sir thanks for the video...but am not been able to find my geography data ribbon in my excel, please help.

[@OnlineTrainingforEveryone]

Hello Priya, Can you please make sure you have the latest update?

[@OnlineTrainingforEveryone]

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

[@katarinasojakova2610]

Thank you Vadim for a simple and fast explanations!

[@OnlineTrainingforEveryone]

You are welcome Katarina! Thank you for watching and leaving a comment as well. Please check out my newest and other videos kzbin.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!

[@SpazyMecgee]

On the final task, when your insert the map into the worksheet, how do you get it to only generate one of America? Mine seems to only generate a world map.

[@frankstared]

Excellent inclusion of affirmations in the backdrop; again, consider full body shots during narratives.

[@OnlineTrainingforEveryone]

Glad you liked it Frank! 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 kzbin.info/www/bejne/jaO7pqmKa5ugpZo Many other great tutorials are available here kzbin.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!

[@mihaelaturtureanu9234]

I do not like Excel. However, watching your tutorials...I started to understand it much better. These videos will help to pass any tests. Thanks a lot!

[@OnlineTrainingforEveryone]

Very glad to hear it Mihaela! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@josephinejiffur4803]

Good morning Sir, thank you , I'm a beginner and trying to learn to prepare for an interview...thank you

[@OnlineTrainingforEveryone]

You got this! Thanks for watching Josephine! Please try watching as many videos as you can as my channel designed to help people like you to find their dream job and stay employed. Please keep me posted on your progress. Good luck! kzbin.infovideos

[@kennethmontoya103]

You have helped me more than you can believe, thank you

[@OnlineTrainingforEveryone]

Happy to help- thank you very much for letting me know!

[@OnlineTrainingforEveryone]

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

[@melindalauora3049]

Many thanks for sharing your knowledge Mr. Mikhailenko, I sincerely appreciate it...

[@OnlineTrainingforEveryone]

You are very welcome! Thank you so much for taking time to leave feedback and typing in my last name 😀 It's the easiest one to type! Please check my other video tutiorials which I add regularly. There's lot of great and helpful information there. Please don't ever stop learning and good luck in your journey!

[@OnlineTrainingforEveryone]

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

[@AskMePrayer]

Your toolbar seems to have many functions. Mine doesn't not have many of these features. I wonder which year version of Microsoft excel you are using.

[@OnlineTrainingforEveryone]

Thanks for watching and leaving a comment as well. I do use the latest version of Excel. Please check out my other videos on Excel kzbin.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!

[@mariameniserije762]

Very helpful. This is the best way to teach Sir. Thanks very much Sir.

[@OnlineTrainingforEveryone]

So nice of you Mary! 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 kzbin.info or kzbin.info/search?query=excel

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@ruthm5413]

Very well thought out and organized tutorial. You make it look so easy. Thanks for creating this video!

[@OnlineTrainingforEveryone]

Glad it was helpful Ruth! Thank you for watching and leaving a comment as well. Please check out my other videos kzbin.info You can also check out my website for extra materials www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

[@OnlineTrainingforEveryone]

Thank you again for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@caragramaglia5748]

Thank you for this , this was extremely helpful, you are a great teacher.

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

[@maryarmstead6423]

I need the data to follow your course where can I locate it? I want to have the very best chance to pass my exam. Please provide direction s? Thank you Mary Armstead

[@OnlineTrainingforEveryone]

Thank you for watching Mary and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@ahlamthabet9813]

May you put this files for exercises of excel easily to be uploaded for more practice?

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

[@sinistergrinch]

I have an excel test tomorrow. This video definitely helped me to feel a little more confident and better prepared. Hopefully it goes well!

[@OnlineTrainingforEveryone]

Best of luck Goose! You got it! Confidence and preparation are the keys! Thank you for watching and leaving a comment as well. Please check out my other videos - there're many more there that will help you get ready. kzbin.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!

[@sinistergrinch]

@@OnlineTrainingforEveryone thank you so much! I will definitely check these out tonight. The position I’m applying for is a financial analyst position. I’ve heard that, typically, they focus a lot on vlookup and pivot tables. Would you recommend that I review anything in addition to those? And for those what would you recommend I do to best prepare? Your videos are incredibly helpful. Thank you again!

[@OnlineTrainingforEveryone]

You got Goose! Just try to prepare to your best abilities - preparation is the key to any successful interview and allows you to be calm and confident. The more items you'd refresh in your memory the easier your interview would seem. It's hard to predict which exactly questions you'd be getting as the questionnaires regularly change. Please let us know how it goes and feel free to share your experience when you're done! It's really helpful for others to hear how it went for someone like you. All the best!!!

[@ShawnFX]

@@sinistergrinch How did the interview go? Also did you get the job? I'm also applying to Financial Analysts positions :)

[@sinistergrinch]

@@ShawnFX interview went really well! Turned into a total of 5 interviews haha. Got the offer and accepted the position. Good luck! Wish you all the best!

[@eshwiliams]

I have a question to remove letters from the cells and leave only numbers.

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

[@timakinola458]

Please has anyone been able to download the practice file used in the video? I've looked around but I've not been able to download the file. All links don't give access to download or is there something I'm missing?

[@OnlineTrainingforEveryone]

Very sorry about that TIm! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@byrantennis5150]

Can I get a link to download the spreadsheet used in the video please.

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well Karizma. You need to check out my website for the extra materials www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

[@Straightfacts2025]

one of the best video for excel learning. simple and effective. thanks a lot

[@OnlineTrainingforEveryone]

Thanks MI Saeed. Appreciate the feedback. Thank you for spending time and leaving the comment!

[@OnlineTrainingforEveryone]

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

[@hasnulfitri2115]

my experienced during the test, the interviewer wants the participant describe the 5 tables, that provided, like what the functions that used inside in those tables .

[@OnlineTrainingforEveryone]

Thank you very much for sharing your experience! Have you been able to descirbe the tables? Did this tutorial help you? Did you feel more confident during the interview? Thanks for letting us know!

[@OnlineTrainingforEveryone]

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

[@JayaSingh96]

thank you its was very helpful!!!

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

[@VMsiDolanescu1]

You are a genius! Thanks!

[@OnlineTrainingforEveryone]

Wow, you're very kind and generous with your feedback - thanks! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzbin.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!

[@luisabelterracciano8194]

Hi Vadim, your videos are incredibly simply explained and effective! I am sorry to say I found a bit unclear how I can save the PDF from word doc. I got it I open the blank word doc and then I am lost on what exactly you click to open the pdf and save it on the word file. Many Thanks

[@pamelabagaya166]

Perfectly explained

[@OnlineTrainingforEveryone]

Glad you think so Pamela! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@NoobGamePlusGOW]

Thank you sir, this was very well explained and helpful.

[@OnlineTrainingforEveryone]

Glad you liked it

[@OnlineTrainingforEveryone]

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

[@donlalichan7764]

vlook up , sumif , count if , pivot table & charts

[@OnlineTrainingforEveryone]

Thank you for your feedback Don! Please check out my other Excel videos and I do talk about everything you mentioned. You can also visit my website for more information. Thanks for your visit and good luck in your learing process!

[@xzgameplayITA]

sir u dropped this 👑

[@OnlineTrainingforEveryone]

Thank you for watching Sean and leaving a comment as well! What do you mean by saying I dropped it? Would you please clarify? Thanks! Please check out my other video tutorials on Excel and let me know what you think about them kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@zaraazimova6853]

very useful videos. thank you soo much!

[@OnlineTrainingforEveryone]

Happy to help Zara! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzbin.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!

[@janinealexa9518]

I am learning so much from you. thank you for this helpful advanced excel tutorial 💛

[@OnlineTrainingforEveryone]

Happy to hear that Janine! Thank you very much for your kindness ! Please check my other videos on Excel. Perhaps you'll find something you like there. Please let me know if you like my other tutorials. Good luck in your journey! kzbin.infosearch?query=excel

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@vbarchild]

A good start. Thanks

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think: kzbin.info/www/bejne/haGTfJebotKYldk I also offer many other very detailed videos kzbin.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!

[@exploreruniverse3463]

19:37, how did you add the extra Pivot data ‘Month’ ?

[@thetmartar9903]

What version is the best to work on Pivot table and vlookup?

[@OnlineTrainingforEveryone]

I use the latest version as it has the most features and capabilities. What do you think about my approach? Thanks!

[@clarisaltar5612]

Thank you for every post you made. It's very useful and hope will be useful on my coming up exam.

[@OnlineTrainingforEveryone]

How did your exam go? Thank you for watching and leaving a comment as well. Please check out my other videos kzbin.info 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!

[@festus.o5003]

Great tutorial...thanks

[@OnlineTrainingforEveryone]

Glad it was helpful! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@vladimiroppenheim9214]

Thank you very much, Vadim! very helpful!

[@OnlineTrainingforEveryone]

Thank you for watching Vladimir and leaving your comment as well! Please check out my other videos kzbin.info You can also check out my website for other extra materials www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

[@jaberreyes1]

awesome.I've learned a lot

[@OnlineTrainingforEveryone]

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

[@elainekoh6724]

Learnt so much from this video :) Thank you!! Subscribed to your channel! :D

[@OnlineTrainingforEveryone]

Thanks for watching Elaine and for answering! Please check out my other videos kzbin.info You can also consider checking out my website for more options if you're interested www.howtoanalyzedata.net/resources/ Good luck in your journey! Please don't ever stop learning! Keeps you employed and allows to advance your carrier to the new heights.

[@OnlineTrainingforEveryone]

Thank you for watching Elaine and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!

[@gajendrablaze2532]

can you explain this assignment

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel to understand this assignment and let me know what you think about them kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@ArringtonAET]

Is there a downloadable practice sheet

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

[@andrei2126]

9:30 great function, BUT, in Belgium we have a lot of Last names in 2 parts, like Ivan Van Hooghe, so if I do like you says, it create 3 colomn, BUT i need the "Van Hooghe" in same colomn... How do that??? Bol'choe spasibo zaranie ;)

[@jgeur]

there's probably an easier way but the first thing that came to my mind was....combine the columns with the two last names using the concatenate function, =concat(). here's an example: Van Hooghe =CONCAT(E4," ",F4) Van Hooghe. Van in cell E4, Hooghe in cell F4, the "(space)" puts a space between the two names. then copy the new, combined cells and paste as value (to remove the formula) and then delete the columns with the two last names. i hope that helps. best wishes.

[@khaingshwezinmyint5664]

Thanks a bunch.

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

[@foodlovers8423]

Really appreciate your efforts

[@OnlineTrainingforEveryone]

Glad you think so! 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 kzbin.infosearch?query=excel Many other great videos are also available here kzbin.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!

[@bonnieeyde6443]

I need to due a case study that company already did and review it and format it.

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

[@deepakpillai9981]

An excellent video. Made my day was very easy to understand and practice. Very many thanks 🙏🏻

[@OnlineTrainingforEveryone]

You're very welcome Deepak! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzbin.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]

Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it kzbin.info/www/bejne/haGTfJebotKYldk Many other great videos are also available here kzbin.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!