Forum Discussion
Showing entire tables
First, it's a common newbie mistake to make separate files with even separate tables in each file (as your image shows). That is organizing your raw information so that it's clear to humans. But it actually interferes with Excel's abilities to parse all that info if it were placed in a single database, single table. Just have one column that represents whichever division is applicable to the row, and another column that represents whichever campaign is applicable to the row.
Excel could then easily extract data for a given campaign and produce a summary report, or it could compare campaigns 1 and 2 across the company, etc.
So first. piece of advice: put all that data into a single table using columns to differentiate what are now separate sheets and separate tables within each sheet.
Then familiarize yourself with
- Pivot Table
- the new Dynamic Array functions (here's a helpful YouTube video on the latter) https://www.youtube.com/watch?v=9I9DtFOVPIg
Excel can work wonders with databases. Do what you can to get out of the way, to design your raw data so as to facilitate that.
First, it's a common newbie mistake to make separate files with even separate tables in each file (as your image shows). That is organizing your raw information so that it's clear to humans. But it actually interferes with Excel's abilities to parse all that info if it were placed in a single database, single table. Just have one column that represents whichever division is applicable to the row, and another column that represents whichever campaign is applicable to the row.
Excel could then easily extract data for a given campaign and produce a summary report, or it could compare campaigns 1 and 2 across the company, etc.
So first. piece of advice: put all that data into a single table using columns to differentiate what are now separate sheets and separate tables within each sheet.
Then familiarize yourself with
- Pivot Table
- the new Dynamic Array functions (here's a helpful YouTube video on the latter) https://www.youtube.com/watch?v=9I9DtFOVPIg
Excel can work wonders with databases. Do what you can to get out of the way, to design your raw data so as to facilitate that.
- Who knew thinking like a human could be a problem ! Thank you for the insightful answer, i will try to re-organize everything into one table.
