7 Excel tools that are more useful than learning another formula https://www.makeuseof.com/excel-tools-more-useful-than-functions/ Data Form: A simpler way to work with wide tables Watch Window: See what’s changing without jumping around Evaluate Formula: Take the guesswork out of complex formulas Sheet Views: Because not everyone needs the same view Speak Cells: Sometimes it’s easier to
Lees verderCategorie: Excel 2010+
Microsoft cells out, crams multiple values into Excel boxes
Microsoft cells out, crams multiple values into Excel boxes Once a single-scalar home, spreadsheet cells are being redeveloped to handle many tenants https://www.theregister.com/applications/2026/09/25/microsoft-cells-out-crams-multiple-values-into-excel-boxes/5299294
Lees verderYour Excel sheets keep lagging because of these 3 formulas
Your Excel sheets keep lagging because of these 3 formulas https://www.makeuseof.com/excel-sheets-keep-lagging-because-of-these-formulas/ Formulas with volatile functions. There’s a reason the pros use them sparingly Legacy array formulas. Processing array formulas is not always so simple Lookup formulas. They’re convenient but can be expensive Unlock the power of a fast Excel sheet
Lees verderI stopped using PivotTables in Excel because I found something better
I stopped using PivotTables in Excel because I found something better https://www.makeuseof.com/excel-pivot-tables-better-alternative/ Meet Excel’s PivotCharts The smarter side of PivotTables Building your first PivotChart No formulas, just drag and drop Make PivotCharts your own Colors, styles, and chart types Interactive filtering with PivotCharts It makes data exploration way easier When
Lees verderI rebuilt the same Excel report every month for 3 years — Power Query turned it into one refresh button
I rebuilt the same Excel report every month for 3 years — Power Query turned it into one refresh button https://www.makeuseof.com/rebuild-the-same-excel-report-with-power-query/ Breaking the copy-paste cycle. If you’re still combining files manually every month, there’s a better way From multiple files to one refreshable report. Set it up once, drop in the new
Lees verderI 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-time-saver-function-stop-wasting-time/ XLOOKUP: A cleaner replacement for VLOOKUP SUMIFS and COUNTIFS: Conditional totals without the filter dance FILTER: Live results from a single formula
Lees verderI ignored Excel’s What-If Analysis menu for years and I shouldn’t have
I ignored Excel’s What-If Analysis menu for years and I shouldn’t have https://www.makeuseof.com/excels-what-if-analysis-menu/ Data Tables: Build a grid of any size in seconds Scenario Manager: For juggling complex multi-variable models Goal Seek: Reverse engineer your targets Stop checking what if manually
Lees verderI typed three semicolons into Excel and found its strangest formatting trick
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 verder4 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 verder