Você Passaria Neste Teste de Excel? 10 Exercícios Básicos para Entrevista de Emprego

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: https://excelentejoao.com.br/sejaexce... 🔵SPREADSHEET: https://excelentejoao.com.br/wp-conte... 🟠CONTACT: (12) 99147-6030 - Questions, Problems and Suggestions. - If you are already a student of the course, tell me your "full name" and your "email". Then just send us your question/problem/suggestion. 🙏🤝 In this free Excel video lesson, we will learn how to solve more than 10 basic Excel exercises to practice using a complete production spreadsheet, with product registration, production line records and more than 100 lines of data. The idea is to simulate a practical Excel test that might appear in a selection process. You can try solving each exercise on your own and then follow the step-by-step solution. During the test, we will work with important Excel tools for the job market, such as formatting, formulas and calculations, VLOOKUP function, IF function, data validation, drop-down lists, conditional formatting, and pivot tables. The spreadsheet represents a company with different products and production lines. Using the code of each product, we use VLOOKUP to automatically retrieve information such as product name, category, unit, unit cost, etc. Then we perform calculations to analyze the estimated total cost. This video can help those who are starting out with Excel, want to practice with real exercises, are preparing for a job interview, need to take an Excel test in a selection process, want to improve their resume, or want to learn Excel in a practical way. Before watching the solution, try pausing the video and solving each activity on your own. At the end, compare your answers and see what you already know and what you still need to improve. Comment on how many exercises you were able to solve without help and which one was the most difficult. #ExcellentJoão #Excel #Dashboard