Highlights
- Understand key data table design rules
- Explore a table with bad design
- View how bad design affects data management
- Explore a table with good design
Good table design is essential for the proper operation of Excel’s data management capabilities including sort, filter, consolidation, grouping, validation, PivotTable and Power Pivot.
Planning table design is crucial to avoid future problems and challenges in managing data.
Table design must comply with key standards and consideration of how data will be used suiting end-user requirements.