MOAR Data Analysis

Can we get some more data analysis classes? I haven't done big data yet so it may cover it but, macros, advanced formulas, advanced filters, and pivot tables would all be good to know. I just recently found advanced filters for cross referencing two or more rows of data and my formulas that I use for work are a bit off the wall... Ex.. =IF(IF(YEAR($AO$1)=2017,SUMIFS('2017 Level Finishing Yield'!B:B,'2017 Level Finishing Yield'!$A:$A,"="&$CE5),IF(YEAR($AO$1)=2016,SUMIFS('2016 Level Finishing Yield'!B:B,'2016 Level Finishing Yield'!$A:$A,"="&$CE5),IF(YEAR($AO$1)=2015,SUMIFS('2015 Level Finishing Yield'!B:B,'2015 Level Finishing Yield'!$A:$A,"="&$CE5))))=0,"",IF(YEAR($AO$1)=2017,SUMIFS('2017 Level Finishing Yield'!B:B,'2017 Level Finishing Yield'!$A:$A,"="&$CE5),IF(YEAR($AO$1)=2016,SUMIFS('2016 Level Finishing Yield'!B:B,'2016 Level Finishing Yield'!$A:$A,"="&$CE5),IF(YEAR($AO$1)=2015,SUMIFS('2015 Level Finishing Yield'!B:B,'2015 Level Finishing Yield'!$A:$A,"="&$CE5)))))

All it does is look for a specific year in AO1 to know which sheet to go to for the data and the cell CE5 is a specific date that it will find one that sheet. CE5 date changes with AO1 to where the cell with the formula and all the cells around it populate a single month of data and change all of the graphs on the sheet along with all of the other calculations for the months data; yield, totals, averages, by shift, by product, daily totals, monthly totals... You get it yet? AO1's date and this formula do a lot. Lol

I've also done a good bit with array formulas and date specific formulas like EOMONTH... I've pretty much done something with everything in excel except the higher math functions..

Except I don't know if I'm doing it efficiently or just flailing about.. I like to think I know what I'm doing.