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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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.
Glad it was helpful! Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great to hear! 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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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.
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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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
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!
😊 Thank you for watching and leaving such a detailed comment as well Jayne. Loved reading it! Please check out my other videos ru-vid.com Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it was helpful 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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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.
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 ru-vid.com 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 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 :)
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.
@@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
Great to hear this! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ru-vid.comsearch?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!
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.
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 ru-vid.comsearch?query=excel Many other great videos are also available here including the apptitude questios ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well Sheila. Good luck on your interview. Keep us posted on how it goes. Please check out my other videos on Excel ru-vid.comsearch?query=excel You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
How 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com 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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html other videos Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you very much. 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
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WrXuvT66mo8.html Many other great tutorials are available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about it ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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.
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You got this! Please check out my other Excel videos that should be helpful as well. ru-vid.comsearch?query=excel Be confident but do prepare as much as you can. Good luck and please let me know how it goes. Thanks!
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!
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
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!!
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!
@@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
How is it going Kay? Please check out my newer videos and let me know what you think about it ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com 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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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. ru-vid.comsearch?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/
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WrXuvT66mo8.html Many other great tutorials are available here ru-vid.com 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!
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! ru-vid.comvideos
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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).
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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!!!
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. ru-vid.comsearch?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/
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You got this! 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! ru-vid.comvideos
You are welcome Katarina! Thank you for watching and leaving a comment as well. Please check out my newest and other videos ru-vid.com Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com 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!
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
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!
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 ru-vid.comsearch?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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You are 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 ru-vid.comsearch?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!
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
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! ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for watching and leaving a comment as well. I do use the latest version of Excel. Please check out my other videos on Excel ru-vid.comsearch?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!
Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ru-vid.comsearch?query=excel This link will show you videos on lookup ru-vid.comsearch?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!
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 ru-vid.com 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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great video 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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it was helpful Ruth! Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You are 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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
My pleasure! 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. ru-vid.comvideos
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
You are most welcome Pepen! 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html I also offer many other very detailed videos ru-vid.com Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
So 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 ru-vid.com or ru-vid.com/search?query=excel
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad to hear that! 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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching Sanvitha 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! ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
You are welcome, Maridel! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ru-vid.comsearch?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!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com 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!
lets take few second time to like and subscribe his channel at least he is educated enough to spread lovely tips and tricks for us ,god bless us everyone
Thank you for watching and leaving a comment as well! Love your user name! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I 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
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad you think so! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com 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!
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! ru-vid.comsearch?query=excel
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! 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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com 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!
Happy to help Zara! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ru-vid.comsearch?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!
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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com 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!
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?
Thank you Mr. Vadim for video that is very helpful. Some of those are I do not know before. Would like to learn more about tests on data. Some years ago, I got test to answer seem like to analyze data based on sheets that include a lot of group, un-group and subtotal data (+) & (-) Actually, I was frustrated by that kind of sheet and I could not answer. But I keep in mind it that I will learn at one day. Hope you would help me.
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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. ru-vid.com 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 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!
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 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!
No doubt you know how to use excell, but as data analyst I have to say 1 crucial error I see there, it's to automatically say that the miss written zip codes are missing a 0...there so many variables that that's incorrect! Might be missing a 0 at the start, might be missing a 0 at the end, might be a typo in the DB! I would specify that to the interviewer somewhere and then continue the exercise specifying what is my approach to the issue, possible approaches are: 1. I supposed it just misses the first 0, so that's my evaluation and correction. 2. Cut and paste the raws where the missings are and insert them in a descriptive chart as "incorrect data - needs validation" or something like that. If you're applying at a job where excell use is required probably it has to do with analysis or data visualization or economic/financial/market reports, all those fields not only require excell knowledge (which can be acquired excell is such a simple software), but analytic mindset is probably even more important, that's why I think THAT specific error would cost you even more that an error in exporting a pivot table. For all the rest nothing to say great way if general explanation, I see a lot of questions also about vlookup and if functions tho 😊✌🏻
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Thank you for watching Vladimir and leaving your comment as well! Please check out my other videos ru-vid.com You can also check out my website for other extra materials www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for the free tutorial videos! I am still trying to familiarize the software but your videos are the only concise and clear I could ever find. You're channel is awesome!
Glad to help Gykka Marie! Thank you very much for your kind words! 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great tutorials are available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You're very welcome Deepak! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ru-vid.comsearch?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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com 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!
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.
Glad it helped! 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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I bought the author's pdf that provides the reader with test question samples. It costs about $10.00 and offers much more in depth questions than are provided here. It's great, thank you.
Thanks for sharing this info Jayne! Thank you for watching , making a purchase, and leaving a comment as well. Please check out my other videos ru-vid.com 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!
First of all, I love your videos so far. I have only watched 3 or so far. Just seeing what Excel questions are generally asked nowadays to see if I am out of touch with the current standards. I noticed your column letters get replaced with your column headers. That was neat and I haven't seen it before, would you mind showing me which setting enables that?
Great question Lawrence! Thank you for watching and leaving a comment with your question as well. Please check out my newest video and let me know what you think about it ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html other videos Many other great videos are also available here and you should find an answer to your question in one of them ru-vid.com 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!
:) Love your comment! 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 ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad you think so! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ru-vid.comsearch?query=excel Many other great videos are also available here ru-vid.com 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 Thanks a lot for your tutorials. I accidentally came to your page to check my level and stopped for a long time. Lots of useful and helpful information.
Thanks for watching Elaine and for answering! Please check out my other videos ru-vid.com 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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Glad you liked it! Please stay tuned - more Excel Videos are coming with the new features. Don't ever stop learning! Keeps you employed and helps you to advance your carrier. All the best!
Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
Glad it was helpful CE! Thank you for watching and leaving a comment as well. Please check out my other videos ru-vid.com 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!
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Op0Kdemme_w.html Many other great videos are also available here ru-vid.com 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!