Prevent documents from opening in the browser from SharePoint 2013

I recently had a SharePoint document library that housed Excel files. The browser would try to open the file in a tab in the browser itself. However, an error would occur with the services that allow this to happen. So I decided to tell SharePoint that when a file is clicked on, open it using the client software if it is available. To do this, go to the library in question, and click Library Settings. Choose Advanced Settings and set "Opening Documents in the Browser" to "Open in the client application".

Sign in as a different user in SharePoint 2013

Microsoft took away the menu option to Sign in as a different user.  This was invaluable to test sites to make sure everything looked right for different users or to test access.  There are a couple of ways you can still do this.  You can append this to the site address:

/_layouts/closeConnection.aspx?loginasanotheruser=true

Or you can hold down shift while right clicking the Internet Explorer option.  Then choose Run as different user.  Then navigate to the site.