www.office.com/setup Blogs: Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon. Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in. Updates include the following new or improved data connectivity and transformation features: Web Connector-UX support for specifying HTTP Request Headers. OData Connector-support for "Select Related Tables" option. Oracle Connector-improved Navigator preview performance. SAP HANA Connector-enhancements to parameter input UX. Query Dependencies view from Query Editor. Query Editor ribbon support for scalar values. Add custom column based on function invocation. Expand & Aggregate columns provide support for "Load More" values. Convert table column to a list-new transformation. Select as you type in drop-down menus. WEB CONNECTOR-UX SUPPORT FOR SPECIFYING HTTP REQUEST HEADERS With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog. november-2016-updates-for-get-transform-in-excel-1 - www.office.com/setup ODATA CONNECTOR-SUPPORT FOR "SELECT RELATED TABLES" OPTION In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports. november-2016-updates-for-get-

www.office.com/setup Blogs: Today's post was written by Kirk Koenigsbauer, corporate vice president for the Office team. We are excited to announce that the Cloud Storage Partner Program (CSPP) is now available for the Office apps on Android devices. Office on Windows desktops has long supported partner integrations that let you open and edit documents from a wide variety of storage locations. The CSPP, previously available for Office on iOS and Office Online, ensures that Office is the best way to get work done on all platforms, wherever your documents are stored. It's easy to add a cloud storage provider from the Add a place menu in the latest versions of Word, Excel and PowerPoint on Android. Then you can edit and share your documents stored with that provider as easily as you do with those stored on OneDrive. You can also launch Word, Excel or PowerPoint directly from the cloud storage provider's app to edit your files, with changes automatically saved back to the cloud. new-cloud-storage-options-for-office-on-android-1 - www.office.com/setup Blogs Now you can add cloud storage providers in Word, Excel and PowerPoint on Android devices. Today, the list of available cloud storage options in Office for Android includes Dropbox, Box, Egnyte and 腾讯微云 (Tencent). We'll add Citrix ShareFile, Edmodo and Learnium soon, and that list will continue to expand over time. Stay tuned for more.

www.office.com/setup Blogs: Good Morning America's newest segment, "Boosting Your Business," sponsored by Microsoft Office, provides entrepreneurs with simple tips and tools to help grow their businesses. In this first segment, Good Morning America brought in Carol Roth, a small business expert and host of Microsoft's Office Small Business Academy, to visit a popular Chicago salon. Living out the American dream, Goran Cobanovski opened his own hair salon after arriving in the U.S. from Macedonia, where his flagship location now employs a team of 18 people and serves up to 50 clients a day. Carol gives Goran advice on employee engagement, delegating responsibilities and scheduling appointments. She shows him how Microsoft Bookings can make front-desk scheduling run more efficiently-creating happier customers. Microsoft Bookings is a new service as part of Office 365 that allows customers to book appointments online directly through your website or Facebook page. Unique vision and unquestionable talent made Goran's dream his reality. Microsoft Office will give him more free time to enjoy it. Register for the Office Small Business Academy webcast series to get more tips and tricks to help you start, grow and manage your business.

www.office.com/setup Blogs: The following post will document how to setup a Windows 8 desktop for a cloud user for Office 365. I have already installed Windows 8 and created the local account for my test user. I have logged into the Office 365 portal and had the user change his password. The password for Office 365 and the password for the desktop are the same. Login to the desktop www.office.com/setup Click Desktop tile Open Internet Explorer Open the Office 365 Portal Site Login with the user account www.office.com/setup Click the gear icon Click Office 365 Settings www.office.com/setup Click Software www.office.com/setup INSTALL OFFICE Select 32-bit or 64-bit installation of Office Click Install www.office.com/setup Click run on the Office installer www.office.com/setup Click Yes to the UAC www.office.com/setup The installer will start to run www.office.com/setup Minimize Internet Explorer (but keep the page open) Click Next www.office.com/setup Accept or Deny the Office improvement www.office.com/setup Click Sign in www.office.com/setup Enter your Office365 Email account Click Next www.office.com/setup Click Organizational Account www.office.com/setup Enter your Office 365 password Click Sign in www.office.com/setup Click Next www.office.com/setup Select a look for Office Click Next www.office.com/setup The Office installation will finish up www.office.com/setup Completed www.office.com/setup SETUP OUTLOOK Navigate back to the start screen www.office.com/setup Click Outlook 2013 Click Next to add your email account www.office.com/setup Yes (default) Click Next www.office.com/setup Enter your Name, Office 365 email address and password Click Next www.office.com/setup Verify that you get three green checks and you are all setup Click Finish www.office.com/setup Outlook will launch and download any email that you have www.office.com/setup SETUP LYNC N