Group items tagged

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-

The U.S. Environmental Protection Agency expects to save $12 million over four years. The City of Chicago anticipates saving $1.3 million over the same length of time. And the State of Minnesota expects to save at least $800,000. Governments of all sizes are finding ways to reduce IT costs while improving efficiency. What's their secret weapon? With public sector budgets shrinking in many places around the globe, smart governments are making taxpayer dollars stretch further by migrating from an on-premise environment to Microsoft Office 365 in the cloud. By moving to Office 365, governments can reduce both their capital and operating costs. And by saving money, they can make taxpayer dollars go further during a time when budgets are tight and there's often less revenue to work with. So how exactly can Office 365 save governments money? First, governments can cut back on the capital cost of investing in more computer servers. Second, they can reduce the administrative cost of having to maintain an IT environment. Third, they can lower their energy costs by reducing the size of their data centers. And they can also reduce costs using the many tools within Office 365 that improve employee efficiency. According to a study conducted by Forrester Consulting, Office 365 delivers an ROI of 321 percent with a payback period of two months for a composite midsize organization. That translates into huge value for public sector organizations! Among the government agencies that anticipating money saved by implementing Office 365 is the Environmental Protection Agency. The agency expects to save $12 million over four years by moving to the cloud and Office 365. Some of those savings will be in energy costs as the agency relies on Microsoft to operate its data centers. "The EPA will continue to lead the pack on environmental stewardship, and moving an IT environment to the cloud is a natural part of that," says Greg Myers, vice president of Microsoft Federal. "There

Over the past few months, customers across the globe and from a wide range of industries have chosen Office 365 to communicate and collaborate more effectively using familiar cloud based applications they know and trust. The retail industry is using technology more than ever to stay competitive while better serving the needs of their customers. In January we shared how large companies like Tescoand Helly Hansen have joined other notable brands such as, 'wichcraft, BCBG, and Sephora who are moving to Office 365 for security-enhanced access to the familiar productivity tools they rely on at all levels of their business. Office 365 has become the go-to-choice for retailers looking to move their productivity to the cloud - in fact, our retail customers employ more than 8 million people worldwide, more than the total population of Hong Kong!

Today's guest blogger is Javier Vasquez, Senior Director of Productivity Sales, State and Local Government at Microsoft. For the past 15 years, Javier has helped public sector customers implement solutions that help them realize value in their technology investments. As government agencies prepare for this week's Lean Government Virtual Summit, cloud innovation will surely be a hot topic. So why should governments choose Microsoft Office 365 as they consider moving their productivity software to the cloud?

Bassier, Bergmann & Kindler (BB&K) is one of Germany's largest digital media agencies and works with many major brands across much of Europe. Distributed clients means decentralized teams, so BB&K relies on technology for communication, collaboration, and knowledge management to achieve success of over 500 projects each year. Until recently, BB&K used a home-grown solution to keep teams on the same page and projects delivered on time, but growth introduced complexity, and it was recently evident that a more powerful solution was needed.

Today's post was written by Nick Portello, Network Manager, Steve Moore Chevrolet. Read more Office 365 customer stories here. Office 365 Customer Steve Moore Chevrolet_Nick PortelloWhen I joined Steve Moore Chevrolet as the sole IT staffer six months ago, the dealership was in dire need of new technology. Employees coped with aging PCs, an outdated POP3 email service, a poor mobility experience, data loss, and no collaboration tools. Then I heard about Microsoft Office 365, which gives you the latest version of Microsoft Office, plus a suite of cloud-based communication and collaboration tools that solved all our problems. Unlike Google Apps, the UI was familiar to our employees and Microsoft offered a flexible subscription-based payment option, which is ideal for our fluctuating workforce. Now that our documents are stored in Microsoft SharePoint Online and SkyDrive Pro, we have easy access to collaboration tools with robust security. I no longer worry about falling out of compliance with Chevrolet auditors, losing important financial data, or having to pay fines that could reach $250,000. I can also find data on-demand for Chevrolet auditors and use my mobile device to look up information, which saves about 40 percent of every day-I'm no longer running between my computer and the sales, service, and administration departments. I can focus on what I really need to do. Thanks to Office 365, we are all able to get on with our work! Learn more about Steve Moore Chevrolet and Office 365 by watching the video below and reading the case study.

Microsoft Corp. announced today that the power and automation technology company ABB will deploy Microsoft Office 365 and Yammer to its employees worldwide. With about 145,000 employees in 100 countries, ABB is transitioning from multiple IT collaboration and messaging solutions to Office 365 to provide a single solution for productivity, communication, collaboration and enterprise social in the cloud.

A must watch documentary on kids and online behaviors