EXCEL Help

Can anyone help me figure out the best way to do this. Is it as time consuming as I think? I've attached the spreadsheet given to figure the below question out. Would like someone to explain how to do this quickly as I have several other questions that are similar.

We want to conduct several analyses. Please perform the calculations necessary to complete each of the following tables.

1) Find the share of teachers within each grade-band who captured, but did not share.
2) Find the share of teachers within each grade-band who captured and did share.

Grade-band % Captured but did not share % Captured but did share
ES
K-8
MS
HS

AttachmentSize
Capture%20Report-2.xlsx117.62 KB