Excel dashboard creation

I need to create an excel Dashboard where I can import 1 sheet of data and have the dashboard populate based on the imported sheet. The dashboard will need to have three elements. 1st element: Unique Hosts by Computer name 2nd element: Unique Publishers For the 1st and 2nd elements, the formula will focus on a specific column in the data sheet and will need to deduplicate the column, ignore blank cells in the column, and count unique items. That unique number will go on the dashboard as well as a description. Unique Hosts by Computer name will focus on column C. Unique publishers will focus on column E. 3rd element: The dashboard will also need to have a pie chart. To get the data for the pie chart I need to deduplicate the table based on column C and then count the unique items in Column B without altering the two previous count elements, Unique Hosts by Computer name & Unique Publishers. **I will send the excel file to create the dashboard once the project is accepted.**