# Formulas to make my spreadsheet better

1. ## 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)
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

2. ## Re: Formulas to make my spreadsheet better

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!

3. 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

4. ## Re: Formulas to make my spreadsheet better

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.

5. ## Re: Formulas to make my spreadsheet better

Assuming you have data in flat table structure as recommended by 63falcondude.

I'd also recommend utilizing PivotTables and Pivot Chart along with slicers to connect multiple pivot tables & charts.

Using those, you can do away with most formulas used to summarize data and create dashboard quickly.

My two cents on Pie chart... unless you have 5 category or less and there is no need for comparison over time, don't use them, it's usually better to use horizontal bar chart, water fall chart, panel chart etc.

Also avoid use of 3d charts, they add no meaning to data and detracts from what's being presented.

6. ## Re: Formulas to make my spreadsheet better

Maybe it will help a little:

There are currently 1 users browsing this thread. (0 members and 1 guests)