Interactive Weekly P&L

Project Goal : to provide a simplified weekly P&L status report showing performance across countries and company entities. The report has to be dynamic and allow the users to filter by country, entity type and entity code.

My report design is inspired by 'Advanced Excel Dashboard Design' final project and uses techniques I learn during this course.

The report was created in Excel using advanced array functions. It also utilises VBA code to extract and transform the data.