The CEL can be reset without a scan tool by removing the #13 fuse from the passenger side fuse block (located near the floor in the footwell). Replace it after it has been out for at least 10 seconds. This worked on my 2004 Pilot.
You will need a scan tool to reset your light. All post 1997 obd2 vehicles will require the light to be taken off manually with a scan tool. Some vehicles might reset the light after a certain amount of ignition cycles unless its a hard fault code or it sees the problem again.