I work on a daily basis with mass data dumps from several different types of data collection systems. I am essentially a data analyst and I present this large sums of data in a clean cut and organized matter based on several different criteria. Most of this organization can be done by filtering or using sumifs/ifs/vlookups/hlookups. Although, the extent of the data collection and organization has come to its extents.

I am begining to dig into the Index/Match Formulas where I can essentially take large amounts of data and reduce them in size on additional sheets.

What I am asking is for a solid learning platform on how to use the index/match functions.

I would like to be able to take data from one sheet and filter it down to a much smaller size based on specific criteria.

Any help/tools would be very useful

Thanks