How much of Excel do you need to know to be considered proficient in it? In particular how many function do you need to know?

There is not much in excel you need to know. If you just learn the basics of the program, you can get a lot done.