How to Pass Intermediate Excel Employment Test: Questions and Answers
ฝัง
- เผยแพร่เมื่อ 3 มิ.ย. 2024
- Refresh your Microsoft Excel skills and learn how to get ready for Intermediate Excel Assessment test with this video tutorial.
Download Top 50 Excel Test Questions PDF eBook: www.howtoanalyzedata.net/zcmg
[Practice Microsoft Office Assessments]
Practice Excel Assessment Test - The Complete Guide: www.howtoanalyzedata.net/fz3z
Practice Microsoft Word Assessment Test: www.howtoanalyzedata.net/ucmz
Practice PowerPoint Assessment Test: www.howtoanalyzedata.net/9ul8
Download Microsoft Office Assessment Value Pack PDF eBooks: www.howtoanalyzedata.net/gmo4
[Excel Test Resources from our Trusted Partner -JobTestPrep]
- Intermediate Excel Assessment Test [JobTestPrep]: www.howtoanalyzedata.net/fz3z
- Advanced Excel Assessment Test [JobTestPrep]: www.howtoanalyzedata.net/en6d
- Prepare for Employment Assessment Test [JobTestPrep]: www.howtoanalyzedata.net/jobt...
[Career Fit Test]
- Discover Your Work Personality Strength and Best Careers for Yourself [CareerFitter.com]: www.howtoanalyzedata.net/gk3i
[Learn More About Excel Assessment Tests]
Practice Hiring Excel Assessment Test: www.howtoanalyzedata.net/top-...
Top 20 Pre-Employment Excel Test Questions: www.howtoanalyzedata.net/top-...
____
LETS CONNECT:
TH-cam: www.howtoanalyzedata.net/youtube
Facebook: www.howtoanalyzedata.net/face...
LinkedIn: www.howtoanalyzedata.net/link...
TikTok: www.howtoanalyzedata.net/tiktok
Email: www.howtoanalyzedata.net/email
Instagram: www.howtoanalyzedata.net/inst...
Become a Fan: www.howtoanalyzedata.net/store
Donate: www.howtoanalyzedata.net/patreon
Other Recommended Video Tutorials:
• How to Pass Excel Asse...
• How To Pass Advanced E...
• A Real-Life Excel Test...
• Excel Test for Job Int...
• 5 Excel INTERVIEW Ques...
• How To Pass Microsoft ...
• How to Pass Excel Job ...
[Other Employment Assessment Test Resources]
- Free and Premium Employment Assessment Test Resources: www.howtoanalyzedata.net/6fbo
- Employment Assessment Test Ebooks [EBooks Store]: www.howtoanalyzedata.net/eboo...
- Employment Test Preparation Resources [JobTestPrep]: www.howtoanalyzedata.net/jobt...
[Buy More - Save More - Assessment Test Packs]
- Employment Assessment Test Preparation eBooks Pack: www.howtoanalyzedata.net/fwi2
- Microsoft Office Employment Assessment Test Preparation Pack [Download PDF Ebooks Bundle]: www.howtoanalyzedata.net/gmo4
LEGAL DISCLOSURE:
_______
Copyright © 2022 Online Training for Everyone LLC. All rights reserved.
This training content was created by Online Training for Everyone LLC or it’s subsidiaries and hired contractors for illustrative purposes only to demonstrate fictitious data, ideas and facts from the public domain related to the presented concepts. Actual user experience with the described system and content may be different and may not resemble described content - viewer discretion is advised.
This training content is provided on an "AS IS" "AS AVAILABLE" basis without any express or implied warranties of any kind, including but not limited to any warranties of title, merchantability or data accuracy.
Online Training for Everyone LLC and it's affiliates make no warranty that:
a) The materials are error free, complete, reliable, or current
b) Defects will be corrected
c) The results obtained by the use of the demonstration components of this material will reflect the actual results obtains by the use of Online Training for Everyone LLC products and/or services
This training content may contain the trade names or trademarks of various third parties, and if so, any such use is solely for illustrative purposes only. All product and company names are trademarks(TM) or Registered(C) trademarks of their respective holders. Use of them does not imply any affiliation with, endorsement by, or association of any kind between them and Online Training for Everyone LLC.
The commercial use, reproduction, modification, storage in a retrieval system or retransmission, in any form or by any means, electronic, mechanical or otherwise, for reasons other than personal use, is strictly prohibited without prior written permission from Online Training for Everyone LLC.
#ExcelTest #AssessmentTest #EmploymentTest #AptitudeTest #Psychometrictest #interviewtest #IQTest #OnlineTrainingForEveryone - แนวปฏิบัติและการใช้ชีวิต
![[TH] 2024 PMSL SEA GF D3 | Summer | มาร่วมเป็นพยาน กับวินาทีแชมป์!](http://i.ytimg.com/vi/JCYvEsFlwx8/mqdefault.jpg)
Recently I completed an intermediate excel test sent by the employer. The test was 30+ questions, set up by SkillCheck and it was a software simulation test (the worst kind, imo). To my surprise, about two thirds of the test was pretty simple and straight forward. It was comprised of copying and pasting cells, formatting and saving worksheets. The more difficult questions were about creating a formula to multiply different cells, creating slicers and a couple more formula questions. Hope this helps anyone taking these tests during the interview process.
Did you pass and get the job?
@@Sushihead I passed the test but took another job.
Is it monitored in any way?
@@mohddilshad5025 I don't think there was any monitoring of the assessment that I took with the exception of how many questions i answered correctly or incorrectly, of course. I don't think it was monitored for time or anything like that.
If I hear "now let's continue and get ready for excel interview and assessment test" one more time ima cry
Thank you for watching, Zach, and leaving a comment with your honest feedback as well. I stopped doing this in my new videos since I do read the comments and take them seriously. Please check out my newer videos
th-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
@@OnlineTrainingforEveryone your video was very helpful thankful! I was just joking around
I even started saying it.. 😂
Overall very helpful video
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
🤣🤣🤣
Great video - my only issue is the frequent stops asking us to subscribe to your channel :(
Thank you so much for this video! This is amazing! Will help me for my interview
You are absolutely wonderful! :) Thankfully, I clicked "pause" and tried each task for each question that you asked and, luckily, I already knew most of these. That said, I must admit... I have thoroughly enjoyed watching this video! I love your teaching method & the way you go about explaining things! I have no doubt this video has helped a lot of people out. One thing that I'm most concerned with is that I know nothing about the test that I am getting ready to take (which is what lead me to your video) so even though I have been working in Excel for many years and am usually the "go-to" person at work anytime anyone has Excel questions and I've built many super awesome spreadsheets for folks that are actually still being used to this day, I still get so nervous before taking assessment tests, so I'm a bit worried that there will be trick questions or perhaps multiple methods of gathering the same info or arriving at the same answer, that I'm scared I'll get a question wrong that I actually would have gotten correct if I was working on an real Excel spreadsheet! lol Nevertheless, I do feel much more comfortable about testing my skills now that I've worked alongside you, while watching your video! And I'm super excited that I got nearly all of your questions correct. :) Thank you so much for your assistance! I'm definitely going to subscribe to your channel & follow you for more Excel tips & tricks!! 100% =D Thanks again & have a wonderful week!! 🤓🙏
Thank you very much for your hard work for this wonderful informative video!
Great videos and easy to follow, learnt so much from them
Thank you for making Videos to educate us and prepare for interview. May God Bless you !
This is great! Your pace and how you have formatted each example really is class!
Glad you liked it! Thank you for watching and leaving a kind comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Another fantastic video. I love your excel for employment video too. This is the best tutorial for intermediate excel!! It’s empowering, and I really appreciate it. 🙏
I truly enjoy your videos.
Thanks Elsien! Glad you like them - hopefully they are helpful as well! All the best on your job interview and assessment test!
You are doing such a great service. God bless you.. ❤From south africa 🌍
Thank you, it is very concise and informative. Priscilla
Vadim is a great instructor! All the Excel tricks were understood and applied easily!
Thank you very much for your kindness AM ! Happy New Year! How's the learning in the new year going for you ? Thank you for watching and leaving a comment as well. Please check out my other newer video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for posting these test questions and tips. I had just one evening to prepare for the intermediate word and excel tests; i've been watching your youtubetips for 5 hours straight and passed both tests on "skills" after being out of school for over 15 years. Спасибо, прекрасный темп речи, произношение и воодушевляющие комментарии.
I found this very helpful. Thanks so much!
Please keep learning!!!!
This is the greatest guide…thanks so much
Glad you think so! Thank you for watching and leaving a kind comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Good to know the subtle difference between substitute function & Replace.😀 Thank you!!
You're very welcome! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
This is so great!!! thank you so much!!
You're so welcome Shannon! Thanks for watching! Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Great video
Thank you for sharing your knowledge. Much appreciate it.
Glad it was helpful!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Very good, thank you!
Glad you liked it Kristina! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
This is great!
Thank you for watching and leaving a kind comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for the great way to teach this valuable content!
My pleasure Antonia and thanks for watching! Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Hi, love the videos. It would also be great if you demonstrate what all the other options would do to the data as well. Thanks!
Thanks for the idea! Great point! Please check out my other tutorials - perhaps you'd find something there that wasn't covered in this video. Good luck!
th-cam.com/users/OnlineTrainingforEveryonevideos
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thanks for your time and energy. I appreciated the video.
My pleasure!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for these informative video's. Very, very helpful!
Glad you like them! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for getting to the point so fast. So many other channels talk and talk before they get to the teaching. I really appreciate the way you cut to the chase.
Thank you for watching Anita and leaving such kind comment as well. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
A good extra tip about text to column is that this is a great way to convert a column of text to numbers. You don’t even need to create another column. Highlight the column with numbers formatted as text, then run through all of the steps of text to columns without choosing anything which means you are going to stay in that one column since you only have the one number per cell. The magic of text to columns is that numbers become numbers so just by running through text to columns your whole column is numbers as numbers.
If your text is the result of a formula you can use NUMBERVALUE to convert the result of that formula to a number 😊 so if you extracted text before/after delimiter and want the result to be number. The text to columns track wood actually show the text of your formula hee hee
Thank you for the great summary I am getting ready for an interview tomorrow!!!
presentation and info are really nice thank you
Glad to help! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
So happy I saw this post, good job, God bless you
Thanks for watching Olaitan ! Please check out my other videos - lots of great information there as well good luck in your journey! Please never stop learning! Keeps you employed and helps you to advance your carrier. All the best!
th-cam.com/users/OnlineTrainingforEveryonevideos
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this helpful video. This was a great refresher for me. I purchased your Microsoft course bundle through your website, and I look forward to learning more.
You're very welcome Stacey and thank you for watching, the purchase and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
million thumbs up. thank you ❤️
Glad it helped! Cyn G! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I used to have a co-worker who changed my excel work (yearly end closing) and sabotaged me. She refused me to do password protection. I ended up losing my job because of her. Its important to do password protection if your excel work is shared to other people...
I'm very sorry this has happened to you Josephine! Thank you very much for sharing your experience with everyone! You're absolutely correct about password protecting your work. Hope everything will work out for you. Please keep us updated on your journey. Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you so much sir.
Most welcome Jamal! Thank you for watching and leaving a kind comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this
My pleasure Kat! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
This video was amazing and very helpful
Glad you think so Kristy! Thank you for watching and leaving such a kind comment as well. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for the extra materials if needed
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Excellent learning
Glad you think so! Most welcome 😊 Thank you for watching and leaving a comment as well. Please check out my newer video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
Many other great tutorials are available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Glad to hear that! I'm really glad you liked it! Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
Many other great tutorials are available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for sharing your invaluable knowledge with everyone.
My pleasure Prafful Sharma! Thank you very much for your kind words! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
@@OnlineTrainingforEveryone When I can, in future, I will make sure to give back. Thank you.
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Excellent presentation. style is difficult things made easy
Glad to help! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you! 😀
You're welcome Danielle! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I'm grinding for a job interview I have tomorrow and thought I would just shoot a comment out to say hello. I'm subbing strictly on the no-nonsense description of your content, which aims to help people like me find the job they want. Thanks for helping us all out and wish me luck tomorrow!
Did you get the job?🍀🤞🏾
ive been using excel for years and I could say im really proficient with it. But seeing your videos about excel really opened new prespectives on how dynamic this software really is and your videos taught me things that I havent even thought of using before. Keep up the with the videos mate :) Really really really appreciate it
Thank you very much for watching Vashvon and for leaving such a positive comment! It's greatly appreciated when my humble expertise is recognized. Means a world to me and inspires me to work harder so I can help my dear viewers!
Please check out my other Excel videos - and let me know what you think about those tutorials. Thanks again for watching and please don't ever stop learning - keeps you employed and allows you to advance your carrier.
Good luck in your journey!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you !!!!!!!!!!!!
You're welcome Irina! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here including the apptitude questios
th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you , I am trying improve my excel programming. You know how to reach student with simplicity but very professional at high level.
Great to hear that! 😊 Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I had an employment test today for word and excel. I watched 2 videos on word and 2 videos on excel. I passed both tests! Thank you so much for these videos. They really really helped me.
Is it the tosa test?
Could you help me cheat I'll pay you
There videos are SO helpful. I am currently applying for jobs that require Excel tests and this is definitively helping me along. Thank you.
Glad it was helpful! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
in sumif function example , why did you use B2:B11 instead of B2:B12. thank you
Thank yoooou for video my dear
My pleasure Mayar 😊 Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I am excel beginner, but its really wonderful and beneficial class, thank you Vadim.
Glad to hear that! You're very welcome! Thank you for watching and leaving a comment as well! Please check out my new video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank u
Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
thnx sir for providing that awesome content
It's my pleasure Arshi! Thanks for watching Please check out other Excel videos - perhaps you'll find them helpful. Good luck in your learning journey!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You're very welcome Arshi! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you sir for these useful videos which are so so much helpful for students and jobbers like us.keep it up.subscribed and downloaded as well.love from India.
You're so welcome Jayeeta! Thank you for watching and leaving a comment. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for your interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Today I have an excel assessment. Thank u so much for the assistance.
You are most welcome! Good luck!
How did the interview go? Any tips?
Thank you again for watching and leaving a comment as well. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this detailed video sir, much appreciated 🙏🏽💯👌🏾! And shoutouts to the Brewers and the Mil! Are you a fellow Milwaukean??
Yes I am and feel blessed living in such a great city! Go Brewers, Bucks, and Packers :) Thank you very much for watching Diva! Please make sure to watch my other video tutorials on this topic and my other helpful video tutorials - lots of great information there. The more prepared you're the easier it is to find the right position or do whatever you're already doing more efficiently.
th-cam.com/users/OnlineTrainingforEveryonesearch?query=aptitude
You can also check out my website for any additional information you might find helpful. Good luck in your journey and please don't ever stop learning - knowledge keeps you employed and helps you to advance your carrier to the new heights!
www.howtoanalyzedata.net/resources/
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Super session sir ❤
Thanks for the tutorial , I have an assessment to take and my excel knowledge is limited. I no some of the basics. I still am not sure I am ready for the assessment; however, I think your video will help.
You are welcome Dolphine! Glad you liked it and I'm sure you'd do great! Try to prepare as much as you can - it always helps to pass. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for this! Even though my hiring manager only gave me until next day to complete & I'm pretty much at beginner level and rusty. 😑
You got this! Thank you for watching and leaving your comment as well. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
So helpful could you please explain to me the importance of macros and where they are applied
Thank you very much for taking time to leave a feedback and ask a questions.
Using Excel Macros can speed up work and save you a lot of time.
If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.
Excel Macro Examples:
Unhide All Worksheets at One Go.
Hide All Worksheets Except the Active Sheet.
Sort Worksheets Alphabetically Using VBA.
Protect All Worksheets At One Go.
Unprotect All Worksheets At One Go.
Unhide All Rows and Columns.
Unmerge All Merged Cells.
Save Workbook With TimeStamp in Its Name.
Good luck in your learning journey!
Why did only use the range B2:11 when solving the Jason SUMIF question? Why didn't you add B12 in the range when you included C12 in the range to get the answer?
Most likely just an error on my side - I'm not perfect :) Just trying to do too many things on my own and all by myself
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for these. Can I ask if the same commands and shortcuts are applicable to Mac PC/laptops and yes I do have Microsoft 365? I'm about to have the exam and it's been over a year since I was last employed and hence lacking in confidence though I have been using excel for over 20 years for just regular tables - no pivots. graphs, or complicated comparatives.
You're so welcome Lili! Very sorry just seeing your comment -somehow TH-cam was hiding it from me. How is your Excel learning going and thank you again for watching & leaving a comment as well. Have you been able to find the job ? Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I am wondering which questions might be tested in excel assessment for purchasing analysis position. Where could I download it? Thanks
Now I believe that there is much more to learn
ALWAYS!!! Great point!!! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Question, We just have to answer the choices or also solve the same on computer?
You could use Flash Fill instead of Concatenate.
Great point Rachid! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Easier way to Auto Filter.-->Highlight the column headers you want to use filter feature on--> Data--> Filter. Done.
I found this video after struggling in an interview where all the questions were on excel🙂
I have a series of number, but i want to add prefix number to the series of number, so how do i Auto the prefix. For example 975544 i want to add 080 to the front of the different series of numbers. What formula do i use?????
Hi, I am sorry I didn't get your name. I am following your videos these days, which I find very instructive, to prepare for a test which is a one day exam (excel is one of the thinks I will be tested for). So my question is what kind of excel test questions do you think we can get for a 24 hour test? I was told that for all the parts of the exam the time to work on it would be about 3-4 hours, so I guess for excel only is one hour. But as i said I have a day to hand in the exam. Thank you very much for any suggestion.
My name is Vadim. Glad it was helpful Simona! Please feel free to watch my other video tutorials when you get a chance to learn even more as all my videos are geared toward helping people to get employed and stay there
th-cam.com/users/OnlineTrainingforEveryone
you can access Excel videos here
th-cam.com/users/OnlineTrainingforEveryone/search?query=excel
It's hard to say which exactly questions you'd be getting so just try to prepare as much as you can as it's usually much easier to pass tests when you're ready for them and know what to expect. Good luck! Just be cofindent! Don't panic! Everything will be great, but please don't ever stop learning as knowledge is the best investement anyone can do. Thanks for stopping by!
@@OnlineTrainingforEveryone Thank you Vadim
Anytime Simona! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
i have formatting interview test tomorrow
How did you test go Josy? Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
It would have been good explain why there is a random 0 at the end of the Index & Match string.
microsoft holds a world excel championship.
You're welcome Stewart! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
for the 1st example, wouldn't it be from B2, B12? instead of B11?
Exactly... My take as well.. But all the same we are grateful to you sir ❤❤❤
What is the name of your website sir? I really want to download the PDF file. A huge help for me💯
www.howtoanalyzedata.net/resources/
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Hello. In the very first question the sumif range was b2:b11. Why is it not b2:b12? I'm not an expert at all so honestly just trying to understand....
I think it's because the last Jason ended at B10 so he just added one more to make it b11. He could've actually ended at b10 though.
Split to Column not working for me. My version ask for destination cells, which I provided, but names not showing in separate columns. Please advise.
Sorry just seeing your comment. You probably have an older version of Excel. You need to update it and then all the features I discuss in my tutorials will be available for you as well. Hope it makes sense. How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I have an Excel and Word employment tests coming in 1 day, I have been studying but there are too many thins to learn in short time, need help.
Just try to watch as many videos as you can. Perhaps, change the speed of the video to accomodate your learning style. You can visit my website and see if you find anything there that might be helpful for you. Just be confident and do try to prepare - the more prepare you're the more confident you'd be while taking the tests thus the better the end result. You got it! Good luck!
www.howtoanalyzedata.net/resources/
Thank you again for watching and leaving a comment as well. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
37:35 my outcome states that it’s 18/10/2109 I’ve gone over and over what you’ve done but this is always the end result, anything I’m doing wrong?
on the substitute function you put SUBSTITUTE(A1,%," ")..... are we supposed to literally type ALL of that exactly in that form? and then I assume hit "enter"? or just click onto your next column? I've never used excel really and I have a test for probations this weekend which im quite positive will have these types of assessments and I'm praying to God it doesn't.. or praying I pass if it does.. helllllp. so confused on that SUBSTITUTE(A1,%," ")
2
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I can get the iffuntion for jason
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
how can I download practice examples
Great job!!! Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I know how to do all this , how much am I looking to get paid?
Download Top 50 Excel Test Questions PDF eBook: www.howtoanalyzedata.net/zcmg
[Learn More About Assessment Tests]
Practice Hiring Excel Assessment Test: www.howtoanalyzedata.net/top-50-microsoft-excel-interview-questions-and-answers/
Top 20 Pre-Employment Excel Test Questions: www.howtoanalyzedata.net/top-20-microsoft-excel-test-questions/
Hm, the commands shown in the video do not work in my XLS. Why?
Example questions and answers very useful but the number and frequency of interruptions is enough to prevent me watching more of your videos.
Thank you for watching and leaving a comment with your opinion! I greatly appreciate that! Please check out my newest video - no interruptions there and let me know what you think - really hope you'd give it a try
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
Please look at the rest of my videos as well - lots of great and helpful information in each and every one of them.
th-cam.com/users/OnlineTrainingforEveryone
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey! Keep on learning please! Knowledge helps you to advance your carrier and your life to the new heights!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
32.12 the answer is text to column but you first say 'the answer here is split to columns' that's confusing...i suppose is a mistake?
Thank you very much for watching and for pointing it out Sabina!!! I'll need to look into this. Please make sure to watch my other video tutorials - lots of great information there and I add new ones regularly. Good luck in your journey!
th-cam.com/users/OnlineTrainingforEveryonevideos
Yes. You first mention Split to Column and later on answer is text to column. I got confused there.
Thank you. You're videos are helpful.
Very sorry for confusing you!!! I do everything myself so errors do happen - hope you understand. I'm not perfect just trying to be but as you can see not very successful :) How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Peter, I like when you spaz out and do the thumbs up weird stuff 😂😜😁👌🏽🔫
Thank you for watching Jo and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
@@OnlineTrainingforEveryone it is my pleasure. Keep up your very good work. It has helped me immensely 🙏🏽🕉🔥
the format custom for date doesn't work on my computer
I'm very sorry Christina it's not working for you! Please try doing the following and let me know if it helped. Thanks!
elect the date column.
Go to the Data-tab and choose "Text to Columns".
On the first screen, leave radio button on "delimited" and click Next.
Unselect any delimiter boxes (everything blank) and click Next.
Under column data format choose Date.
Click Finish.
Thank you again for watching and leaving a comment as well. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
When I try CTRL + ;, it shows the current time, rather than current date. Anyone know how to change it?
how to delete a pre-marked table in excel?
If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here's how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete. Please let me know if it helped. Thanks 4 watching!
B2:B12 rather? Why C2:C12 and not B2:B12?
Most likely a typo Clare - I'm just a human. Very sorry for confusing you! How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
B
Should formula for first question be SUMIF(B2:B12 ..... for first part and not SUMIF(B2:B11 ... ?
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You are doing fine work but please do more closeups/body-shots/movements of yourself to keep the pace energetic and dynamic. Also use extreme high res. Thanks again and keep up the equality work.
I turned down the speed of the speaker. I am NOT a speedo. A little slower?
Very sorry it's too fast for you Margaret, however please keep in mind that the speed of TH-cam videos can be modified by using the video settings in the bottom right corner of each video. There are multiple options for you to choose from. Hope it helps but please feel free to reach out with any of your suggestions - I greatly appreciate the feedback my viewers provide.
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great questions but this could have been 20 minutes shorter.
Thank you for watching Matt and leaving an honest comment as well. I'll look into this video. Please check out my other videos on Excel
th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Your formula on first example does not work on Excel 2013. I created the same worksheet and my result is 0. What am I doing wrong?
Please upgrade your Excel - 2013 version needs to go :)
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Appreciate your work in putting out these videos. But there is tooooooo many interruptions on top ot the adds someone has to look at. :.( Sorry, it takes up too much time.
I'm very sorry for the interaptions! Please watch my other videos - I stopped doing it as I do listen to the feedback my viewers provide. Thank you very much for giving it another chance!
Just wanted to let you know that I listened and my newer videos don't have interruptions, so I hope you'd give me another chance. How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I liked and subscribed to your video but when I saw the 5th like and subscribe beg button i removed it
Thanks for your feedback! Unfortunately I can’t update the old videos but definitely will use different approach in the new videos. Hopefully you will reconsider about subscribing 😀! All the best on your job interview and assessment test!
where is Source Files sir??? please provides links
Thank you again for watching and leaving a comment as well. Please check out my other videos
th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
How is your Excel learning going and thank you again for watching & leaving a comment as well. Please check out my newest Excel video and let me know what you think about it
th-cam.com/video/Op0Kdemme_w/w-d-xo.html
other videos
Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
Lots of great and helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!