Office 365 ProPlus updates

www.office.com/setup – Today’s post was written by Ron Markezich, corporate vice president for the Office commercial marketing team.

www.office.com/setup – Office 365 ProPlus delivers cloud-connected and always up-to-date versions of our most valuable enterprise apps. Today, we’re making three important announcements related to ProPlus: changes to the Office 365 system requirements; improvements to the ProPlus update model, including alignment with Windows 10; and new tools and programs to manage ProPlus application compatibility.

Changes to the Office 365 system requirements

www.office.com/setup – Office 365 ProPlus is the very best way to experience the Office 365 services. For IT, ProPlus delivers the most secure and most complete suite of productivity apps available. And because the apps are cloud-connected and always up-to-date, they’re continually getting better—with new security features, new telemetry and new management capabilities. For end users, ProPlus brings the Office 365 services to life. When a modern app is connected to a modern service, magic happens. People can collaborate in new ways. Apps can simplify mundane tasks. And advanced security services can protect users as they work.

www.office.com/setup – When customers connect to Office 365 with a legacy version of Office, they’re not enjoying all that the service has to offer. The IT benefits—particularly security—are cut short. And the end user experience in the apps is limited to the features shipped at a point in time. To ensure that customers are getting the most out of their Office 365 subscription, we are updating our system requirements.

  • Office 365 ProPlus or Office perpetual in mainstream support required to connect to Office 365 services.Starting October 13, 2020, Office 365 ProPlus or Office perpetual in mainstream support will be required to connect to Office 365 services. Office 365 ProPlus will deliver the best experience, but for customers who aren’t ready to move to the cloud by 2020, we will also support connections from Office perpetual in mainstream support.
  • Applies to Office 365 commercial services only. This update does not change our system requirements or support policies for the Office perpetual clients, Office perpetual clients connecting to on-premises servers, or any consumer services.
  • More than three years’ notice. We’re providing more than three years’ notice to give IT time to plan and budget for this change. Until this new requirement goes into effect in 2020, Office 2010, Office 2013 and Office 2016 perpetual clients will still be able to connect to Office 365 services.

Visit our Office 365 Tech Community to learn more and to ask the experts your questions.

Improvements to the Office 365 ProPlus update model, including alignment with Windows 10

www.office.com/setup – Moving to Office 365 ProPlus requires an initial upgrade and ongoing management of regular updates. Customers quickly see the benefits of the move, but they’ve also asked us to simplify the update process—and to improve the coordination between Office and Windows. To respond to this feedback, we’re pleased to announce that we will align the Office 365 ProPlus and Windows 10 update model. This change will make planning and managing updates for both Office and Windows easier for customers using the Secure Productive Enterprise.

Targeting September 2017, we will make the following changes to the Office 365 ProPlus update model:

  • Two updates a year. We will reduce the Office 365 ProPlus update cadence from three to two times a year, with semi-annual feature updates to Windows 10 and Office 365 ProPlus targeted for March and September.
  • 18 months of support. We will extend the support period for Office 365 ProPlus semi-annual updates from 12 to 18 months (starting from first release) so IT professionals can choose to update once or twice a year.
  • System Center Configuration Manager support. System Center Configuration Manager will support this new aligned update model for Office 365 ProPlus and Windows 10, making it easier to deploy and update the two products together.

See the upcoming changes to the Office 365 ProPlus update management article to learn more.

New tools and programs to manage Office 365 ProPlus application compatibility

One of the biggest concerns customers have about the move to a new version of Office is application compatibility. Office add-ins and VBA solutions often play a significant role in key business processes, and application compatibility is an important consideration in both upgrades and updates. To help customers manage ProPlus application compatibility, we’re pleased to announce four new investments.

  • Upgrade assessment tools. Starting today, we’re offering a limited preview of new tools that will catalogue the add-ins and VBA solutions in use in your organization, identify potential issues with the upgrade to Office 365 ProPlus, and recommend steps for remediation.
  • Application compatibility testing. For each new Office 365 ProPlus release, we will perform compatibility testing of the most common third-party add-ins, identify potential issues, and take steps to remediate.
  • Office 365 ProPlus monitoring services. We will provide new services to monitor your ProPlus deployment and provide visibility into the usage and stability of apps and add-ins.
  • Reporting, tracking and resolving issues. We will improve our existing service for reporting, tracking and resolving application compatibility issues—and partner with customers and ISVs to find the best approach to remediation.

