Excel doesn’t offer true tables, which are often ideal for complex data structures with interconnected entities. At times, you will often end up duplicating data across different spreadsheets.

I can view live database tables as familiar Excel worksheets, make direct edits as if I were updating any other spreadsheet, and filter data using the Excel tools I already understand.

Microsoft continues to take the Excel spreadsheet into the "third dimension" by putting vast amounts of live data into a single spreadsheet cell via data types. By Mark Hachman Oct 29, 2020 9:34 ...