Can you use Excel to do Data Analysis for non-trivial things?(like DC1)
Yes, actually. Even more if you learn some of its fancier features.
Last year, Alper (who was TA) gave in class tutorials on how to do data analysis and vis with excel and Tableau. He is much better with those tools than I’ll ever be.
He wrote up the guide for excel. It specifically designed to help students in this class for DC1. It was meant for the in-class demo, but it is useful on their own. I find it really interesting to see some of the things that can be done easily in excel.