Chapter 2 of 4
Workbooks
Create workbooks, insert live data from Business Central, and keep them refreshed.
In this chapter
- 01Workbooks and live dataCreate workbooks in Business Central or import them from Excel, organize them in folders, then insert live data tables, reports and charts and refresh them.
- 02Live table editingPut a Business Central table in a sheet, type changes in the pencil columns, check them with Business Central validation, then apply them with an audit log.
- 03Bulk changes with a formulaChange many Business Central records at once: fill one formula down a data table, let Business Central check every row, then apply the changes that pass.
- 04Spreadsheet essentialsFormat, sort, filter, find and replace in a Bitta Sheets workbook, with Business Central number formats, frozen headers, zoom, full screen and shortcuts.
- 05Pivot tables on live dataSummarize any Business Central table in a pivot table: rows, columns and values with totals, quarters, top N with Others, and a drill-down on every number.
- 06Charts and KPI cardsAdd charts and KPI cards to a Business Central workbook: chart live data or cells, click a column to drill down, and show a KPI as progress to its target.
- 07Cell controls and input rulesAdd checkboxes, drop-down lists and date pickers to a Business Central sheet, set rules for what people type, and highlight values with conditional formatting.
- 08Document and journal linesEdit the lines of Business Central sales and purchase documents and general journals in a sheet: change, add and delete lines, checked like the page.
- 09Organize workbooks and sheetsOrganize Business Central workbooks in Bitta Sheets with folders, views, favorites and properties, and insert, rename, color, hide or delete sheets.
- 10BC functions and filtersBuild a Business Central month-end pack in Bitta Sheets with live BC functions, one month filter, a data table that follows it, and a refresh.
- 11Series, queries and report dataBring more Business Central data into a sheet with Bitta Sheets: date and FlowField series, a query result, and a report dataset with its request page.
- 12Connected tables and SQLJoin related Business Central tables in a sheet without SQL, run SELECT queries with cell parameters, and put SQL and AL formulas in a single cell.
- No steps for this role in this part of the guide. Choose All to see every step.
next step