This hidden Excel Automation feature is way more useful than it gets credit for https://www.makeuseof.com/built-in-excel-automation-feature/ Excel’s Office scripts Automating repetitive work inside Excel The Automate a task button Let Excel run scripts for you Office Scripts in Excel – Office Scripts | Microsoft Learn https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
Lees verderAuteur: Hans Le Roy
Excel can now write its own formulas, and I haven’t typed one since
Excel can now write its own formulas, and I haven’t typed one since https://www.makeuseof.com/excel-can-write-own-formulas-havent-typed-one-since/ Plain English is all Copilot needs to build a formula The sidebar turns a sentence into a working column I used to dodge the nested formulas Layered IFs, lookups, and date math in a single prompt
Lees verderMicrosoft Excel: 24 funciones, trucos y consejos para exprimir al máximo la app de hojas de cálculo
Microsoft Excel: 24 funciones, trucos y consejos para exprimir al máximo la app de hojas de cálculo https://www.xataka.com/basics/microsoft-excel-24-funciones-trucos-consejos-para-exprimir-al-maximo-app-hojas-calculo Seleccionar todo Usa el modo oscuro Resalta duplicados Ayúdate de la inteligencia artificial Pasa datos de otras fuentes Inmoviliza una columna o fila Combina y divide celdas Bloquea celdas para que no
Lees verderFunciones de accesibilidad que todo el mundo debería conocer (aunque no las necesite)
Funciones de accesibilidad que todo el mundo debería conocer (aunque no las necesite) https://wwwhatsnew.com/2026/04/17/funciones-accesibilidad-movil-utiles-para-todos/
Lees verderYou should stop using Excel’s Import Wizard and use this instead: IMPORTCSV
You should stop using Excel’s Import Wizard and use this instead https://www.makeuseof.com/stop-using-excels-import-wizard-and-use-this-instead/ IMPORTCSV is a faster, formula-based alternative Its syntax only has one required argument IMPORTCSV also handles web-hosted CSV files Replace the file path with a URL, and Excel fetches the data for you Filter imported data without loading
Lees verderYou’re ignoring one of Excel’s simplest and smartest visual tools: sparklines
You’re ignoring one of Excel’s simplest and smartest visual tools https://www.makeuseof.com/ignoring-excels-simplest-smartest-visual-tools/ The tiny charts you’ve been overlooking What sparklines are and why they matter Three types, three clear use cases When to use line, column, and win/loss sparklines You can set them up in seconds A 30-second trick that adds
Lees verderDon’t bother with IF in Excel when you can use this function instead
Don’t bother with IF in Excel when you can use this function instead https://www.makeuseof.com/dont-bother-if-in-excel-when-you-use-this-function/ SWITCH is the function you should have been using It does the same job as nested IF, but without the chaos SWITCH handles real-world scenarios better than IF Here’s what that looks like with actual data
Lees verderThese 5 Excel functions are silently slowing down your spreadsheets — use these instead
These 5 Excel functions are silently slowing down your spreadsheets — use these instead https://www.makeuseof.com/excel-functions-to-use-instead-of-volatile-functions/ The NOW function Log time without triggering endless recalculations The OFFSET function Dynamic ranges shouldn’t come with a performance penalty The INDIRECT function It’s better when Excel can see what depends on what The RAND
Lees verderLos navegadores quisieron presumir de IA, pero había dos revoluciones mucho más simples: pestañas verticales y pantalla dividida
Los navegadores quisieron presumir de IA, pero había dos revoluciones mucho más simples: pestañas verticales y pantalla dividida Puede que la IA acabe revolucionando la forma en la que navegamos, pero de momento lo que nos aporta más son las pequeñas cosas https://www.xataka.com/aplicaciones/navegadores-web-quisieron-presumir-ia-habia-dos-revoluciones-mucho-pragmatica-pestanas-verticales-pantalla-dividida
Lees verder“Google Chrome finally has the one feature I’ve been waiting for”
Google Chrome finally has the one feature I’ve been waiting for https://www.makeuseof.com/google-chrome-vertical-tabs-update/ Get more done with new vertical tabs and immersive reading mode in Chrome https://blog.google/products-and-platforms/products/chrome/new-chrome-productivity-features/ Google Chrome rolling out vertical tabs, fullscreen reading mode Google Chrome rolling out vertical tabs and fullscreen reading mode
Lees verder“I use Excel every day and these are the features I’d be lost without”
I use Excel every day and these are the features I’d be lost without https://www.makeuseof.com/excel-features-for-every-day-use/ PivotTables Make sense of 1,000 rows with a quick glance Lookup functions The shortcut to answers you’d otherwise spend hours finding Conditional formatting See what matters immediately Drop-down lists Stop typing the same thing over
Lees verderEmDash: a WordPress succesor?
EmDash – Cloudflare refait WordPress from scratch – Korben https://korben.info/emdash-cloudflare-wordpress-open-source.html Introducing EmDash — the spiritual successor to WordPress that solves plugin security https://blog.cloudflare.com/emdash-wordpress/ EmDash : Cloudflare vient concurrencer WordPress avec son CMS – KultureGeek https://kulturegeek.fr/news-350091/emdash-cloudflare-vient-concurrencer-wordpress-cms 6 Reasons Why Cloudflare’s EmDash Can’t Compete With WordPress https://www.searchenginejournal.com/6-reasons-why-cloudflares-emdash-cant-compete-with-wordpress/571053/ Cloudflare debuts EmDash to challenge
Lees verder“6 Excel habits I had to unlearn to get good at it”
6 Excel habits I had to unlearn to get good at it https://www.makeuseof.com/excel-habits-to-unlearn/ Holding onto merged cells Pretty sheets aren’t worth broken filters and sorting Keeping everything on one sheet Tabs exist for a reason Burying my assumptions If it’s important, it deserves its own cell Writing unreadable formulas Clear
Lees verder“Excel’s data validation is far more powerful than just dropdowns — here’s what it can actually enforce”
Excel’s data validation is far more powerful than just dropdowns — here’s what it can actually enforce https://www.makeuseof.com/excels-data-validation-more-powerful-than-just-dropdowns/ Custom formulas let you control far more than a list The Custom option accepts any TRUE/FALSE formula as a validation rule Prevent duplicate entries with a COUNTIF formula It flags repeats before
Lees verderAutomatiseren zonder code
Automatizar tareas repetitivas sin saber programar: guía de IFTTT, Atajos de Apple y Google Routines https://wwwhatsnew.com/2026/04/01/automatizar-tareas-repetitivas-sin-saber-programar-guia-de-ifttt-atajos-de-apple-y-google-routines/ IFTTT – Automate business & home https://ifttt.com/ Zapier: Automate AI Workflows, Agents, and Apps https://zapier.com/ Alternatives: Automation Magic: 15 Surprisingly Good IFTTT Alternatives Automation Magic: 15 Surprisingly Good IFTTT Alternatives What IFTTT Is What
Lees verderArray functions in Excel
Those curly brackets in Excel aren’t a glitch — here’s what they actually mean https://www.makeuseof.com/curly-brackets-in-excel/ Legacy array formulas The curly brackets you can’t type yourself Array constants The curly brackets you do type yourself Modern Excel and the shift to dynamic arrays No more Ctrl + Shift + Enter See
Lees verder5 open-source apps that run entirely in your browser and don’t touch the cloud
5 open-source apps that run entirely in your browser and don’t touch the cloud https://www.makeuseof.com/open-source-apps-that-run-entirely-in-browser-dont-touch-cloud/ TiddlyWiki – A non-linear notebook for exploring ideas https://tiddlywiki.com/ Excalidraw – Create diagrams that look hand-drawn https://excalidraw.com/ miniPaint – Edit and annotate images from your browser https://viliusle.github.io/miniPaint/ OpenReel Video – An open-source CapCut alternative in
Lees verderPake: “This open-source tool turns any web page into a desktop app, and I can’t stop using it”
This open-source tool turns any web page into a desktop app, and I can’t stop using it https://www.makeuseof.com/open-source-tool-turns-web-page-into-desktop-app/ A better way to run web apps No need to choke your PC with heavy Electron-based apps anymore Get started without touching a terminal Fill out a form and have your custom
Lees verder“I stopped restructuring my Excel sheets manually the day I discovered CHOOSECOLS”
I stopped restructuring my Excel sheets manually the day I discovered CHOOSECOLS https://www.makeuseof.com/choosecols-in-excel/ CHOOSECOLS function – Microsoft Support https://support.microsoft.com/en-us/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff KIES.KOLOMMEN-functie – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/kies-kolommen-functie-bf117976-2722-4466-9b9a-1c01ed9aebff
Lees verderI used a built-in Windows tool to turn my basic PowerPoint into a polished video: Clipchamp
I used a built-in Windows tool to turn my basic PowerPoint into a polished video https://www.makeuseof.com/make-narrated-powerpoint-video-using-clipchamp/ Export your PowerPoint as a video file Start by turning slides into a playable video Import the PowerPoint video into Clipchamp Bring your presentation into Windows’ own AI video editor Add an AI voiceover
Lees verder