# How-tos

- [Create and share a cloud connection for a semantic model](/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model.md)
- [Create a database connection](/planning-sheets/how-tos/create-a-database-connection.md)
- [Creating a Planning Sheet](/planning-sheets/how-tos/creating-a-planning-sheet.md)
- [Forecast data to predict future trends](/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md)
- [Create multi-dimensional forecasts](/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts.md)
- [Manage rolling forecasts](/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts.md)
- [Generate forecasts from statistical data](/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data.md)
- [Extend planning beyond source data periods](/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods.md)
- [Edit forecast settings](/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md)
- [Allocate deficits to meet targets](/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets.md)
- [Commenting and collaboration](/planning-sheets/how-tos/commenting-and-collaboration.md)
- [Notes in Commenting and Collaboration](/planning-sheets/how-tos/commenting-and-collaboration/notes-in-commenting-and-collaboration.md)
- [Extend Planning sheet with data input](/planning-sheets/how-tos/extend-planning-sheet-with-data-input.md)
- [Plan across multiple dimensions with cubes](/planning-sheets/how-tos/allocate-values-across-dimensions.md)
- [Analyze planning outcomes with scenarios](/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios.md)
- [Bookmarks](/planning-sheets/how-tos/bookmarks.md)
- [Exports in the Planning sheet](/planning-sheets/how-tos/exports-in-the-planning-sheet.md)
- [Layouts](/planning-sheets/how-tos/layouts.md)
- [Persist planning data using Writeback](/planning-sheets/how-tos/persist-planning-data-using-writeback.md)
- [Basic formatting](/planning-sheets/how-tos/basic-formatting.md)
- [Number formatting](/planning-sheets/how-tos/basic-formatting/number-formatting.md): Plan for Power BI comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table/matrix style reports.
- [Cell, header & value formatting](/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting.md)
- [Total and Subtotals](/planning-sheets/how-tos/basic-formatting/total-and-subtotals.md)
- [Adding business logic and formulas](/planning-sheets/how-tos/adding-business-logic-and-formulae.md)
- [Edit cells](/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells.md)
- [Rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows.md)
- [Insert data input rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md)
- [Insert template rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/template-rows.md)
- [Insert formula rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-calculated-rows.md)
- [Insert blank rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-blank-rows.md)
- [Insert forecast rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-forecast-rows.md)
- [Measures and Columns](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns.md)
- [Insert Data Input columns](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns.md)
- [Number](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/insert-manual-input-columns.md)
- [Dropdown](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown.md)
- [Text, checkbox & date](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/text-checkbox-and-date.md)
- [Person](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/writeback-matrix-features.md)
- [Insert Formula columns](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-calculated-columns.md)
- [Manage inserted rows](/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns.md)
- [Manage inserted measures & columns](/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns-1.md)
- [Manage aggregation](/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation.md): Custom Measure Aggregations in Semantic Models with Plan
- [Row aggregation](/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation/row-aggregation.md)
- [Pivot data](/planning-sheets/how-tos/adding-business-logic-and-formulae/pivot-data.md)
- [Conditional formatting](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting.md): Plan enables intuitive data classification using conditional formatting, allowing users to visually interpret performance at a glance
- [One-click options](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/one-click-options.md)
- [Create rule](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings.md): You can build your own conditional formatting rules from scratch or customize the rules created using the one-click options if your report requires it.
- [Rules (If conditions)](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/rules-if-conditions.md)
- [Color scale & data bars](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/color-scale.md)
- [Classification](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/classification.md): Learn how to use classification-based conditional formatting - such as text, icons, and ratings - to quickly gain insights from your reports.
- [Ranking](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/ranking.md): Plan highlights the top or bottom N ranked values, making it easy to quickly identify the highest- and lowest-performing items.
- [Field Value](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/field-value.md): Learn how to use field value–based conditional formatting to dynamically format your Microsoft Fabric reports using Plan.
- [Bubble Charts](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/bubble-charts.md): In this section, we'll look at bubble charts. Note that you can either create a new rule as shown here or edit the bubble charts inserted using the one-click option explained here.
- [Action Dots](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/action-dots.md): Learn how to use Action Dots to visually represent performance for faster, more efficient analysis in Plan.
- [Manage rules](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/manage-rules.md)
- [Planning, Budgeting & Forecasting](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting.md)
- [What-if Analysis & Simulations](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/what-if-analysis-and-simulations.md)
- [Goal Seek](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/goal-seek.md)
- [Budgeting & Allocations](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/budgeting-and-allocations.md)
- [Forecasting](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting.md)
- [Date rollover and extending forecasts](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting/date-rollover-and-extending-forecasts.md)
- [Editing forecasts and reforecasting](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting/editing-forecasts-and-reforecasting.md)
- [Autoclose forecasts](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting/autoclose-forecasts.md)
- [Distribute deficit](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting/distribute-deficit.md)
- [Row level forecast](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting/row-level-forecast.md)
- [User Access Control](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/forecasting/user-access-control.md)
- [Allocation Rules and Controls](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls.md)
- [Locking Rule](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/locking-rule.md)
- [Distribution rules](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/distribution-rules.md)
- [Column aggregation](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/column-aggregation.md)
- [Driver Model](/planning-sheets/how-tos/driver-model.md)
- [Configure row properties in the model](/planning-sheets/how-tos/configure-row-properties-in-the-model.md)
- [Create a model using Model Builder](/planning-sheets/how-tos/create-a-model-using-model-builder.md)
- [Create templates for reusable row structures](/planning-sheets/how-tos/create-templates-for-reusable-row-structures.md)
- [Create a driver-based model](/planning-sheets/how-tos/create-a-driver-based-model.md)
- [Visualize the model using the tree layout](/planning-sheets/how-tos/visualize-the-model-using-the-tree-layout.md)