This might be the most underrated Excel function ever www.makeuseof.com/most-underrated-excel-function-ever/ IMAGE function – Microsoft Support support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5
Seguir leyendoCategoría: EN
«These Excel functions just made PivotTables obsolete for me»
These Excel functions just made PivotTables obsolete for me www.makeuseof.com/groupby-and-pivotby-versus-pivot-tables/ GROUPBY the one-axis wonder – Because who actually needs bells and whistles for basic summaries PIVOTBY the two-axis power move – The overachiever of data summaries Most Excel users are still using Pivot Tables, but this new function is faster www.makeuseof.com/pivotby-instead-of-pivot-tables/
Seguir leyendo«These 3 Excel views completely changed how I work with large sheets»
Freeze Panes and Focus Cell. Never lose track of where you are Split View. Compare distant parts of your sheet side-by-side without scrolling Watch Window. Track the values that matter without jumping between sheets
Seguir leyendoWhy Curiosity And Critical Thinking Matter More Than Ever
Why Curiosity And Critical Thinking Matter More Than Ever – eLearning Industry elearningindustry.com/are-you-curious-are-you-critical-thinking-matters-more-than-ever
Seguir leyendoWe need to talk about the LAMBDA function in Excel
We need to talk about the LAMBDA function in Excel www.makeuseof.com/we-need-to-talk-about-the-lambda-function-in-excel/
Seguir leyendoZoomers 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 leyendo