#ExcelProTips

🌟 ¡HOY VIERNES 20 DE SEPTIEMBRE! 🌟 No te pierdas esta oportunidad de aprender técnicas clave para sorprender a los reclutadores. ¡Nos vemos! 🚀✨ 📅 Hoy 🕘 21:00 (hora Ecuador) 📲 ¡Solo en TikTok! #ExcelEntrevistas #ExcelProTips #AplicandoExcel

Wow, that sucked. Just had an Excel spreadsheet with toxic equations in it. These were equations where I copied 50 columns into new cells, but fixing them or deleting them was impossible. It would think just forever.

I managed eventually after 10 reboots of Excel to delete exactly 1 column. I had to wait 30+ minutes for Excel to come back to do that one. One multiply later and I realized that I needed a different solution (that didn't involve open-heart surgery on my Excel file in XML)...

Finally figured it out: make a new spreadsheet, copy all the formats and questions into the new one without the toxic equations, switch all the references in the rest of the sheet, and delete the offending cursed sheet. Now you know. #Excel #ExcelProTips

Gaining #excelprotips and learning about #pivottables from the very best. 🤓 Thanks, John McLeod, for an awesome training today at @neohospitals! #thecenterofitall