Chapter 6. Planning Application Data Management

Chapter 6. Planning Application Data Management

Periodically, we need to create a copy of the current data.

For example, we can fill the forecast data with actual data for past months and with budget data for future ones.

Or, we can create several budget and forecast versions to make a decision about right numbers.

You can copy data between periods and categories using the data_management worksheet:

Using the data_management worksheet to copy data

Just right-click on the desired cell and choose the operation (the menu is dynamic):

Example of the Excel context menu in the data_management worksheet

For example, we can use these operations to prepare forecast data for this case.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK