Hi all.

I have to create a spreadsheet for a course I am on. The task I need to do is all about data analysis. I work at a youth club so am going to analyse our members ( this was the only thing me and my assessor could think of)
My spreadsheet contains:
First and Last names of all members
their date of birth and current age
Their ethnicity
what area they come from
What school they attend.

So Far I have made pie charts with percentages of kids from different schools, I have created bar charts for the age ranges. Filtered and sorted the data and used a few COUNTIF formula to determine how many kids there are in each age range.

I don't use Excel that often so was looking for recommendations of any formulas I can use to gain a better insight into the data
Ive heard of all these Pivot Tables and Vlookup but don't really know how to use them or if I can use them for this info.

Any help appreciated
Thank You

Abbylea