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 verderAuteur: Hans Le Roy
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 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 verderExcel finally fixed its biggest data entry problem, and it’s a lifesaver: Clean Data
Excel finally fixed its biggest data entry problem, and it’s a lifesaver https://www.makeuseof.com/excel-finally-fixed-its-biggest-data-entry-problem-and-its-a-lifesaver/ Data tab, Clean Data
Lees verderMicrosoft Word has a secret clipboard called Spike, and it’s a productivity beast
Microsoft Word has a secret clipboard called Spike, and it’s a productivity beast https://www.makeuseof.com/microsoft-word-has-secret-clipboard-called-spike-its-productivity-beast/
Lees verderSmarter Slides: Stop building slides from scratch — this free add-in does it for you
Stop building slides from scratch — this free add-in does it for you https://www.makeuseof.com/smarter-slides-powerpoint-add-on-for-building-slides-from-scratch/ The free PowerPoint AddIn | Smarter Slides https://smarter-slides.com/
Lees verder2026.06.02-03 Microsoft Build 2026
Microsoft Build 2026 June 2–3, 2026 / San Francisco and online At Microsoft Build, you’ll go deep on real code, real systems, and real workflows with the teams building and scaling AI. Two days. Hands-on sessions. No fluff. https://build.microsoft.com/en-US/home
Lees verder7 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 verderYou don’t need to be a coder to use Python in Excel for data cleaning
You don’t need to be a coder to use Python in Excel for data cleaning https://www.makeuseof.com/dont-need-coder-use-python-excel-data-cleaning/ Getting started is easier than you think. Microsoft hid the hardest parts and left you with the useful ones Using Python in Excel. Python handles messy data that would take dozens of formulas Once
Lees verderThis 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 verder5 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 verderYou don’t need to be a coder to use Python in Excel for data cleaning
You don’t need to be a coder to use Python in Excel for data cleaning https://www.makeuseof.com/dont-need-coder-use-python-excel-data-cleaning/ Getting started is easier than you think. Microsoft hid the hardest parts and left you with the useful ones Using Python in Excel. Python handles messy data that would take dozens of formulas Once
Lees verderPlaats tekort – mag ik dubbels verwijderen?
V. Ik heb meer plaats nodig op mijn schijf. Hoe kan ik opruimen? A. Vóór alles: wees voorzichtig. Begin met het updaten van Windows. Desinstalleer de applicaties die je niet meer gebruikt. In Windows Verkenner, zoek naar *.* (alle bestanden) in alle mappen. Wacht geduldig tot Windows Verkenner zijn werk
Lees verderA 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 verder2026.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 verderGeen Copilot in Office (Word, Powerpoint, Excel)
V. Hoe kan het dat ik geen Copilot heb in mijn Word en Powerpoint? A. Grosso modo zijn er twee mogelijke oorzaken: Het zit niet in je abonnement, of je moet de programma’s opnieuw vragen je abonnement te bekijken De instellingen voor beveiliging staan niet goed. Hier vind je de
Lees verder