7 trucos avanzados de Excel que necesitas saber para conseguir trabajo

Check out our online Excel course 👇 https://a2capacitacion.com/bundled/Ex... 🤩 Discover all our courses! https://a2capacitacion.com/ 👉 Visit our blog: http://blog.a2capacitacion.com 📁 File to work with: https://a2capacitacion.com/Archivos/Y... CHECK OUT THE WORST EXCEL MEMES ON OUR SOCIAL MEDIA! 😎👇 ► Instagram:   / a2excel   ► Facebook:   / a2capacitacion   ► TikTok:   / a2capacitacion   Job interviews can be an intimidating process if you're not prepared, especially when they ask you to take an Excel test on the spot. That's why you need to know these 7 essential Excel tricks to impress your interviewer and land that job you want. In this video, we'll cover the following advanced Excel tricks: 1. Drop-down Lists – Learn how to create validated lists! It's not the most important, but it's definitely the most impressive. 2. Inserting Rows – Guys, you'll look like a pro when you learn how to select, insert, and delete rows and columns all at once using the keyboard in Excel. We'll use the shortcuts Ctrl + Enter, Ctrl + Space, Ctrl + "+", and Ctrl + "-" on the Excel keyboard. 3. Text to Columns – This is Excel's most underrated tool. Text to Columns in Excel lets you fix the "number saved as text" error and correct dates in unusual formats. 4. AutoSum with Keyboard – Quick but powerful, AutoSum in Excel saves you a lot of time. 5. Remove Duplicates – Removing duplicates in Excel lets you identify unique items in a list. 6. Flash Fill – Available since Excel 2013, this feature lets you use artificial intelligence in Excel to separate first and last names. 7. Transpose – A fundamental tool, you need to know this to fix flipped tables in Excel. Transposing in Excel is very simple. That's it! Memorize these 7 advanced Excel tricks (and learn how to apply them) and you can pretend to be the Excel God you always wanted to be.