Formulas to make my spreadsheet better

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

Originally Posted by AliGW

You should look up (online) and try using:

VLOOKUP/HLOOKUP
INDEX MATCH
COUNTIFS
SUMIFS

For what you want to do, based on what you have said, these should just about do it. Good luck!

Will do
Thanks for your help

Also, make sure that your raw data is laid out in a way that makes it easy to analyze.

This means to have one row for headers (usually row 1) and the data going downwards.