We need to talk about the LAMBDA function in Excel www.makeuseof.com/we-need-to-talk-about-the-lambda-function-in-excel/
Seguir leyendoCategoría: EN
Zoomers are officially worse at passwords than 80-year-olds
Zoomers are officially worse at passwords than 80-year-olds • The Register They can probably set up a printer faster, but look elsewhere for cryptography advice www.theregister.com/2025/11/18/zoomer_passwords/
Seguir leyendoThis tiny symbol in Excel changes everything (and most people ignore it)
This tiny symbol in Excel changes everything (and most people ignore it): @ www.makeuseof.com/tiny-symbol-in-excel-changes-everything/
Seguir leyendo«My 6 favorite Excel features that almost nobody talks about»
My 6 favorite Excel features that almost nobody talks about www.makeuseof.com/favorite-excel-features-that-almost-nobody-talks-about/ F4 to repeat your last action. The fastest way to apply formatting without touching your mouse The Filled Map. Turn location data into a real map in two clicks Show All Formulas (Ctrl + `). One shortcut to audit a
Seguir leyendoThis Excel feature helps me make better decisions (and avoid regrets)
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 leyendoOnce 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 leyendo