You can learn more about the upgrade assessment tools today, and we’ll have more to share on our application compatibility testing program, the new Office 365 ProPlus monitoring services and the new service for reporting, tracking and resolving issues in the coming months.

We are here to help

If you’re connecting to Office 365 with a legacy version of Office, you’re not enjoying all that the service has to offer—and we’re here to help. For more information on Office 365 ProPlus deployment, refer to the Office 365 ProPlus Deployment Guide and the ProPlus Ignite On-Demand sessions. And when you’re ready to make the move to ProPlus, the Microsoft FastTrack customer success service will help you with the details. Visit the FastTrack website to learn more and submit a request for help with planning, assessment and deployment. ProPlus is the very best way to experience the Office 365 services, and we’re committed to helping you upgrade with confidence.

Ron Markezich

SharePoint Virtual Summit showcases growth, innovations and customer success

www.office.com/setup – Today’s post was written by Jeff Teper, corporate vice president for OneDrive, SharePoint and Office.

www.office.com/setup – Today, during the SharePoint Virtual Summit, we unveiled the latest innovations for SharePoint and OneDrive, including powerful integrations across Office 365, Windows and Azure.

www.office.com/setup – These developments build upon the vision we unveiled last year, and have been delivering on since, with innovations to reinvent content collaboration and usher in a new generation of mobile and intelligent intranets. We also showcased Office 365 customers who are using SharePoint to accelerate their digital transformation.

SharePoint continues to gain momentum

With more than 100 million monthly active users, Office 365 provides the most complete, intelligent and secure service for communications and collaboration. SharePoint plays an important role in Office 365, empowering customers to share and manage content, knowledge and apps to create a more connected workplace.

As customers transition to the cloud, we’re seeing tremendous adoption of SharePoint:

  • More than 250,000 organizations and over 85 percent of Fortune 500 companies now have SharePoint as part of Office 365.
  • In the last year, usage of SharePoint has grown 90 percent, content stored has grown 300 percent and more than 10 million new SharePoint sites have been created.
  • More than 60 percent of SharePoint seats are now online, reflecting the value customers see with SharePoint in Office 365.

We unveiled many innovations across SharePoint and OneDrive. Here’s a look at the four headline announcements.

Share files directly from File Explorer on Windows and Finder on Mac

OneDrive lets you share files securely with anyone—inside or outside your organization. Its deep Office integration, which powers rich co-authoring, allows you to collaborate on these shared files with others in real-time. And it lets you access all your Office 365 files, including your individual work files and files shared with you by individuals, teams and the organization—regardless of whether you’re on a PC, Mac, an iOS or Android device or a Windows phone.

Building upon last week’s announcement of OneDrive Files On-Demand—which lets you work with all your files within File Explorer on Windows 10—we announced today that starting this summer you will be able to share Office 365 files directly from File Explorer on PC and Finder on Mac. The sharing experience has been simplified, so you can share a file or folder with specific people or send a link that enables anyone who needs access, inside or outside your organization. In addition, you can now control how long a link provides access, and you can easily view and modify the permissions you have granted. The new sharing experience is the same, whether you share on the web, in Explorer on Windows 10 and Windows 7, or in Finder on Mac.

www.office.com/setup

Share files and folders with colleagues inside and outside your organization directly from File Explorer on Windows 10 and Windows 7.

www.office.com/setup

Share files and folders with colleagues inside and outside your organization directly from Finder on Mac.

Innovations that we’ve released over the last year and announced today are sparking customers to choose OneDrive over other file storage and sharing solutions. Read “File sharing and cloud storage with OneDrive and Office 365” to learn more.

Inform and engage employees with SharePoint communication sites

As the next step toward ushering in the next generation of intranets, today we announced SharePoint communication sites, coming this summer. A communication site is a beautiful, dynamic site that lets you reach a broad audience to keep the organization informed and engaged. Communication sites look great on the web, on a PC or Mac, on mobile browsers and in the SharePoint app.

www.office.com/setup

Easily create beautiful intranet sites to reach a broad audience across your organization.

While your team site lets you share within your group as you’re working, a communication site lets your group share broadly and communicate its message across the organization. News published on a communication site surfaces on SharePoint home in Office 365 and on SharePoint mobile to all users who have access to the site.

Communication sites can be created in seconds. You can configure the default web parts on your site’s pages to tell your story. You can customize page layout with new multi-column sections and drag-and-drop authoring with a range of richly functional web parts, including an image gallery, interactive Bing maps, videos from a Microsoft Stream channel and a new events web part.

