Welcome to the CADTutor forum DesireeK.
I can heartily sympathize with your dilemma as we have recently purchased and started to use AutoCAD Electrical 2011. Right now we have one network license shared amongst two engineers and myself (the CAD guy).
I must agree ACADE can be overwhelming. It is definitely not that easy to understand upon first delving into it.
May I ask, did your company purchase a Subscription?
Since we wanted our electrical drawings to stand out from all our other drawings we (meaning me, myself and I...LOL) created some standard template files as our first order of business.
The blocks we have used have been primarily those supplied with the software although one of the engineers found that he needed to create some custom PLC blocks. I too experimented with creating a couple of custom symbols but it was more for educating myself than anything else.
We have not done any reports yet (I work for a chemical company and not an electrical design company) so I'll have to pass on the Excel templates question for the moment but I think I may be able to find an answer for you.
There are a handful (really, just a handful) of forum members who use ACADE but we'll do our best to help you through this.