Both words have many, many uses, so please start with your dictionary. However, I can tell you that when referring to locations, 'at' refers to a 1-dimensional (point) location (Where is Bill? - He's at school) and 'in' refers to a 2- or 3-dimensional location (Is Bill on the playground?
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.