Add the Yammer web part to a communication site to solicit feedback and foster conversation. Yammer adds a conversational layer to the intranet, so you can drive employee engagement and share best practices across the organization, right in the context of a communications site. To learn more about Yammer integration with SharePoint and other Yammer announcements made today, read “New in Yammer—building a more engaged and connected organization” and watch Updates to Yammer—integrating conversations into your SharePoint experiences.

Create custom SharePoint forms with PowerApps and automate approvals with Microsoft Flow

SharePoint enables you, your team and your organization to streamline tasks, automate workflows and integrate processes seamlessly into your work—on any device and from anywhere you work. Starting this summer, you will be able to use Microsoft PowerApps to easily create custom forms that surface right in the context of a SharePoint list or library. Users can then create, view and interact with data using your custom form, rather than default SharePoint forms. This is a significant milestone for both SharePoint and PowerApps, as it empowers any user to drive transformation of team and organizational processes.

Create custom forms inside SharePoint lists and libraries with no code using PowerApps.

We also continue to deepen integration of SharePoint and Microsoft Flow. New built-in approval flows let you send any document for approval with a custom message. The recipient can approve the request directly from a rich, actionable email message, so approval and feedback can be given without leaving your inbox.

Approval flows, built in to SharePoint, send a rich, actionable email message.

Find people, expertise and content with powerful, personalized search

Today, we announced a more personalized search that leverages machine learning and artificial intelligence from Microsoft Graph to surface more relevant and valuable results, faster. When you’re searching for knowledge, it may be found in content such as files, sites and news. And it might also be found through your colleagues. Now, your search results will include people whose skills, interests and projects—part of their Office 365 profile—are relevant to your query.

Search results activate people cards, so you can learn at a glance about a person and the content they work on. One more click activates an extended view with richly detailed information from the user’s profile. These enhancements to search are rolling out over the next few months.

Showcasing customer success

These innovations illustrate our commitment to reinventing productivity, so that you, your teams and your organization can achieve more. Today, we showcased customers like DBSAvanadeShire and Fourlis who use SharePoint and OneDrive to achieve more. We’re honored to have them join the growing ranks of customers who are sharing their stories of success, including RackspaceThe Hershey CompanyNASCARQantasT-Mobile and many more.

The headline announcements I’ve shared here are but the tip of the iceberg. At the SharePoint Virtual Summit, we announced dozens of innovations that will help you accelerate your digital transformation in the year ahead. To learn more about the new capabilities across SharePoint and OneDrive, and the transformational outcomes they drive, read “New SharePoint and OneDrive capabilities accelerate your digital transformation.”

—Jeff Teper

U.S. Government Community Cloud customers get advanced Office 365 capabilities

www.office.com/setup

www.office.com/setupMicrosoft loves their security. So much, in fact, that they’ve been approved at the highest security clearance allowing them to create some of the best software available for the U.S. Government. Today, the Office 365 team announced that their software and apps have taken it a step further with some new capabilities and features that make connecting official agencies together more secure and efficient.

www.office.com/setup – First off, the Skype for Business cloud-based voice, video, and meetings is completely changing the way that agencies can communicate. Compared to the more traditional methods such as phones and meetings, the additions of PSTN Conferencing, Cloud PBX, and PSTN Calling can make connecting a bit more impromptu.

  • PSTN Conferencing—Provides the ability to dial in to a meeting from a traditional phone, as well as the option to join a meeting with a single click on your PC or mobile device.
  • Cloud PBX—Enables companies to eliminate separate PBX systems and transition to the cloud with Office 365 as the central location to manage users for communication.
  • PSTN Calling—Gives Office 365 customers the ability to subscribe to Microsoft-managed calling plans and phone numbers.

www.office.com/setupMicrosoft is also boosting the U.S. Government Community Cloud security with a Customer Lockbox that adds new permissions and transparency, Advanced eDiscovery with Equivio machine learning, and Advanced Threat Protection.

www.office.com/setup – Additionally, the Power BI Pro and Microsoft MyAnalytics will help agencies get a better visual of their data through insights.

www.office.com/setup – These top-tier capabilities will be available to U.S. Government Community Cloud in Office 365 soon, if not today.

Microsoft Teams app gets voice calls on iOS

www.office.com/setup

