Connect to Office in SharePoint 2013

Connect to Office gives you following Options to make SharePoint Sites Work with Office documents.These commands help you to interact with Office programs (Access, Excel, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word) and their corresponding file formats that may be stored in a library.
  • Add to SharePoint sites
  • Remove from SharePoint sites
  • and Manage SharePoint sites

 Steps

1. Navigate to Settings (Gear box )
2. Click Site contents
3. Go to the library where you want to set up the feature
4. Click on Library tab and find the connection settings as follows.
 
Attached is the screenshot showing the options. This lets you to work with office documents with sharepoint.Once you make changes in office, it just reflected here.
 
happy Sharepointing :-)