I typed three semicolons into Excel and found its strangest formatting trick https://www.makeuseof.com/typed-three-semicolons-into-excel-found-strangest-formatting-trick/ A custom number format has four slots Leave every one of them empty, and Excel draws nothing Formulas still read the hidden value Blanking the display never touches the data underneath This beats hiding columns or turning
Lees verderCategorie: Excel 2010+
4 ridiculously useful Excel tools Microsoft barely tells you exist
4 ridiculously useful Excel tools Microsoft barely tells you exist https://www.makeuseof.com/4-useful-excel-tools-microsoft-barely-tells-you-exist/ Camera Tool Not on the ribbon, but three clicks from your toolbar Flash Fill Ctrl+E does what a formula would take five minutes to write Analysis ToolPak It just isn’t turned on by default Watch Window One floating panel
Lees verderYour spreadsheet crossed into database territory if it does these 5 things
Your spreadsheet crossed into database territory if it does these 5 things https://www.makeuseof.com/spreadsheet-crossed-into-database-territory-if-these-things/
Lees verderI use Excel every day and these are the shortcuts I can’t live without
I use Excel every day and these are the shortcuts I can’t live without https://www.makeuseof.com/mastered-excel-shortcuts-cant-live-without/
Lees verderI stopped maintaining lookup formulas after finding Excel’s hidden relational database
I stopped maintaining lookup formulas after finding Excel’s hidden relational database https://www.makeuseof.com/excels-data-model-is-fantastic-database-tool-most-people-dont-know-about/
Lees verderSUM is good, SUBTOTAL is great, but this Excel function beats them both: AGGREGATE
SUM is good, SUBTOTAL is great, but this Excel function beats them both https://www.makeuseof.com/sum-is-good-subtotal-is-great-but-this-excel-function-beats-them-both/ AGGREGATE function | Microsoft Support https://support.microsoft.com/en-us/excel/functions/aggregate-function
Lees verderLAMBDA: I built my own Excel function without touching VBA, and now I use it daily
I built my own Excel function without touching VBA, and now I use it daily https://www.makeuseof.com/built-my-own-excel-function-without-touching-vba/ I kept rebuilding the same formula until Excel let me name it LAMBDA turns a formula you lean on into a function you can call by name I built my custom function inside the
Lees verder“I tried these 6 new Excel functions and they saved me a ton of time”
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 verder“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 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 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 verder