La herramienta de EXCEL que TODO PROFESIONAL deben conocer.

👩‍💻 👇 BE PART OF THE NEW GENERATION OF EXCEL EXPERTS Register now and secure exclusive benefits: 👊🤓 https://smartprosoluciones.com/ ________________________________ Flash Fill is the tool that EVERY PROFESSIONAL should know. What does it do? It automatically fills data when it detects a pattern, allowing you to do so many things in such a SIMPLE way that you'll think it's magic 👍😅. For example, you can use Flash Fill to separate first and last names in a single column, or combine first and last names from two different columns, or even repair dates that Excel doesn't recognize because they're in the wrong format, etc. This tool is available from version 2013 onwards. 👍😁 00:00 INTRO 01:01 EXAMPLE #1: Convert to UPPERCASE. 03:42 EXAMPLE #2: Split the content of a column into one or more columns. 04:47 EXAMPLE #3: What to do when the pattern isn't being picked up correctly? 06:40 EXAMPLE #4: Create a new column based on the content of one or more columns. 08:59 EXAMPLE #5: Create a new column based on the content of other columns and additional content. 10:01 EXAMPLE #6: Get the day, month, or year from each date. 11:19 EXAMPLE #7: Correct dates that are plain text in Excel to the correct format. 👍😁 If you'd like to download the video file to practice, you can download it at the following link: https://smartprosoluciones.com/la-her... Did you like it? Support us with a LIKE 👍 and Share to share this knowledge with your colleagues 👍😀. --------------------------------------------------------------------------------------------------------- LET'S STAY CONNECTED! 😁: Instagram and Facebook: @SMARTpro Academy ► Instagram:   / smartproacademy   ► Facebook:   / smartproacademy   --------------------------------------------------------------------------------------------------------- Would you like to know your current Excel level? Take our free test: https://maraton.smartprosoluciones.co... Want to take your Excel skills to the next level and stand out from the crowd of professionals? https://smartprosoluciones.com/ ----------------------------------------------------------------------- 💡💻 Get the Microsoft 365 version of Excel: https://click.linksynergy.com/fs-bin/... 🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...