A few options: lenovo G560 15.6" $480 / lenovo Z565 15.6" $580 / MSI CX640 15.6" $600 / MSI FX420 14" $650
All have dedicated numberpads except the 14" MSI FX420
All have HDMI output for audio and video output to your HDTV except the lenovo G560
All will handle 1080p video playback. The lenovo G560 is slightly underpowered for flawless playback but fine for most common DVD videos. The Z565 is slightly better while the MSI CX640 & MSI FX420 have dedicated video cards for flawless playback (and some some light 3D gaming).
The Z565 is slighly underpowered in CPU performance. G560 is slightly better while the two MSI notebooks have an entry level Sandy Bridge CPU which are probably the best choices for moderately heavy duty Excel work.
Battery life should be around 4-4.5hrs in battery saving mode. With Wifi/web browsing or moderate Excel work it's probably more like 3.5-4hrs. For anything longer than that you'll want to look at more expensive, longer life models. Or order a custom laptop with a long life battery.
Of the ones listed here I like the MSI CX640 15.6" $600 best for what you want to do.
There are other options in the same price range ($600-$650) with the same relative performance. MSI CX640 15.6-inch Notebook Review
(different CPU in the review but all else should be the same).