EBP Plat{a|e}form{a|e}

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