Publish Excel Sheets to SharePoint 2010

Step 1)  Create Excel file with two sheets
            in Sheet1 

in Sheet 2

               
Step 2)  Publish to SharePoint
                 (Assuming Excel Service is added to Website & service is up&running)

Click on "Save to SharePoint"->Click on "Save As"         
Step 3)  Enter ur website  address  in this case http://sp2010:27657/Shared Documents/
              Iam going to publish to Shared Documents in Sp2010:27657 site.

Step 4) Now goto  http://sp2010:27657/Shared Documents/
              Sales-details.xlsx will appear

     
Step 5)  It should be added to Trusted Location in Central Administration, so that user can open/access the data.,

Step 6) Goto Central Administration --> click on "Application Management"-->Manage Service Applications(Under Service Applictaions)--> Click on "Excel Service Application"--> Click on "Trusted File Location-->

//Add site address itself. so that excel can be published any document library in that site.
//so  address is http://sp2010:27657
//Check  "Children Trusted"  i.e it trusts all document libraries in the Site.
//Leave remaining all default
//CLick OK

Step 7) Now goto Site http://sp2010:27657
 Click on   Sales-Data.xlsx in Shared-Document library.

Step 8) Output  ,  Sales-data.xlsx will be opened in Browser. As shown below