Saltar al contenido

EBP Plat{a|e}form{a|e}

ICT + evidence based practice|wetenschappelijk onderzoek|recherche scientifique|investigación científica

Technoblog
NL
FR
EN
- Recent graphs to practice
ES
Nieuws

«I use these 5 Excel array formulas to crush complex calculations»

septiembre 15, 2025 Hans Le Roy

I use these 5 Excel array formulas to crush complex calculations
www.makeuseof.com/use-excel-array-formulas-crush-complex-calculations/

5 XLOOKUP
4 SUMPRODUCT
3 FILTER
2 UNIQUE
1 SORT and SORTBY

EN Tools

Excel

Navegación de entradas

Entrada anterior

«These 3 Excel functions make me feel like a spreadsheet wizard»

Entrada siguiente

«I didn’t know these Excel functions existed, but now I can’t live without them»

Buscar:

Entradas recientes

Copilot in Excel is actually brilliant — 6 ways I use it to make spreadsheets easier
I’ve used Excel for over a decade and didn’t know about this extremely useful trick: IMAGE
My Excel formulas used to break all the time until I found this function: AGGREGATE
8 Excel tricks that I wish I knew when I had just started using it
Use Excel’s TAKE and DROP to make brilliant self-updating lists

Categorías

EN
- Class materials
- e-health
- News
- Questions
- Tools
ES
FR
NL

Random Posts

La posverdad no era para tanto: la gente sí cambia de opinión cuando se le presentan hechos
Find Credible Health Information on YouTube
Introduce Students to Academic Search Engines and Databases
CRAP: criterios para seleccionar contenidos fiables
Duizenden medische studies mogelijk frauduleus: “Wetenschappers onder extreme druk”
«These 5 Excel dashboard tricks would have saved me hours as a beginner»
How to Translate Foreign Languages With Hotkeys in Windows 10 & 11
Spelling lastig? Erger je lezer niet!
Vijf klimaatmythes uit ‘Don’t Look Up’ waar de wetenschap ook in het echt onder lijdt
Why Wikipedia Isn’t as Credible as You Might Think

Nieuw op Technoblog

Nube de etiquetas

bias bibliography confidence copyright correct critical thinking data database decide EBP edit Excel Google Sheets graph graphs language Mendeley presentation question refer search statistics steps terminology tools translate Word write Zotero

Tema WordPress: Treville por ThemeZee.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More

Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Siempre activado

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

GUARDAR Y ACEPTAR