Question: how to create relational databases in excel 2013?
Answer: Create the master table.
Highlight and name the table.
Create the detail (Sales) table.
Highlight and name the detail (Sales) table.
Insert and create the Pivot Table.
Select fields from sales and master tables, then create relationship.
Total sales by city report.