I stopped reaching for ChatGPT when Excel could do it three times faster https://www.makeuseof.com/things-in-excel-than-chatgpt-just-faster/ Pivot tables still do the heavy lifting Instantly summarize data without overthinking it Conditional formatting beats explanations See patterns instantly instead of asking for them Flash Fill feels like magic Clean and transform data in seconds,
Lees verderCategorie: Office 2010
Hojas de cálculo para gente normal: los trucos de Excel y Google Sheets que todo el mundo debería conocer
Hojas de cálculo para gente normal: los trucos de Excel y Google Sheets que todo el mundo debería conocer https://wwwhatsnew.com/2026/04/22/hojas-calculo-trucos-excel-google-sheets-principiantes/
Lees verderOffice Scripts – This hidden Excel Automation feature is way more useful than it gets credit for
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 verderExcel 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 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 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 verderDynamische matrices en gedrag van matrices op aangrenzende cellen
Dynamische matrices en gedrag van matrices op aangrenzende cellen – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/dynamische-matrices-en-gedrag-van-matrices-op-aangrenzende-cellen-205c6b06-03ba-4151-89a1-87a7eb36e531 Excel Dynamic Array; A Beginner’s Tutorial | GoSkills https://www.goskills.com/Excel/Resources/Excel-dynamic-arrays#:~:text=Excel%20has%20introduced%20a%20spill,D5%20with%20the%20expression%20D2%23.
Lees verder“I stopped wasting time in PowerPoint when I learned these 7 hacks”
I stopped wasting time in PowerPoint when I learned these 7 hacks https://www.makeuseof.com/powerpoint-time-saving-tips/ 7 Resize multiple objects or shapes in one go – Scale everything at once 6 Reuse existing slides instead of rebuilding them – Steal your own brilliance, no shame 5 Polish your slides with format painter and
Lees verder“I make messy Excel data beautiful in minutes and it’s all thanks to these 5 tips”
I make messy Excel data beautiful in minutes and it’s all thanks to these 5 tips https://www.makeuseof.com/make-messy-excel-data-beautiful/ 5 Clean up text with TRIM, CLEAN, and PROPER 4 Apply consistent styles with table and cell formatting 3 Highlight what matters with Conditional Formatting 2 Show trends instantly with Sparklines 1 Freeze
Lees verder“I Stopped Wasting Time in Excel When I Learned These 3 Functions”
“I Stopped Wasting Time in Excel When I Learned These 3 Functions” https://www.makeuseof.com/excel-functions-time-saver/ FILTER SUMIFS / COUNTIFS XLOOKUP ++ FILTER function – Microsoft Support https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759 SUMIFS function – Microsoft Support https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b XLOOKUP function – Microsoft Support https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 ++ De functie FILTER – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/de-functie-filter-f4f7cb66-82eb-4767-8f7c-4877ad80c759 SOMMEN.ALS, functie – Microsoft Ondersteuning
Lees verderI Proofread Twice as Fast With These Word Hacks
I Proofread Twice as Fast With These Word Hacks https://www.makeuseof.com/proofread-with-these-word-hacks/ Start With the Editor Tool (Spelling & Grammar) Make the Editor Work for You Explore the Review Tab for More Tools Compare Documents and Combine Check Readability Statistics Leverage Track Changes for Collaborative Proofreading Use Find & Replace for Rapid
Lees verder8 Underrated PowerPoint Features That Speed Up Slide Creation
8 Underrated PowerPoint Features That Speed Up Slide Creation https://www.makeuseof.com/underrated-powerpoint-features-that-speed-up-slide-creation/ Pin Frequently Used Commands to the Quick Access Toolbar Get Inspiration from Design Suggestions Reuse Existing Slides Use the Placeholder Text Generator Create Charts Faster With Templates Use Master Slides for Consistency Trim Audio From Within PowerPoint Generate Entire Presentations
Lees verderTitelpagina’s met logo’s
V. Men vraagt me een tekst te maken met een aangeleverde titelpagina. Na die titelpagina moet er een wit blad komen, een kopie van die titelpagina. Maar daar staat een logo op, en dat logo staat dan ineens op alle pagina’s van de tekst. Hoe kan ik dat oplossen, als
Lees verder11 Creative Ways to Use Microsoft Word for More Than Just Documents
11 Creative Ways to Use Microsoft Word for More Than Just Documents https://www.makeuseof.com/creative-ways-to-use-microsoft-word/ Edit Images Craft Crossword Puzzles Design Diagrams and Flowcharts Note-Taking Transcribe Audio Translate Text Solve Calculations and Convert Measurements Build Interactive Forms Design Brochures, Flyers, and Invitations Create eBooks Create Personalized Labels and Stickers
Lees verderCtrl+B maakt niet meer vet
V. Plots out of the blue doet Ctrl+B niets meer: geselecteerde tekst wordt niet meer vet. Wat is er gebeurd? A. Om een of andere reden (een update? installatie van iets?) is er een nieuwe sneltoets toegewezen. Zoe zet je dat recht: Word, Bestand, Opties, Lint aanpassen, Sneltoetsen Tabblad Start,
Lees verder