Etiqueta: Excel

This tiny symbol in Excel changes everything (and most people ignore it): @ www.makeuseof.com/tiny-symbol-in-excel-changes-everything/

My 6 favorite Excel features that almost nobody talks about www.makeuseof.com/favorite-excel-features-that-almost-nobody-talks-about/ F4 to repeat your last action. The fastest way to apply formatting without touching your mouse The Filled Map. Turn location data into a real map in two clicks  Show All Formulas (Ctrl + `). One shortcut to audit a

This Excel feature helps me make better decisions (and avoid regrets) 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

Once you understand SCAN in Excel, you’ll never build formulas the same way www.makeuseof.com/understand-scan-in-excel/ SCAN function – Microsoft Support support.microsoft.com/en-us/office/scan-function-d58dfd11-9969-4439-b2dc-e7062724de29 LAMBDA function – Microsoft Support support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67

These 5 Excel dashboard tricks would have saved me hours as a beginner www.makeuseof.com/excel-dashboard-tricks-for-beginner/ Pivot Tables – Summarize thousands of rows in seconds without formulas Pivot Charts – Visualize your Pivot Table data with one click Helper Sheets – Keep raw data and complex calculations off the main dashboard view

I stopped getting lost in giant Excel sheets when I found these two features www.makeuseof.com/stopped-getting-lost-in-giant-excel-sheets-when-found-these-features/ Watch Window – Keep key cells in sight, no matter where you scroll to A watch window placed beside a list of names on an Excel spreadsheet. Custom Views – Reset your sheet instantly  

These two Excel functions make stacking data from multiple sheets too easy www.makeuseof.com/these-excel-functions-make-stacking-data-from-multiple-sheets-easy/ VSTACK – For data that needs to be ready for analysis HSTACK – Best for side-by-side comparisons

I didn’t know these Excel functions existed, but now I can’t live without them www.makeuseof.com/i-cant-live-without-these-excel-functions/ 5 TEXTSPLIT – Breaks apart text that’s stuck together 4 TEXTJOIN – Combines multiple cells into one 3 CHOOSECOLS – Selects specific columns from your data 2 TAKE and DROP – Extracts portions of your

I use these 5 Excel array formulas to crush complex calculations www.makeuseof.com/use-excel-array-formulas-crush-complex-calculations/ 5 XLOOKUP 4 SUMPRODUCT 3 FILTER 2 UNIQUE 1 SORT and SORTBY