www.office.com/setup – The iOS Microsoft Teams app has updated to Version 1.0.5 and can now support audio calls which can be activated either from within a chat or from a contact card. The update also squashed several undefined bugs and made several improvements which are also not specifically detailed in the release notes.

www.office.com/setupMicrosoft Teams is an app that’s available on iOS, Android, and Windows 10 Mobile devices and can be used for collaborating and coordinating between team members. Here are some of its features:

  • Work with your team’s documents on the go
  • Move seamlessly across different team projects and topics
  • Mention individual team members or your entire team to get attention
  • Chat privately one-on-one or have instant group conversations
  • See real-time chat history on your favorite device and continue conversations started elsewhere
  • Chat with your entire team in dedicated channels
  • Quickly search through your chats and team conversations
  • Find a contact through name or email address search

www.office.com/setup

Several Microsoft Android apps get Office Lens support in new update

www.office.com/setup

www.office.com/setupMicrosoft has updated their Powerpoint, Word, and Excel Office apps for Android devices today. Word and Powerpoint now both support Office Lens functionality which means users can use the device’s camera to directly take photos and import that media within the Office files being edited.

www.office.com/setupPowerpoint has also had its sharing improved and no longer requires users to send an entire slideshow when sharing. A single slide can now be selected. Excel can now open files that contain form controls. That may not be a feature that the average user would need but it does have its uses and is good to see added to the Android mobile app.

www.office.com/setup

www.office.com/setup

Microsoft makes managing online classrooms easier with School Data Sync for Office 365

www.office.com/setup

www.office.com/setupMicrosoft today has announced that it is making the managing of online classrooms easier thanks to the power of School Data Sync for Office 365. The announcement was made in a post to the Office Blog by Tim Richardson, lead program manager for School Data Sync.

www.office.com/setup – In the post, Tim Richardson addresses that  School Data Sync (SDS), the online classroom automation solution, moved out of preview and is now generally available. To access the feature, and receive help from Microsoft in deployment, educators and IT admins are urged to fill out a request form. The feature can be used in nearly every country where Office 365 Education is available. It is described:

SDS helps schools automatically create online classrooms in Office 365 from their Student Information System (SIS or MIS). SDS supports virtually every SIS on the market, and hundreds of customers in over 20 countries have already used it to sync over 100,000 teachers and 2 million students.
SDS imports user profiles and rosters from a SIS into Office 365 and automatically keeps them up to date. Schools often find it can be costly and time-consuming to maintain the online classrooms because rosters naturally change throughout the year. With SDS, IT admins can save time creating online classrooms, and teachers can enjoy online classrooms that are up and running with students on the first day of the term.

www.office.com/setupMicrosoft notes that SDS was designed to make life easier for the entire Office 365 ecosystem since SDS saves time for IT admins and teachers, who get more time back for classroom instruction. According to a case study, SDS also keeps students safe since Students with Office 365 Education can use Microsoft Classroom Preview and email to communicate with each other.

www.office.com/setup – IT admins can sign up for SDS here, install the SDS toolkit, watch an SDS demo, or download SDS sample data scripts. Teachers, meanwhile, can visit the Microsoft Classroom Preview website to learn more about SDS, and watch deep dive videos to learn how the Microsoft Classroom works.

www.office.com/setup

SharePoint communication sites begin rollout to Office 365 customers

www.office.com/setup – During last month’s SharePoint Virtual Summit, we unveiled SharePoint communication sites—beautiful, dynamic sites that let you reach a broad internal audience, and that look great on the web, in the SharePoint mobile app, on PC and on Mac.

www.office.com/setup – Today, we’re excited to announce that communication sites are now rolling out to Office 365 First Release customers, followed by full worldwide rollout to Office 365 customers in the coming months.

www.office.com/setup - Image scrolls through a SharePoint communication site in desktop view.

Create a beautiful communication site in seconds

www.office.com/setup – Communication sites are perfect for internal cross-company campaigns, weekly and monthly reports or status updates, product launches, events and more. To help you jumpstart getting your message out fast, communication sites provide configurable templates for the sites and pages within. When you click Create site from the SharePoint home in Office 365, you have a choice of three initial site designs:

  • Topic—Select the Topic design when you have a lot of information to share, such as news, events and other content.
  • Showcase—Use the Showcase design to feature a product, team or event using photos or images.
  • Blank—Start with a blank site and make your design come to life quickly and easily.

www.office.com/setup - Images showing how each of the different three site design options look on a desktop and mobile device.

Communication site designs (from left to right): Topic, Showcase and Blank.

