What-if in Excel and Business Central Data
This article discusses how to combine the features of Microsoft Excel and Business Central to perform "What-if" analysis. By exporting data from Business Central into Excel, users can utilize Excel's What-If Analysis tools to create separate scenarios and calculate outcomes. The article provides an example of using scenarios to forecast the outcome of changing unit prices on an item, as well as using Goal Seek to determine the necessary price increase to achieve a desired turnover. The scenarios created in Excel can be saved and imported into Business Central for use by other users.
Article 4m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time