I tried these 6 new Excel functions and they saved me a ton of time https://www.makeuseof.com/new-excel-functions-worth-learning-this-year/ Regular expression (regex) functions Find, extract, and clean data without endless text formulas regexreplace REGEXREPLACE Function | Microsoft Support https://support.microsoft.com/en-us/excel/regexreplace-function regextest REGEXTEST Function | Microsoft Support https://support.microsoft.com/en-us/excel/regextest-function regexextract REGEXEXTRACT Function | Microsoft Support https://support.microsoft.com/en-us/excel/regexextract-function
Lees verderCategorie: Excel
“I never knew what those double brackets in Excel meant — now I use them in almost every formula”
I never knew what those double brackets in Excel meant — now I use them in almost every formula https://www.makeuseof.com/double-brackets-in-excel/
Lees verderModern Excel finally made sense to me after I learned how arrays and ranges are different
Modern Excel finally made sense to me after I learned how arrays and ranges are different https://www.makeuseof.com/how-arrays-and-ranges-in-excel-are-different/
Lees verderIFNA: The Excel formula I use whenever #N/A takes over a sheet
The Excel formula I use whenever #N/A takes over a sheet https://www.makeuseof.com/the-ifna-function-in-excel/ IFNA function – Microsoft Support https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 ALS.NB, functie – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/als-nb-functie-6626c961-a569-42fc-a49d-79b4951fd461
Lees verderExcel’s dynamic array functions made me realize I’d been solving problems the hard way for years
Excel’s dynamic array functions made me realize I’d been solving problems the hard way for years https://www.makeuseof.com/excels-dynamic-array-functions-made-me-realize-solving-problems-hard-way/
Lees verderI stopped reaching for ChatGPT when Excel could do it three times faster
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 verderHojas 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 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 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 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 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 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 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 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 verder“This Excel feature helps me make better decisions (and avoid regrets)”
This Excel feature helps me make better decisions (and avoid regrets) https://www.makeuseof.com/what-if-analysis-feature-in-excel-for-better-decisions/ Goal Seek – Find out how you can reach your target Scenario Manager – Compare your best case, worst case, and most likely scenarios Data Tables – Test dozens of possibilities in seconds
Lees verder“These 3 Excel functions make me feel like a spreadsheet wizard”
These 3 Excel functions make me feel like a spreadsheet wizard https://www.makeuseof.com/excel-functions-feel-like-spreadsheet-wizard/ 4 The SEQUENCE function generates data automatically – Create dynamic number and date sequences 3 LET makes complex formulas maintainable – Eliminate repetitive calculations and improve readability 2 LAMBDA creates reusable custom functions – Build custom functions for
Lees verder