www.office.com/setup – And it is easy to tell your story. Once your new site is created, simply drag-and-drop to reorganize web parts on the page to bring your use cases and scenarios to life. News and pages allow for multi-column layouts to represent your message in a meaningful, intuitive fashion.

www.office.com/setup – Learn how to create a communication site in Office 365, add a page and work with column layouts.

Share your plans and updates in engaging, interactive ways

Communication sites allow people to create and share recurring updates beyond email. When you create a page on a communication site, you can embed documents and video, and dynamically pull in real-time data from across Office 365, including documents from SharePoint, Power BI reports, Microsoft Stream videos and Yammer discussions. The resulting page is a rich and dynamic communication. And the page persists on the site, so people can refer to it easily, even as the membership of your team changes, so new members can more easily get up to speed.

www.office.com/setup - Image showing how a communication site displays all the data pulled in from Office 365, including news, events, key documents, resources and contacts.

The new capabilities for the rich section layouts and new web parts can be utilized on SharePoint team sites as well.

Consume, create and connect from your mobile device via the SharePoint apps

It’s easy to access, engage with and create content for communication sites from any device. The full site, pages, news, navigation, search and more are natively viewable, functional and engaging. Read a page, create a news article, engage in a Yammer conversation—all in the context of the site—from within the SharePoint mobile app experience.

www.office.com/setup - Image runs through a SharePoint communication site in mobile.

You can download the SharePoint mobiles apps for iOS and Android today, and the new features will be available in the coming weeks. Learn more about the SharePoint mobile app for iOSSharePoint mobile app for Android and SharePoint app for Windows 10 Mobile.

Communication sites help further refine and enhance your message

Beyond what we shared during the SharePoint Virtual Summit, communication sites have additional capabilities to further refine and enhance your message.

Make your home page and sub-pages look great

  • Full-width layouts—The Hero and Image web parts can be placed in a section layout that spans the page from left to right, giving you ways to emphasize your most essential information.
  • Enhanced title region with custom header image—Visually represent your home page, news and subpages with a compelling header graphic and title. You control what portion of the image is the most important, so it looks great, and as intended, across web and mobile experiences.

Continue the discussion in context to ensure reach, retention and engagement

  • Comments on pages—Each news article and page can have its own set of comments. It is possible to use the Yammer web part for broad discussion scenarios as well as targeted responses to engage your viewers on the sole message and content on the page—all keeping within the context of the page.
  • Share news via email—When you share news via email from a communication site, it’s not just a blue link; it’s a visual, informative preview that adds context to both the email and the news article itself. Within the email, the recipient(s) will see a thumbnail, title, description and an optional message from the sender.

Dynamically pull in and display data, documents and information via web part improvements

  • Power BI and Microsoft Stream—Bring in interactive reports using the Power BI web part, and embed single videos or full channels from Microsoft Stream—the single destination within Office 365 for your cross-company video management. Both Power BI and Microsoft Stream are now generally available.
  • GIF support—When you add an Image web part into a news article or page, you can now include animated GIFs in your layout.
  • New “See all” pages—When there is more content than can be shown within the first view the Highlighted content and Site activity web parts, you can click See all to go to a full-page experience to see all the content and activity.
  • Updated News web part—Showcase your news using multiple layouts to highlight what’s important with greater flexibility. You can use the default Top story layout, view news as a list or side-by-side.

Learn more about using web parts on pages and news, which highlights all web parts available in SharePoint Online.

Mark your calendars

Join us for one or more of our events in the coming days and weeks to share and explore the value of communication sites.

  • SharePoint communication sites AMA—On Wednesday, June 28, 2017 from 9–10 a.m. PDT, bring your questions and feedback to the SharePoint communication sites AMA within this dedicated SharePoint community space of the Microsoft Tech Community for SharePoint. We’re inviting our deepest business and technical subject matter experts for an active, informative hour—driven by YOU!
  • Jeff Teper takes over @SharePoint—On Tuesday, July 10, 2017 from 9:30–10:30 a.m. PDT, Jeff Teper, corporate vice president for SharePoint, OneDrive and Office, will take over the @SharePoint Twitter handle. He’ll tackle your questions and feedback both with written responses and video snippets as only he can—no tweet left behind!
  • LIVE customer + MVPs panel webinar—On Wednesday, July 13, 2017 at 8 a.m. PDT, join in to hear how one of our customers, Shire, successfully planned and implemented their new digital workspace—inclusive of communication sites. You will hear both from Shire employees and Office 365 MVPs. Register today.
  • On-demand webcast—On Wednesday, July 19, 2017, Farren Roper and I present the “SharePoint: Inform and engage your employees” business webcast. Be the first to be notified when it’s available: sign up today. And in advance, read the new, related eBook, “4 secrets to a connected workplace.”

