If you don’t need to make a data visualization, you can also create a table in Excel using preexisting data. There are two ways to format a data set as a table:
- Manually: In this example, we manually added data and formatted as a table by including column and row names (products and years).
- Use Excel’s Format as Table Preset: You can also input raw data (numbers without any column and row names).