Thank you, Vadim. I've watched a handful of your videos in the last few days of preparing for my interview. To be honest, I've been sceptical about coming back to them, but I took a chance on this one. I must say I appreciate that you take feedback from your audiences. This was a whole lot less distracting. Thank you. And I just subscribed. I hope to come back for more and also testify to how your tutorials contributed to my success. Cheers
Up to date i am still grateful for this video i stumbled upon the day i was doing my interview aptitude test, i watched and learned and guess what? the very day i learnt it, is the day i wrote it exactly the way it is here and i passed the interview.Thank you so much!!
Thanks. Your instructions e.g. "How to move the data set 3 cells..." does not require a question mark, as it is not a question. If you said,"How do you move the data set 3 cells..." it would require a question mark, as it is a question.
Great point! Thanks for pointing it out to me and 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 ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
about 1:54. Instead of Using Form there is also the Possability to create a Table (Strg + T) this Keeps the Layout and Allows the @ operator, automatic Filter etc...
For the 'Math Grade question' you should've used a 2nd MATCH to find the right column instead of hardcoding it to 2. And about unhiding... there can be sheets that have the "very hidden" flag that Excel wont show; those would only be visible (and its status changed) in the VBA editor.
Great to hear that! 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 ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a kind comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching Andrewsd and leaving a comment as well! Many different companies require an Excel assesment to be completed by their perspective employers thus I can't simply answer your question. Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Practice Microsoft Excel Assessment Test www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/
Download FREE Sample Hiring Assessment Test Questions (PDF eBook): www.howtoanalyzedata.net/0fyb
Thank you, Vadim. I've watched a handful of your videos in the last few days of preparing for my interview. To be honest, I've been sceptical about coming back to them, but I took a chance on this one. I must say I appreciate that you take feedback from your audiences. This was a whole lot less distracting. Thank you. And I just subscribed.
I hope to come back for more and also testify to how your tutorials contributed to my success. Cheers
Up to date i am still grateful for this video i stumbled upon the day i was doing my interview aptitude test, i watched and learned and guess what? the very day i learnt it, is the day i wrote it exactly the way it is here and i passed the interview.Thank you so much!!
Thank you, this was very clear and well spoken and I really enjoyed learning with you.
Thanks. Your instructions e.g. "How to move the data set 3 cells..." does not require a question mark, as it is not a question. If you said,"How do you move the data set 3 cells..." it would require a question mark, as it is a question.
Great point! Thanks for pointing it out to me and 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
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
about 1:54. Instead of Using Form there is also the Possability to create a Table (Strg + T) this Keeps the Layout and Allows the @ operator, automatic Filter etc...
The best formula for serial number is =row()-1 in case the specific row is 2 to get the serial number 1.
Sir
Good day. Thank you for making this video tutorial it is much helpful to me as beginners
Thank you Vadim!!
For the 'Math Grade question' you should've used a 2nd MATCH to find the right column instead of hardcoding it to 2.
And about unhiding... there can be sheets that have the "very hidden" flag that Excel wont show; those would only be visible (and its status changed) in the VBA editor.
Amazing it was very helpful!!
Great to hear that! 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
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Very helpful demonstrated very well . Thank you.
Amazing!!! Thank you!
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
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Very nice explanation👌👍
We can also use 'Offset' formula to retrieve the value in the row with ID=7.
Was helpful
First task... SEQUENCE + COUNTA
Thank you...can we use sumif function instead of match then index ??
Thanks
Glad you liked it! All the best on your job interview and assessment test!
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
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Very informative, as I doing along with excel, thanks for all the great tips
what job
Thank you for watching Andrewsd and leaving a comment as well! Many different companies require an Excel assesment to be completed by their perspective employers thus I can't simply answer your question. Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
The now function is =now()
😍😍😍
This is terrible all your cuts out of excel is so confusing with your animations poping up every few seconds
Exactly am even annoyed 😂
❤mashLh.hn.rapiy.haku.parakeyo