Throughout the lifecycle of your projects, launches and internal campaigns, let the SharePoint intranet help you move seamlessly from concept to final product. The powerful, dynamic SharePoint user experiences let you clearly communicate your message throughout your company.

—Mark Kashman, senior product manager for the SharePoint team

 

Frequently Asked Questions

Q. How can I expect communication sites to roll out to Office 365 customers?

A. Communication sites will begin to roll out to First Release customers within the coming week—starting with First Release Select Users—and will be completed within 2–3 weeks. We are targeting end of August 2017 for complete worldwide rollout.

Q. When will the SharePoint mobile apps get updated to natively view communication sites?

A. We are planning to push updates to the SharePoint mobile app for iOS within a few days, and to the SharePoint mobile app for Android in the coming weeks. Install today. Update often.

Q. Can I use a communication site in an extranet scenario with external users?

A. Yes, communication sites will support external users for extranet use cases. Initially, Office 365 admins would need to enable it at the site level via PowerShell. We are working on the admin user interface to enable external sharing in a similar fashion as is done today for team sites.

June 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in

www.office.com/setup – Today, we released eight data transformation and connectivity updates for Get & Transform—a powerful set of Excel 2016 features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities.

www.office.com/setup – These updates—requested by many of our customers—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 also take advantage of these updates by downloading the latest Power Query for Excel add-in.

www.office.com/setup – These updates include the following new transformation features and improved data connectivity features:

  • New transformation features:
    • Add Column by Example.
    • Split Column (by Delimiter/Number of Characters) into rows.
    • Basic mode for Group By operation.
    • Extract Text Before/After/Between Delimiters.
    • Unpivot Only Selected Columns.
  • Combine Files experience—ability to reference first file as example.
  • New Go to Column in Query Editor.
  • SAP HANA Connector—enhancements to Parameter Input UX.

Add Column by Example

www.office.com/setup – With this update, we added a new capability to the Query Editor that allows you to create a new column by specifying a set of examples of the desired output. Based on these examples, Excel automatically detects and applies the required transformations.

www.office.com/setup – This is an innovative approach to defining query steps within the Query Editor, which simplifies the process for basic users, as they no longer need to come up with an algorithm or complex logic for how to transform or extract data from other columns or how to define those transformations in the Query Editor.

www.office.com/setup - Query Editor dialog is displayed with Add Column selected so user can add a column from an example.

Split Column (by Delimiter/Number of Characters) into rows

We added a new option in the Split Column by Delimiter and Split Column by Number of Characterstransformation dialogs that allows you to specify whether to split into new columns (previous default behavior) or split into new rows.

This new option can be found under the Advanced Options section in these two dialogs.

www.office.com/setup - The Split Column by Delimiter dialog is displayed with Advanced options highlighted.

www.office.com/setup - The Split Column by Number of Characters dialog is displayed with Advanced options highlighted.

Basic mode for Group By operation

The new Basic mode in the Group By transform dialog simplifies the experience to group by a single column and define a single output column. You can switch between Basic and Advanced modes within the Group By dialog by selecting the desired option at the top of the dialog.

www.office.com/setup - The Group By transform dialog is displayed with the Basic option selected. User can click the Advanced radio button to display the advanced options.

Extract Text Before/After/Between Delimiters

We added a new option to extract all text before, after or between delimiters from a Text column. You can find these new commands under the Extract drop-down menu on the Transform and Add Column tabs on the Query Editor ribbon.

www.office.com/setup - The Transform tab is selected, and the Extract drop-down menu is expanded to highlight the Text Before Delimiter and the Text After Delimiter options.

Unpivot Only Selected Columns

A new transform was added under the Unpivot Columns menu in Query Editor that allows you to unpivot only the currently selected columns in the Query Editor preview. This generates an explicit columns list in the current step so that the same set of columns is unpivoted on future refresh operations.

www.office.com/setup - The Transform tab is selected, and the Unpivot Columns drop-down menu is expanded to highlight the Unpivot Only Selected Columns option.

