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 hear the numbers
- Goal Seek: Let Excel figure out what needs to change
- Power Query (Import Data from a Folder): Turn a folder full of files into one table / Example/Sample File / Transform Sample File / Transform File (Function) / Final/Output Query
- Before you learn another formula, try these