How can I analyze large amounts of data in excel?
Pivot tables is the best way to analyze large amounts of data. We can go over this in greater detail of how to create/use pivot tables.
How do I prep for an interview?
To prep for an interview, begin with researching the company in great detail. Take some notes on the company offerings and what the position you are applying for entails. Be sure to come up with some questions to ask at the end of the interview that will show you have done some research. On the other side of things - be sure you have appropriate attire.
How would you go about studying for an upcoming exam that is primarily conceptual questions as opposed to memorization questions?
I would find someone who would be willing to let me try to explain something to them. If I can explain a topic to someone else, then I understand the topic conceptually as opposed to strictly memorizing something.