In addition to the newly added Unpivot Only Selected Columns option, you can also apply one of the following (and previously familiar) commands from the Unpivot Columns menu:

  • Unpivot Columns—This operation will unpivot all columns except all the non-selected ones. This case is optimized for scenarios where new columns that appear in the future need to be unpivoted as well. For example, datasets where new columns represent data for new dates (i.e., monthly sales, weekly occurrences, etc.).
  • Unpivot Other Columns—This operation provides the same capability as Unpivot Columns in terms of future behavior with respect to new columns appearing in the table. The main difference with Unpivot Columns is that it allows you to select the columns that should not be unpivoted. This case optimizes the user flow for cases where the number of columns that should not be unpivoted is much smaller than the number of columns that should be unpivoted, similar to the behavior of Remove Other Columns compared to Remove Columns.

Combine Files experience—ability to reference first file as example

We improved the Combine Files experience by allowing you to always reference the first file in a folder as the example file. Before this update, you had to pick a specific file by name, which might cause errors in the future if such file is removed from the folder.

With this update, you can select First file in the Combine Files dialog, which will ensure that the first file in the folder is used as the example, regardless of the specific file name.

www.office.com/setup - The Combine Files dialog is displayed with the First file option highlighted.

New Go to Column in Query Editor

When working with tables that have many columns, it is hard for users to scroll in the Query Editor preview to find the column that they want to apply transformations to.

In this month’s release, we added a new Go to Column command to the Home tab on the Query Editor ribbon that allows you to search within the list of columns and select the column that they would like to scroll into preview and select.

www.office.com/setup - The Home tab is selected, and the Choose Columns menu is expanded to highlight the Go to Column option.

SAP HANA connector—enhancements to Parameter Input UX

We improved the Parameter Input UX for the SAP HANA connector in a couple of ways:

  • You can now filter down the list of parameters to only required parameters.
  • We moved away from drop-down menus for single/multi-selection input controls and started using a popup dialog for both scenarios. This new dialog allows users to see both the ID and Caption for each parameter value, as well as search within the list of values by any of these two fields. This makes it easier to provide input values, as opposed to the previous experience that only allowed input IDs.

Learn more

—The Excel team

 

Need some help setting up Office 365 for your business? Check out these videos

www.office.com/setup

www.office.com/setup – Changing over to Office 365 isn’t always the easiest transition. Even with the documentations page, sometimes users will need to see things to get an idea of what they want to do.

www.office.com/setupMicrosoft Tech Community has published a short list of videos to help you make your change over to Office 365 admin center just a little bit easier. As it says in the description, you’ll learn how to set up and manage Office 365. Including:

  • Setting up domains
  • Choosing domain names
  • Using the admin mobile app
  • Setting up team sites
  • Email setup and management
  • Adding/Removing people
  • Document storage
  • Download software

More videos are expected to be added as time goes on, but you can check out the first fifteen today.

www.office.com/setup

www.office.com/setup

New to Office 365 in July—Microsoft 365, business apps and more

www.office.com/setup Blogs: Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office team.

www.office.com/setup Blogs: This month, we hosted more than 17,000 attendees at Microsoft Inspire, our annual conference for partners, where we announced Microsoft 365 and debuted three new business apps to help companies of all sizes empower their employees and unlock growth and innovation. We also introduced new features to help Office 365 subscribers create and connect more effectively. Read on for the details.

News from Inspire for businesses of all sizes

www.office.com/setup Blogs: At Microsoft Inspire in Washington D.C., we introduced a fundamental shift in how we will design, build and go to market to address our customers’ needs for a modern workplace.

Introducing Microsoft 365—Satya Nadella unveiled Microsoft 365, which brings together Office 365, Windows 10 and Enterprise Mobility + Security to deliver a complete, intelligent and secure solution to empower employees. To address the commercial needs from the largest enterprise to the smallest business, we introduced Microsoft 365 Enterprise and Microsoft 365 Business. Read our summary from Microsoft Inspire to learn more.

New business apps in Office 365 Business Premium—We also introduced the preview of three new appsin Office 365 Business Premium: Microsoft Connections, Microsoft Listings, and Microsoft Invoicing. These apps are designed to help you run and grow your small business, and are part of the new Office 365 Business center. MileIQ—the leading mileage tracking app—is also now included for Office 365 Business Premium subscribers. Read the announcement to learn more.

www.office.com/setup - A tablet showing the new Office 365 Business Center dashboard.

The new Office 365 Business center is now included in Office 365 Business Premium.

