This Excel feature helps me make better decisions (and avoid regrets) www.makeuseof.com/what-if-analysis-feature-in-excel-for-better-decisions/ Goal Seek – Find out how you can reach your target Scenario Manager – Compare your best case, worst case, and most likely scenarios Data Tables – Test dozens of possibilities in seconds
Seguir leyendoAutor: Hans Le Roy
Once you understand SCAN in Excel, you’ll never build formulas the same way
Once you understand SCAN in Excel, you’ll never build formulas the same way www.makeuseof.com/understand-scan-in-excel/ SCAN function – Microsoft Support support.microsoft.com/en-us/office/scan-function-d58dfd11-9969-4439-b2dc-e7062724de29 LAMBDA function – Microsoft Support support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67
Seguir leyendoThis one Excel symbol will change how you write dynamic array formulas
This one Excel symbol will change how you write formulas www.makeuseof.com/excel-symbol-change-how-write-formulas/ Dynamic array formulas and spilled array behavior – Microsoft Support support.microsoft.com/en-au/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531 Excel Dynamic Array; A Beginner’s Tutorial | GoSkills www.goskills.com/Excel/Resources/Excel-dynamic-arrays#:~:text=Excel%20has%20introduced%20a%20spill,D5%20with%20the%20expression%20D2%23.
Seguir leyendo«These 5 Excel dashboard tricks would have saved me hours as a beginner»
These 5 Excel dashboard tricks would have saved me hours as a beginner www.makeuseof.com/excel-dashboard-tricks-for-beginner/ Pivot Tables – Summarize thousands of rows in seconds without formulas Pivot Charts – Visualize your Pivot Table data with one click Helper Sheets – Keep raw data and complex calculations off the main dashboard view
Seguir leyendo«I stopped getting lost in giant Excel sheets when I found these two features»
I stopped getting lost in giant Excel sheets when I found these two features www.makeuseof.com/stopped-getting-lost-in-giant-excel-sheets-when-found-these-features/ Watch Window – Keep key cells in sight, no matter where you scroll to A watch window placed beside a list of names on an Excel spreadsheet. Custom Views – Reset your sheet instantly
Seguir leyendo5 hidden functions in Google Sheets that Excel still doesn’t have: ISEMAIL and ISURL; COUNTUNIQUE; IMPORTFEED, IMPORTHTML, IMPORTRANGE, and IMPORTXML
5 hidden functions in Google Sheets that Excel still doesn’t have www.makeuseof.com/hidden-functions-in-google-sheets-not-in-excel/ ISEMAIL and ISURL – Data validation made simple COUNTUNIQUE – Instant unique value counting IMPORTFEED, IMPORTHTML, IMPORTRANGE, and IMPORTXML – Live data at your fingertips ARRAYFORMULA – Dynamic arrays that actually adapt
Seguir leyendoThese two Excel functions make stacking data from multiple sheets too easy: VSTACK and HSTACK
These two Excel functions make stacking data from multiple sheets too easy www.makeuseof.com/these-excel-functions-make-stacking-data-from-multiple-sheets-easy/ VSTACK – For data that needs to be ready for analysis HSTACK – Best for side-by-side comparisons
Seguir leyendoIgNobel 2025, vuelven los premios más locos de la ciencia
IgNobel 2025, vuelven los premios más locos de la ciencia | WIRED es.wired.com/articulos/ignobel-2025-vuelven-los-premios-mas-locos-de-la-ciencia Vacas pintadas como cebras, la pizza favorita de los lagartos y una historia de 35 años sobre el crecimiento de las uñas. Física: La salsa cacio e pepe perfecta Nutrición: Lagartos y una pizza de cuatro quesos
Seguir leyendo«I haven’t had malware for over a decade, and it’s all thanks to these 6 simple tricks»
I haven’t had malware for over a decade, and it’s all thanks to these 6 simple tricks www.makeuseof.com/ways-i-avoided-malware-for-10-years/ Think twice before you click «Download» – Free software isn’t always free Keep your antivirus up to date – Windows Security has excellent built-in protection against malicious apps Always be skeptical about
Seguir leyendo«I didn’t know these Excel functions existed, but now I can’t live without them»
I didn’t know these Excel functions existed, but now I can’t live without them www.makeuseof.com/i-cant-live-without-these-excel-functions/ 5 TEXTSPLIT – Breaks apart text that’s stuck together 4 TEXTJOIN – Combines multiple cells into one 3 CHOOSECOLS – Selects specific columns from your data 2 TAKE and DROP – Extracts portions of your
Seguir leyendo