01
Formulas and fill
Use aggregation, conditions, lookup, text, dates and dynamic arrays. SUM, SUMIFS, IF, XLOOKUP, FILTER and other implemented functions help build calculations in understandable steps. Cross-sheet references, named ranges and drag fill are supported.
02
A structure you can inspect
Structured tables combine column names, calculated columns and totals. Validation helps catch unsuitable values, while conditional formatting highlights important differences. These editing aids do not replace access controls.
03
Views and grouped reports
Save filtered and sorted views. Build a report on another sheet with row and column groups, multiple measures and totals. Refreshing that report uses the workbook's source sheet; it does not automatically fetch an external system.
04
Charts and presentation
Use column, line, area, pie, scatter and combination charts. Adjust labels, legends and colors, then prepare a print area. Charts use calculated values rather than a pre-drawn illustration.
05
Company workbooks and versions
Sign in to the right company and work with colleagues in an accessible workbook. Participants, selected cells and saved versions provide context. Independent edits can merge; conflicting changes need attention. Collaboration is not a promise that conflicts never occur.
06
Import and portability
Open supported XLSX, ODS and text-based tables as copies. Export a workbook or an individual sheet; native JSON is available for a model backup. Office-format interoperability is partial, so complex workbooks should be checked after transfer.