Availability: Microsoft Connections, Microsoft Listings, Microsoft Invoicing and the Office 365 Business center are rolling out in preview to Office 365 Business Premium subscribers in the U.S., U.K. and Canada, starting with those in the First Release program. MileIQ Premium is available to all Business Premium subscribers in the U.S., U.K. and Canada effective today.

Create and present more effectively with updates to Office apps

This month’s Office 365 updates make it easier to create professional-looking presentations and to identify and correct errors while editing documents.

Turn text into timelines in PowerPoint—Now PowerPoint Designer recognizes times, dates and topics on your slides and intelligently redesigns your content into professional-looking timelines, making it easier than ever to create high impact presentations. Start with a list of dates, then simply select Design Ideas in the Design tab and choose your favorite layout from the set of suggestions.

www.office.com/setup - A timeline created with PowerPoint designer and a number of alternate design options.

Create a visual timeline in seconds with PowerPoint Designer.

Availability: PowerPoint Designer support for timelines is available in English for U.S. customers in the Office Insider program in PowerPoint on Windows and Mac, PowerPoint Mobile on Windows and Android tablets, and PowerPoint Online.

Support for 3D in Office apps—Starting this month, you can now add and edit 3D objects in Word, Excel and PowerPointEasily insert a 3D object from the Remix 3D catalog or your desktop, change its perspective and use transitions like Morph in PowerPoint to create cinematic animations between slides to bring 3D objects in your presentations to life.

www.office.com/setup - Rotating 3D objects in PowerPoint slides.

Easily insert 3D objects in PowerPoint from the Remix 3D catalog or your desktop.

Availability: Support for 3D objects in Word, Excel and PowerPoint is available to Office Insiders on Windows desktops running the Creators Update and will reach general availability later this year.

Read Aloud in Word—We continue to improve the Learning Tools available in Word and have moved Read Aloud to the Review tab. This latest update allows your document to be read back to you with simultaneous highlighting—from right within your workflow. This makes it easier to recognize and correct errors as you write, improving reading and editing accuracy for everyone, especially users with learning disabilities such as dyslexia.

www.office.com/setup - Screen showing the new reader view in Windows.

Read Aloud is now accessible from the Review tab.

Availability: Read Aloud is now available in Word on Windows desktops for Office Insiders and will reach general availability later this year.

Additional updates for Office 365 commercial customers

Updates to Outlook and StaffHub make it easier for our Office 365 commercial customers to connect and manage tasks across their organizations.

Outlook adds a smarter To: line and redesigned conversation view—Powered by intelligence from the Microsoft Graph, Outlook on the web and Windows desktop now offer improved contact suggestions and profile pictures when composing an email. This update makes it easier for you to find and communicate with the right people throughout your organization.

Additionally, the redesigned conversation view in Outlook for iOS shows more of your discussion at once, allowing you to quickly review your message history and pick up right where you left off.

www.office.com/setup - The new conversation view with increased message spacing shown on an iPhone.

The new conversation view in Outlook for iOS shows more of your conversation.

Availability: Improved contact suggestions are available in Outlook on the web for all Office 365 commercial customers and in Outlook on Windows desktops for Office Insiders. The redesigned conversation view is now available for Office 365 commercial accounts (previously available for Outlook.com and Gmail accounts on iOS) and will be coming soon to Android.

Enhancements to Microsoft StaffHub—Throughout July, we made several updates to Microsoft StaffHub, an Office 365 app designed to help Firstline Workers manage their workday. In industries like manufacturing, retail and healthcare, firstline workers often serve as the first point of contact between a company and its customers. Now team members can use the StaffHub app to assign, manage and complete tasks from co-workers and management, as well as access company-wide announcements—making it easier to keep everyone in sync.

www.office.com/setup - The new task view in StaffHub on an Android phone. The image shows the simple creation and completion of tasks.

The new StaffHub task view, available on Android and iOS.

Availability: Updates to StaffHub are available today by request and can be turned on for specific teams and customers.

Learn more about what’s new for Office 365 subscribers this month at: Office on Windows desktops | Office for Mac | Office Mobile for Windows | Office for iPhone and iPad | Office on Android. If you’re an Office 365 Home or Personal customer, be sure to sign up for Office Insider to be the first to use the latest and greatest in Office productivity. Commercial customers on both Current Channel and Deferred Channel can also get early access to a fully supported build through First ReleaseThis site explains more about when you can expect to receive the features announced today.

—Kirk Koenigsbauer