How to Pass Excel Employment Test In Less Then 15 Minutes
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2024
- The Microsoft Excel Assessment Test is a standardized evaluation tool designed to measure an individual's proficiency in using Microsoft Excel, a widely used spreadsheet software application.
Practice Excel Assessment Tests: www.howtoanalyzedata.net/how-...
By understanding the nature of the Microsoft Excel Assessment Test and adopting effective preparation strategies, job seekers can enhance their Excel skills and increase their chances of success in the recruitment process.
Download Practice and Completed XLSX Source Files used in This Video: www.howtoanalyzedata.net/uqbl
******* IN THIS VIDEO: ********
________
00:00 Expand data to ensure all data is visible on the screen
01:01 Merge cells above the value columns in the row with the header
01:23 Center "Sales" title, Make it Bold and Change Font to size to 14
02:01 Indent all values in Sales Categories to the right
02:15 Add Borders to the data table
02:36 Format all values as currency
02:52 Change font in Row 5 to bold and select gold background
03:12 Center the values in Row 5
03:32 Insert new column between March and April and calculate Q1 Sales
03:58 Add another column next to June and calculate Q2 Total
05:18 Add additional Column and Calculate Total Sales by Category
06:30 Using the formula determine highest sales number in Row 12
07:21 Using the formula find 2nd highest sales value in Row 13
08:12 Using the formula determine smallest Sales
08:55 Using the formula identify 2nd smallest sales
09:31 Resize values in sales data columns to reduce empty space
10:20 Calculate Grand Total Sales for each month
10:54 Calculate total # of monthly sales records greater then $200
11:43 Calculate the sum of all sales with sales greater then $300
12:18 Prepare Print Preview to fit sales data only on landscape page
Prepare for an Assessment Test: www.howtoanalyzedata.net/1eb0
Download FREE Sample Employment Assessment Test Questions (PDF eBook): www.howtoanalyzedata.net/0fyb
_______
TEST YOUR SKILLS and KNOWDEGE (Free Assessment Test Questions):
Test Your Skills with Daily question on TH-cam: www.howtoanalyzedata.net/yout...
Test Your Assessment Test Skills with Free Daily Question: www.howtoanalyzedata.net/
Receive Regular Email Updates: www.howtoanalyzedata.net/email
_______
FREE AND PREMIUM PRODUCST AND SERVICES TO HELP YOU:
Download Ebooks: www.howtoanalyzedata.net/eboo...
Free and Premium Job Interview, Hiring Assessment Test and Technology Resources: www.howtoanalyzedata.net/6fbo
_______
BECOME A FAN (THANK YOU for your support and patronage of Online Training for Everyone!):
Merchandise Store (Branded Online Training for Everyone Products - Thanks for your Support): www.howtoanalyzedata.net/store
Online Training for Everyone Patreon Page (THANK YOU for your Donations and Support!): www.howtoanalyzedata.net/patreon
LEGAL DISCLOSURE:
_______
Copyright © 2021 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 #MicrosoftExcelTest #OnlineTrainingForEveryone #VadimMikhailenko #HowToAnalyzeDataNet - แนวปฏิบัติและการใช้ชีวิต
Practice Excel Assessment Tests: www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/
Practice for Pre-Employment Assessment Tests: www.howtoanalyzedata.net/assessment-test-practice-and-preparation-resources/
Download FREE Sample Hiring Assessment Test Questions (PDF eBook): www.howtoanalyzedata.net/0fyb
@@OnlineTrainingforEveryone Thank you so much for sharing. Is there is way I can contact you.
I watched this video twice and then took an assessment for a temp agency and scored "Strong Knowledge" with 67%. If I had paid more attention to the video I probably would have scored closer to 80. I have never used Excel before in my life. I just have general knowledge of using Word. I also don't have a copy of Excel to practice with. I just watched the video and took some notes. Thanks!
great video but u gotta relax with the advertising, I couldnt even see what u were doing on 11:12 because of the ad.
This is great. Thank you. Well explained.
Thanks what you do really helps a lot not only to be prepared for work but also to be more effective in the work place love the video without the popups
Thank you for watching Anita and leaving a comment as well. Please check out my other videos and let me know what you think about them - 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!
Very clear and good video for learning. Actually there is no need to jump in in the middle of the course asking for 'Likes', people know what is good and bad, to avoid opposite result.
Yes, you are right! Sorry about it! I was following TH-cam suggestions but not doing it anymore. Thank you very much 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/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 will be looking at this again. I did an Excel course earlier this summer. Im so happy I did because I can follow what is going on.
Great job - keep on learning! Thank you 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 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!
Your videos are so clear, concise and helpful. Your teachings are a gift. Thank you so much for sharing your knowledge in such an easy to follow model!
You're welcome! Thank you very much for watching and leaving such a kind comment as well. Please check out my newer video and let me know what you think about it
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!
very helpful video! i appreciate your time and efforf into putting this together.
Glad it was helpful! Thank you very much 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/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 approach for conducting Excel practical interviews
Thank you for watching and leaving a kind comment as well David. Please check out my other videos 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 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 so much, it was very informative 🌺
Glad it was helpful! Thank you very much 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/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 very much!!! Perhaps the pop-up advertising can be placed prior to training and again afterwards. Nonetheless, I really appreciate how easy you made this to understand.
Glad it was helpful! Thank you for watching and leaving a comment as well! I stopped doing it in my new videos so please check them out. Hope you'd find them just as helpful.
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. This is great. Thank you so much. Your Videos have helped me alot.
Thank you for watching and leaving a comment as well. Please check out my other videos and let me know what you think about them - 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 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!
As always,its helpful. this video is clear,Everything is clear thats why its easy to understand..
Thank you for watching and leaving a comment r as well. Please check out my other videos and let me know what you think about them - 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 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 a great video, thanks
Glad you liked it Jasmine! Thank you for watching and leaving a comment as well . Please check out my newer videos and let me know what you think about them.
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 assessment test or an interview. www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Great, thanks again sir!
My pleasure AAA F! Thanks for watching! Please check out this link for all the videos I offer on Excel. Let me know if it was helpful. th-cam.com/users/OnlineTrainingforEveryonesearch?query=excell
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 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
Amazing and easy videos ...thanks a lot
Thank you for watching and leaving a comment with your kind feedback 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 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 like it👍👌....thx you sir
Most welcome Sweet Saros! 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!
Excellent..i have a job test tomorrow and this will be so helpful.Thank you sir
Wishing u success in your test
All the best Marie! Thank you for watching and leaving a comment as well. Please check out my other videos
Lots of great information in my other video tutorials that will help you th-cam.com/users/OnlineTrainingforEveryone
Really 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!
@@mondaypatrick2538 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
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 sir iam from India and i like this farmulas excel tutorial
it really help me a lot to give assessment test....Thank you so much..
You are most welcome Julia! 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!
Thanks
Welcome!!! 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!
excelent video to help me improve my excel skills😊😊
Glad to hear that! Thank you very much 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/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
thanks
You're welcome! Thank you very much 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/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
Excellent
Thank you so much 😀 Manoj Kumar 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 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!
@@OnlineTrainingforEveryone thanks
The Large and Small functions are helpful function I didn’t know about.
Using power Query automates these steps so an analyst doesn’t have to do for ever report they need make
Thank you for watching and leaving a comment with your discovery as well Piper. Please check out my other videos and let me know what you think about it
Many other video 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 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!
nice video
💛
Thanks 🤗 You're welcome! Thank you very much 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/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
Sir, during the assessment is it allowed to type the shortcut keys rather than clicking the tab menu or it is needed for recording?
Very good sir and thankyou so much sir
Most welcome Virendra! Thank you for watching and leaving a comment as well.
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 ok sir and thankyou so much sir please continue
I will : )
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!
Microsoft excel is nice one
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. 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'm second thank you very much.
Thank you Lizette for watching and leaving a comment as well. Please let me know what you think and feel free to check out my other videos - lots of useful information there - too many popups according to some viewers in some videos though as I was trying to understand what the viewers prefer - I'll get it right one day :) !
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 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!
Hi why I can't download this practise. Ask me to purchase
I done it today
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!
Excel is so cool, I wish my school made it more interesting to learn 😞
I hear you but please keep in mind that you're in charge of your future - not your school. Learn what you like and what you think will help you to succeed in life. Thank you very much 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/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
Hi sir i am going to attend an interview by next week in Deliotte company as they mentioned i have excel assesment but i have little bit of knowledge about excel can you please share the video link which can i help me too and request you please respond me what type of questions they can ask
This may help me when i am 18 , its very similar what my teacher gave us to do in class on a paper, matching the requirement
Thank you for watching Luigi and leaving a comment as well. Please check out my other videos and let me know what you think about them - 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 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!
Why is it that the 2nd highest and 2nd smallest go out several decimals when the original number doesn’t go out that far?
I have a test for a job I really want to get, I will be testing on basic Word, and intermediate Excel skills. I’m kinda worried because although I’m pretty knowledgeable with Word, I rarely use Excel. Do you guys think by studying these videos I’ll become proficient enough to pass a test?
I'll say go on some beginner and advance tutorials. These tests are really specific. They could ask u anything so its better to learn all of excel.
Thank you very much for watching and leaving a comment as well. Learning all of the Excel is a huge undertake because of all the features Excel offers today. However, you need to start somewhere and knowing basics will help you build on. Try to learn as much as possible but never stop there - always keep learning and improving. It'd help you to stay employed and to keep climbing the corporate ladder. Hope it all makes sense but feel free to ask any other questions. Please check out my newer video and let me know what you think about it
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
Please if u have psychometric qation about Insa
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!
Here I am first viewer...thank you sir for a great information.
Always welcome Sheela! What did you think about this one? I haven't had almost any popups till the very end :) Need it to make it somewhat entertaining towards the end to keep the attention and make the learning process a little more fun. Please feel free to share your opinion and don't be afraid to criticize - I'm all ears! Thanks for watching and leaving a comment as well! Please check out my other videos if you haven't done so yet
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!
@@OnlineTrainingforEveryone yes sir it is so informative and once again thank you...I continue to watch all videos ...
Thank you Sheela! Learning is fun and helps to advance our carriers and lives! So glad I can be helpful. Have fun learning! All the best!
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 I might be missing something but you say that you are going to provide a "FREE" practice file for download and the only thing that I can find will cost me $9.95. I don't mind paying a little bit but this seems pretty steep for a basic practice file. I do appreciate the video... thx
Go Cubs baby bro
Should have converted rows to currency for 2nd but great video.
And right when I write it he does it
Glad it was helpful ! It's my pleasure to help! 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/WrXuvT66mo8/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 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 did you do that quick “add column”?
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!
To quickly insert a column or row, simply click on the column heading to the right of, or the row heading just below, where you want to insert. Then you just press the Ctrl and + keys (plus sign/addition key), or you can also right-click the heading and select "Insert".
It was good and helpful but by the end I can't even see what you're doing + it is also harder to hear you. What was the point of that side video
Hello. I have been trying to download the free xlsx practice work file, but after typing my email and name, I am not able to download it. Could you please help me on what to do? 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. 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!
why u never provide any practise file for free ??
Love the videos because they are very helpful, but the popups of you trying to get us to subscribe makes it very difficult to see the formulas that you are typing into the cell. I'll still be subscribing but can you please take the popups out?
The video is great, but man the popups is very distracting when you're trying to learn.
Very sorry about the popups! Thank you for watching and leaving a comment Ba as well . Please check out my newest video and let me know what you think about it - no popups there
th-cam.com/video/WrXuvT66mo8/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 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 is helpful & thorough but the comedy video on the side dominates visual area & is distracting, might be better with some music LOL
Good training but the popup video of you was a distrastraction.
Sorry about that Martin! I stopped doing it in my new videos so hoping you'd give me another chance. Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
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!
Ple put all vedios in one place sir
Thank you for watching and leaving a comment as well. Please check out my another 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 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 these videos. The pop up through the video was not helpful in trying to see things. I would hesitate in subscribing due to that part. Consider a different approach! As many have commented the same.
I hear you and very sorry for the popups! I stopped doing it in my new videos and hoping you'd give a chance and watch them. Thank you very much 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/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
The video is created excellent but can't download the material from his website that's why further to watch next videos is just waste of time
Thank you for watching and leaving a comment as well! Why can't you download the file?
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 went too fast @3:32 without showing how to do it as throughly as you did with the previous steps
If looking for a one on one apptitude class contact
Please check out my newest video and let me know what you think about it - you'd want to checkout all my tutorials on Excel if you're getting ready for an Excel testing for your job search.
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 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!
The instructions for tasks 17, 18, and 19 only say to create totals for each MONTH, not the quarterly or annual values.
For 17, I would have simply highlighted cells C6 through C12, pressed Alt + = to Autosum, pressed Ctrl + C to copy the formula, then held down Ctrl and clicked on each of the five monthly total sales cells, and hit Enter.
Your course is good. However, as I started in one of your other videos, PLEASE STOP appearing on the right side of the screen with the thumbs up message as it is a distraction! This is annoying and will make me not return to see any more of your videos. Please find another way to get people to subscribe and click the like button.
Stopped doing this Lori! 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!
@@OnlineTrainingforEveryone I’m impressed with how you responded. Lori could have simply asked nicer rather than threatening to stop watch your videos like if that’s gonna stop your bread . It’s okay sir everyone else is watching🙂
@@OnlineTrainingforEveryone you said that last time and didn’t. So weird to add that distracting pop up
@@thepressureofaname5643it’s his channel, he can do what the hell he wants to do. Show gratitude.
@@akansk8tz if you want better engagement you need better videos. And I can comment whatever I like - he should take criticism on board like a grown up. Unlike you
Sir i need your paid course free
Please sir
Thank you for watching and leaving a comment with your request as well. Please reach out to me via my website with the details why exactly you need it for free. Please check out my newest video and let me know what you think about it
th-cam.com/video/gVBRcMut82A/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 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!
Why do you want to show up in the middle of your videos? It distracts the people who watch your videos and try to learn something.
Very sorry about it Ruth! I stopped doing this! Thank you for watching and leaving an honest 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!
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!
Этот тест на умсвенно отсталых расчитан?)
Please don't interrupt the training with jokes. Thanks
The photo popping in and out of this lesson is very distracting. Please stop doing that!