Designing the Data Structure and Excel Tables
Organising data into Excel Tables with fixed columns and clear relationships, so formulas and reports work reliably.
Course contents
- 1Rules for organising data
- 2Converting ranges to Excel Tables
- 3Structured references
- 4Relationships between tables
- 5Data validation
What you gain from the course
You can organise the system’s data so that formulas and reports work without breaking.
Other courses in the same track
Stage 1: Foundation and planning
Analysing and Designing the Accounting System before Building
Defining the business’s needs and the system’s outputs and inputs, and mapping it out before opening Excel.
12 training hours
Building the Chart of Accounts in Excel
Designing a numbered, multi-level chart of accounts that underpins every report in the system.
12 training hours
Prompt Engineering for Building Accounting Systems
Writing precise prompts for AI tools to get usable formulas, code and designs.
12 training hours