I want to create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013,by default once enable the content type in Advance settings,we can able to see the Word content type,In site settings->site content types i can able to create new content types,but by default word content type is coming,how to change to Excel,PowerPoint,One Note documents.
Created custom content types and follow the above article to add the powerpoint, excel and onenote in the appropriate content type section
I'm not sure I entirely understand the question, however there are a couple of points (assuming I'm understanding it a little).
Firstly, if you are looking to be able to show the OOTB meta that is shown in the excel docs etc.... then just create the meta data columns in the Content Type (you need to make sure it's named exactly the same, and is also the right type.) I've done this before and it pulls all of the properties in without any issue.
Secondly, and I doubt this is what you were asking, but in relation to the default Content Type, in the List Settings: 1. Turn on Content Types in Advanced Settings 2. Add multiple CT's (add from existing content types) 3. Then reorder the content types
Thirdly, in the list view, make sure you are clicking the drop down arrow under the New Item button or you won't get the list of alternative content types.
I may not provide the answer you are looking for, but why would you want to create a content type for different types of MS Office files? Content types are designed for different types of content, where each type will get its own metadata (columns). Word document could be a number of different content types (invoice, proposal, agenda) and each will get their own metadata.
So if you are after creating unique content types, I suggest looking at different types of content and creating content types for those. And if you need to sort and filter by MS Office files, you can do so with an existing (file) type column that is available out of the box in SH2013