Auteur: Hans Le Roy

“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 verder

Automatiseren 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 verder

Array 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 verder

5 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 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 verder

7 creative tools that are completely free (and professionals actually use)

7 creative tools that are completely free (and professionals actually use) https://www.makeuseof.com/creative-tools-that-are-free-and-professionals-actually-use/ Inkscape A free Adobe Illustrator alternative Krita Digital painter’s favorite tool GIMP Advanced photo editor with a subscription DaVinci Resolve Enjoy Hollywood-level video editing OBS Studio Stream and record like a pro Audacity Clean, simple, and reliable audio

Lees verder

This is why you see ads for things you only talked about

This is why you see ads for things you only talked about https://www.makeuseof.com/this-is-why-you-see-ads-for-things-you-only-talked-about/ You’re being profiled more deeply than you realize Your digital behavior paints a clearer picture than your conversations The microphone question Are tech companies really not listening? Your devices still talk even if you don’t Cross-device tracking

Lees verder

5 hidden Microsoft Word features that make PDF editors obsolete

5 hidden Microsoft Word features that make PDF editors obsolete https://www.makeuseof.com/microsoft-word-features-that-replace-pdf-editors/ Edit PDF files. Open and modify PDFs like any other document Create PDF/A-compliant files. Archive-ready PDFs that last decades Create accessible PDFs. Make your PDFs work with screen readers Embed PDF objects. Bundle PDFs inside your Word documents Add

Lees verder

A Fresh Look for Open Source H5P: February 2026

A Fresh Look for Open Source H5P: February 2026 | H5P https://h5p.org/h5p-february-2026-update Some highlights: Cleaner, more contemporary styling with simplified shapes and fewer heavy borders Neutral default color palette designed to work with institutional branding Improved typography and spacing for better readability, especially on mobile More consistent layouts for titles,

Lees verder

2026.06.29-07.01 Edulearn26

Registration is now open for EDULEARN26, the 18th annual International Conference on Education and New Learning Technologies! This conference has secured its status as one of Europe’s largest and most trusted education conferences for professionals, researchers and technologists around the world. Held annually for the last 17 years, it will

Lees verder