Categoría: Tools

Copilot in Excel is actually brilliant — 6 ways I use it to make spreadsheets easier www.makeuseof.com/ways-i-use-copilot-to-make-excel-spreadsheets-easier/ I let Copilot write complex formulas, so I don’t have to. LET and IF formulas are Copilot’s strength, not mine Copilot sorts and filters my data faster. One sentence replaces five clicks Creating

I’ve used Excel for over a decade and didn’t know about this extremely useful trick www.makeuseof.com/used-excel-for-over-a-decade-and-didnt-know-about-extremely-useful-trick/ The IMAGE function is the core trick Use it as an API client There’s more to it than QR Codes Generate GitHub-style badges inside Excel Generate a chart that updates itself This time as

My Excel formulas used to break all the time until I found this function www.makeuseof.com/excel-formulas-used-to-break-until-i-found-this-function/ AGGREGATE does what other functions can’t. Here’s how the syntax works It also handles hidden and filtered rows correctly. Your calculations stay accurate even when rows are out of sight AGGREGATE can replace 19 different

8 Excel tricks that I wish I knew when I had just started using it www.makeuseof.com/excel-tricks-wish-i-knew-when-just-started-using-it/ Flash Fill can save you from writing complex formulas. It detects patterns and fills data for you Freeze Panes keeps your headers visible. Don’t scroll back to the top every time you lose track of

Use Excel’s TAKE and DROP to make brilliant self-updating lists www.makeuseof.com/use-excels-take-and-drop-make-brilliant-self-updating-lists/ TAKE function – Microsoft Support support.microsoft.com/en-us/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003 DROP function – Microsoft Support support.microsoft.com/en-us/office/drop-function-1cb4e151-9e17-4838-abe5-9ba48d8c6a34

7 ways I keep complex Excel workbooks from turning into a mess www.makeuseof.com/keep-complex-excel-workbooks-from-turning-into-a-mess/ If it’s truly tabular, put it in a table. Structure what deserves structure Separate data, logic, and presentation. One job per sheet Every workbook gets an input sheet. Change values in one place only Break monster formulas with LET

This might be the most underrated Excel function ever www.makeuseof.com/most-underrated-excel-function-ever/ IMAGE function – Microsoft Support support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5

These Excel functions just made PivotTables obsolete for me www.makeuseof.com/groupby-and-pivotby-versus-pivot-tables/ GROUPBY the one-axis wonder – Because who actually needs bells and whistles for basic summaries PIVOTBY the two-axis power move – The overachiever of data summaries Most Excel users are still using Pivot Tables, but this new function is faster www.makeuseof.com/pivotby-instead-of-pivot-tables/

Freeze Panes and Focus Cell. Never lose track of where you are Split View. Compare distant parts of your sheet side-by-side without scrolling Watch Window. Track the values that matter without jumping between sheets

We need to talk about the LAMBDA function in Excel www.makeuseof.com/we-need-to-talk-about-the-lambda-function-in-excel/