Inforiver Videos
MatrixEnterprise
  • Writeback Matrix
    • Overview
      • Enterprise Planning & Performance Management in Power BI
      • Real-Integrated Planning in Power BI
      • Top 5 Driver-Based Planning Techniques in Power BI
      • Power BI Writeback - A deep dive
    • Features
      • Summary
      • Collaborative commenting
      • Schedule, burst & broadcast reports
      • Data writeback
      • Writeback to Fabric OneLake/Data Warehouse
      • Ad-hoc emails
      • Dropdown lists
  • Reporting Matrix
    • Expert speak
      • Visual formulas vs DAX with Marco Russo
      • Faster reporting and insights with Matt Allington
      • The best custom visual for Power BI?
      • Build a P&L / Income statement in less than 5 minutes
      • Formatting financial statements in Power BI - P&L
    • Overview
      • No-code reporting
      • Cutting-edge data visualizations
      • Advanced data analysis
      • Data provenance & audit
      • What-if simulations
    • General
      • Reorder rows and columns
      • Layout options
      • Advanced filtering
      • Nested top N + others
      • Conditional formatting
      • Number formatting
      • Cell & value formatting
      • Notes & annotations
      • Comments with filter context
      • Totals & subtotals
      • One-click templates
      • Pagination
      • Group rows and columns
      • Search & filter
      • Expand/collapse hierarchy
      • KPI explorer
      • Audit log
      • Export to Excel
      • Comparative measures
      • Images in columns
      • Ragged hierarchies
    • Formula & calculations
      • Excel-like cell editing
      • Insert calculated and static rows
      • Insert calculated column
      • Insert calculated measure
      • Quick formula options
      • Invert signs
    • Planning, budgeting & forecasting
      • Manual data input
      • Allocations
      • What-if simulations
      • Data entry & simulations in reading view
      • No-code rolling forecasts
    • Graphical tables
      • IBCS visualizations
      • Bar charts
      • Lollipop charts
      • Waterfall charts
      • Bullet charts for 2 measures
      • Bullet charts for 3 measures
      • Stacked charts
      • Sparkline charts
      • Tornado charts
      • KPI cards
      • Blend column
    • Conditional formatting
      • One-click options
      • Semantic formatting
      • Heat map formatting
      • Format entire row
      • Traffic light & arrow alert
      • Fill icon and star rating
      • Segmentation
      • Format top/bottom N rows
      • Branch level formatting
      • Conditional formatting of multiple hierarchies
      • Dynamic conditional formatting
      • Format using if conditions
    • Visual-level formulas
      • Excel-like cell editing
      • Quick formula options
      • Smart analysis
      • Excel-like formula editor
      • Calculated measures and columns
      • 4 ways of inserting rows
      • Evaluate columns before rows
      • Manage aggregations
      • Automatic variance calculations
  • Analytics+
Powered by GitBook
On this page
  1. Reporting Matrix
  2. Visual-level formulas

Excel-like cell editing

PreviousVisual-level formulasNextQuick formula options

Last updated 1 year ago

In this video, learn more about Inforiver's Excel-like cell editing capabilities and how you can

(a) Select a cell and directly enter values

(b) Double-click a cell and open the formula bar where you can type in values or formula

(c) Use scaled values (e.g. 4.5m) or normal values (e.g. of 4500000) while updating data

(d) Use cell references in your formulae

(e) Copy and paste values using Ctrl+C and Ctrl+V

(f) Track changes to data using the audit feature

Related resources

Feature highlights

User guide

Visual calculations in Power BI
Excel-like cell editing