You are here

MS Access Blog

Subscribe to MS Access Blog feed
Updated: 2 min 50 sec ago

Your top 10 questions about Office 2016 answered

Thu, 10/01/2015 - 10:53

Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office Client Applications and Services team.

We are thrilled to see the positive response for the launch of Office 2016 last week. We’ve received a ton of great feedback and wanted to address some of your top questions:

  1. How do I get Office 2016 for Windows if I’m an Office 365 customer?

As an existing Office 365 subscriber, Office 2016 is immediately available to you, and based upon your plan, you can choose to manually update or wait for the scheduled automatic update. Below are links to instructions to manually update to Office 2016:

  • Office 365 ProPlus (including E3/E4) customers are typically managed by an IT department and they determine when to deploy Office 2016. Please contact your IT department for your company’s specific timeline. Manual updates are available for download by Office 365 administrators. Please see Prepare to update Office 365 ProPlus to the Office 2016 version for more information.
  1. How do I get Office 2016 for Mac?

Office 365 Home, Personal and University customers can browse to your MyAccount page on their Mac, sign in and follow the installation instructions.

If you have Office 365 through your organization, go to

New customers can get Office 2016 for Mac with an Office 365 subscription or as a one-time purchase option at or through your software retailer.

  1. Can I get Office 2016 without an Office 365 subscription?

Yes, one-time purchase options are available for both the Windows and Mac versions of Office 2016 from your software retailer and the Microsoft Store.

  1. When will Volume Licensing customers be able to get Office 2016?

Volume Licensing customers will be able to download Office 2016 from the Volume Licensing Service Center beginning today, and Home Use Program (HUP) customers can install Office 2016 beginning on October 7, 2015. MSDN Subscriptions customers can download Office 2016 now.

  1. I just bought Office 2013 or Office for Mac 2011. How do I upgrade to Office 2016?

If you recently activated a qualifying Office 2013 or Office for Mac 2011 product, we are pleased to announce that you are eligible for one of two special upgrade offers:

1.  A free 1-year subscription of Office 365 Personal (which includes the Office 2016 applications for both PC and Mac).
2.  A $40 USD discounted upgrade price for the equivalent Office 2016 edition.

For more information, please see the Special offer for customers wanting to upgrade from Office 2013 or Office for Mac 2011 to Office 2016 support article.

  1. Are there system requirements I should be aware of when installing Office 2016?

Yes, Outlook 2016 requires Exchange Server 2010 or later.

Additionally, Office 2013 standalone applications, including Project and Visio, cannot run on the same device as Office 2016. We do have a workaround with a generous offer. Please refer to the Special offer for customers with Office 2016 and Office 2013 standalone applications support article.

  1. Can I install a subset of the Office 2016 applications?

No, the ability to selectively install individual applications is not available with Office 2016. The vast majority of customers prefer the full installation of all of the Office apps so they are assured that they have the ability to open, view and edit any document they may need. We will continue to evaluate feedback on this topic.

  1. What features are only available with Office 365?

Some of the features in Outlook 2016 such as Clutter and Office 365 Groups require Office 365 email and calendaring support. GigJam, Planner and Delve are only available to business customers through the Office 365 portal. Some qualifying Office 365 subscriptions also include support for unlimited online meetings, 1TB of cloud storage per user, and team websites. We will also be providing additional updates and new features to Office 365 customers on a monthly basis going forward that will not be available to those who buy Office 2016 as a one-time purchase option.

  1. I have a technical problem. How do I get help?

The best place to start is, where you’ll find information about known issues, top solutions, and how to contact support.

  1. How can I request a new feature?

You can submit your feature request on the new suggestion box service for each application:,,,, and

Thank you again for the incredible response to Office 2016. The team is already hard at work on the first update for Office 365 customers, and we’ll share more information on this blog soon. Please keep sending us your questions, feedback and suggestions—it’s very helpful as we prioritize what you want, so that we can create the best Office experience for you.

The post Your top 10 questions about Office 2016 answered appeared first on Office Blogs.

The new Office is here

Tue, 09/22/2015 - 03:00

Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office Client Applications and Services team.

It’s here! Today is the worldwide release of Office 2016 for Windows. This marks a milestone in delivering new value for Office 365 subscribers with a focus on collaboration, apps that work for you, a perfect pairing with Windows 10, and security features businesses will love. It also marks a new model for delivery, where subscribers can expect to get more frequent updates with new features and improvements. Along with Office 2016 for Windows, today we are also releasing Office 2016 for Mac as a one-time purchase option, along with several new and enhanced Office 365 services.

The new Office—takes the work out of working together

Collaboration is the way we get things done in the workplace, but the process itself can be complex and frustrating. It shouldn’t have to be. We set out to make working together easier and more impactful by building a suite of integrated apps and services that removes barriers and empowers teams to do and achieve more.

Office has always been the go-to tool for helping individuals do their best work—whether for professional documents, powerful analyses or school presentations. People often start and end their work in Office, but there is often a messy middle that involves a lot of discussion—in person, by phone or via various tools—as well as multiple (sometimes conflicting) inputs. Today we are delivering a set of experiences that is built for making teamwork seamless.

  • We have had real-time co-authoring in all of our web apps since 2013. We are now taking it to the next level by building it directly into our native apps. With this release, we’re making co-authoring in Word real-time, which lets you see what others are writing immediately, as it happens. We’re committed to expanding real-time co-authoring to each of our native apps and you should expect to see more over time.
  • Skype for Business is now available in the client apps, allowing you to IM, screen share, talk or video chat right in your docs. This same experience will be coming to Office Online later this fall. Skype for Business also has faster screen sharing and now adds the option to start a real-time co-authoring session from any conversation or meeting.
  • Keep teams connected with Office 365 Groups, now available as part of Outlook 2016 and in a new Outlook Groups app on iOS, Android and Windows Phone. Office 365 Groups allows individuals to easily create public or private teams. Each group includes a shared inbox, calendar, cloud storage for group files, and a shared OneNote notebook to keep the team productive.
  • Office 365 Planner helps teams organize their work, with the ability to create new plans, organize and assign tasks, set due dates and update status. Planner’s visual dashboards and email notifications help keep everyone informed on the overall progress of their initiative. Planner will be available in preview, to Office 365 First Release customers, starting next quarter.
  • Originally unveiled earlier this year, GigJam is today available in private preview and will become part of Office 365 in 2016. GigJam is an unprecedented new way for teams to accomplish tasks and transform business processes by breaking down the barriers between devices, apps and people.
Works for you

In today’s workplace, we have too many apps, devices and tools—we just don’t have enough time. Office is built to cut through the complexity and help you get things done quickly. It gets work done for you.

Some highlights:

  • Outlook 2016 provides the smartest inbox yet, delivering lightning fast search, removing low priority mail automatically and making sure everyone on the To: line has the right access to modern, cloud-based attachments from OneDrive.
  • We also have significant new updates to OneDrive for Business coming later this month across sync, browser, mobile, IT control and developer experiences. The highlight is the preview of the next generation sync client for Windows and Mac, offering improved reliability and selective sync, as well as increased file size and volume limits.
  • Tell Me helps you easily and quickly find the right Office feature or command, and Smart Lookup brings insights from the web right into your documents. Previously available only in Office Online, Tell Me and Smart Lookup are now available across the Office 2016 client apps.
  • Excel 2016 now includes integrated publishing to Power BI and new modern chart-types to help you make the most of your data.
  • The cloud-powered most recently used documents list allows you to pick up right where you left off in seconds, because it travels with you across your devices whether working in Office Online, the mobile apps or in the 2016 client apps.
Perfect with Windows 10

While we have made a lot of progress on delivering Office cross-platform and remain committed to this strategy, we see Windows as being “home” for Office. Together, Office 365 and Windows 10 are the most complete solution for getting things done.

  • With Windows Hello, you can sign in to your PC and Office 365 with a simple look or a touch—no need to type a password anymore.
  • In the coming months, Cortana will get even smarter and more useful by gathering intelligence on Office 365 through Outlook 2016 support.
  • With the Office Mobile apps and Continuum on Windows phones, your phone can act as a desktop, and you can project, create or edit your presentation or sales budget from your phone to a monitor while using the same phone to take notes with the OneNote app.
  • Sway on Windows 10 was released in early August, and customers love it! It has received a 4.6/5 app store ranking, with customers calling it “funtastic,” “brilliant” and “elegant.” People love Sway’s simple and intuitive yet powerful approach to next-generation digital storytelling. With Sway, you provide the content, and Sway creates beautiful, shareable, interactive stories that look great on any screen.
  • Our Office Mobile apps on Windows 10 (Word, Excel and PowerPoint) have also received great reception and 4+ app store rankings. Customers say they are touch-friendly, fast and easy to use—making them wonderful for on-the-go-productivity.
For the enterprise

Office 2016 apps with Office 365 provide the most secure Office yet. We are adding built-in Data Loss Prevention (DLP) to significantly reduce the risk of leaking sensitive data by giving IT admins tools to centrally create, manage and enforce policies for content authoring and document sharing. Multifactor Authentication ensures secure access to content anywhere when employees are away from the corporate network. We are also adding Information Rights Management to Visio. Then, later this year, we will be enabling Enterprise Data Protection (EDP) in Windows 10, with support in Office Mobile, which allows more secure corporate content sharing across corporate managed apps and network/cloud locations, preventing inadvertent content sharing outside corporate boundaries. We will be following up with EDP for Office on Windows desktop in early 2016.

Some of our favorite enterprise apps—Visio and Project—have been updated as well. With Visio 2016, customers can get started quickly with diagramming using starter diagrams and contextual tips. Bringing process models, manufacturing plant or IT architecture to life is now only one step away. With Project 2016, customers can streamline resource engagement processes, manage resource pools through visual heat maps, benefit from multiple timelines, and create custom experiences in Project desktop through write-back capabilities for add-ins.

We are also making deployment easier and have a lot of other new capabilities to help IT professionals, as announced in our blog to IT admins two weeks ago.

Office 2016 for Mac

In July, we released Office 2016 for Mac to our Office 365 customers. The new versions of Word, Excel, PowerPoint, Outlook and OneNote are a significant step forward and provide the best of both worlds for Mac users—a familiar Office experience paired with the best of the Mac platform. The level of engagement and excitement about this Office for Mac release has surpassed our expectations. As promised in July, today Office 2016 for Mac will also be available as a one-time purchase.

Ongoing Office 365 customer value

Whew—that was a lot! With this release, we’re also shifting the cadence of Office on Windows to feel much more like the cadence we have on the Office mobile and web apps, which release every month with new value. So, going forward, Office 365 customers will now enjoy new features and capabilities delivered continuously in the Office desktop applications as part of their subscription. It’s a new day for our desktop apps.

And as a bit of a teaser, here are some examples of the types of new features and benefits Office 365 customers will see:

  • Built for teamwork—We’re committed to rich co-authoring and collaboration across our native clients, starting in Word 2016, with other big advances in collaboration coming throughout the year. By the end of 2015, we’ll introduce Office 365 Groups insights and discovery in Office Delve. In addition, we will have a new generation of personal work analytics in Office Delve that will help individuals, teams and organizations to be more effective at work by understanding their reach and impact, time allocation and network.
  • Works for you—For those of you who are excited about our new charts and forecasting, we will be delivering even more new charts, formulas, connectors and other Excel capabilities throughout the year. (If you’re interested in telling us which charts and charting features you’d like to see first, we have a survey going on our Excel Facebook page right now!). We also have some very exciting developments in the pipeline for PowerPoint that will make it easier to design and deliver presentations to wow and engage your audience.
  • Perfect on Windows 10—We are especially excited about how even more valuable your personal assistant Cortana can be when she has insights from Office. This will start to allow Cortana to unlock helpful scenarios, like retrieving your documents, preparing for meetings and more.
Get started

We want to thank all of our Preview customers who have been with us since as early as February, trying out the new apps, giving us feedback, and helping to shape the final product. Your feedback has been invaluable, and we thank you for helping make the best Office yet.

We hope you are excited as we are about the new Office. Buy it, try it or learn more—but please keep your feedback coming!

  • Are you ready to purchase? Buy Office 365 to get the new 2016 apps.
  • Are you an existing Office 365 customer who is ready to upgrade? Go here for instructions on how to upgrade to Office 2016 for home, or here for business customers.
  • Do you want to learn more? Go to

—Kirk Koenigsbauer

The post The new Office is here appeared first on Office Blogs.

4 updates in Power Query for Excel

Fri, 08/14/2015 - 10:40

This month’s Power Query update includes four new or improved features, including:

  • Option to specify Join Type in the Merge Queries dialog.
  • Extract first, last or range of characters from a Text column.
  • Customize the Quote Style in Split Column by Delimiter dialog.
  • Support for UPN credentials in the Exchange connector.

You can continue reading below for more details about each feature.

Option to specify Join Type in the Merge Queries dialog

It is now possible to specify the type of Join that you would like to apply when merging two queries using the Merge Queries dialog. These options were previously available only by manually modifying the generated formula. Now they are much more easily accessible in the Merge Queries dialog.

Extract first, last or range of characters from a Text column

With this update we have added user interface (UI) support to specify how many characters to extract from a Text column, starting from the beginning, end or a specific position. This new set of transformations can be found under the Text -> Extract Group in the Transform and Add Column tabs on the Query Editor ribbon.

Customize Quote Style in the Split Column by Delimiter dialog

Users can now switch between the CSV Quote Style and no Quote Style when splitting a column by delimiter. This option is available in the Advanced Options section of the Split Column by Delimiter dialog.

Support for UPN credentials in the Exchange connector

In this update, we added support for specifying a UPN (User Principal Name) as part of providing credentials to use the Exchange connector. This option is available from the Credentials prompt when using this connector. If you have already connected to Exchange before and need to modify your credentials, you can access this option from the Data Source Settings dialog.

That’s all for this month. We’re making lots of incremental improvements to Power Query and we hope that you find it better with every new monthly update. Please continue sending us feedback using our “Send a Smile/Frown” feature or by voting for what you’d like to see next.

—Miguel Llopis, program manager on the Power Query team


Power Query for Excel is available with an Office 365 ProPlus subscription, Office 2010 Professional Plus with Software Assurance, Office 2013 Professional Plus or Excel 2013 Standalone. Power Query for Excel is also available in all other Excel 2013 Desktop SKUs with reduced functionality. Check out the System Requirements section on this page for more details.

Download the add-in and learn more about getting started.

Learn about all the powerful analytics and visualization features in Excel and take your analysis further by sharing and collaborating on business insights with colleagues using Power BI.

The post 4 updates in Power Query for Excel appeared first on Office Blogs.

Preview real-time co-authoring on OneDrive

Thu, 08/13/2015 - 13:00

Earlier this year we announced real-time co-authoring support for Word 2016 as part of the Office 2016 Preview. For the last several months, this feature has been available to preview users co-authoring Word documents stored on SharePoint Online. Today, we are pleased to announce that real-time co-authoring is also available as a first-look for Word documents stored on OneDrive as part of the latest Office 2016 Preview release.

Now when two or more users running the latest preview open the same Word document from OneDrive, they can co-author with others in real-time, which allows them to see the cursor location and text edits made by the other users automatically appear as they happen.

You are encouraged to try real-time co-authoring on OneDrive today. If you are receiving regular updates throughout the preview, you should have received this functionality as an update by 11 a.m. this morning.

To try out this feature, all you need is a Word document stored on OneDrive and two or more people running the latest preview. Make sure to give both users edit permissions so they can both edit the file. If this is the first time you’ve tried real-time co-authoring, you will see a prompt in the upper right corner of Word asking you if you’d like to automatically share your changes.

All you need to do is click Yes to join the experience. Once both authors have clicked Yes, you’ll see a flag representing the other author’s cursor position and then you will automatically see their edits come in.

Please give it a try today and let us know what you think of the experience.

—The Word team

The post Preview real-time co-authoring on OneDrive appeared first on Office Blogs.

What’s new: July 2015

Thu, 08/13/2015 - 11:50

Office 2016 for Mac arrived this month, along with Office Mobile apps for Windows 10, a new universal iOS OneNote app, and more. For business, new compliance capabilities and IT management controls were added, along with enhancements to Yammer and Power Query. On the mobile front, Azure Rights Management is now available for Office for iPad and iPhone, there’s a new app designed for in-and-out email, and the Skype for Business Windows Phone app is here. Enterprise customers can preview the new Skype for Business capabilities, and teachers and students can now move back and forth between Office 365 and Moodle or Open edX without logging in each time. For developers, the new edition of the monthly Office 365 Dev Digest is out, Office 365 channels are live, and The Office Dev Show has begun. Leave us a comment to let us know what your favorite new feature is. If you missed last month’s updates, see What’s new: June 2015.

Office 365 Personal, Office 365 Home and Office 365 University updates

New chart types available in Office 2016 Preview—Now you have more ways to explore data and tell rich stories across Excel, Word and PowerPoint. Six powerful new charts help you quickly visualize common financial, statistical and hierarchical data: Waterfall, Histogram, Pareto, Box & Whisker, Treemap and Sunburst.

Office 2016 for Mac is here—The new versions of Word, Excel, PowerPoint, Outlook and OneNote—each with major updates—give Mac users the familiar Office experience paired with the best of Mac. Office for Mac is cloud-connected, for quick access to your documents on any device, and it’s available in 139 countries and 16 languages. Office 365 subscribers can get the newest version of Office for Mac today.

OneNote updates for iOS and Android—Now there’s a universal iOS OneNote app that works on both iPad and iPhone. iPad users need to get the new OneNote app from the store; iPhone users already have it. With the new app, iPad users have some of the recent updates made to the iPhone app, like the Today Widget and Recent Notes. The updated OneNote for Android app introduces one of the top feature asks—the ability to move or copy pages from one section or notebook to another.

WYSIWYG editing in Office Mix quizzes and polls—You’re no longer limited in Office Mix to asking questions that can be typed on a QWERTY keyboard. With WYSIWIG editing support in quizzes and polls, you can type mathematical and scientific formulas. Even if you’re not a math or science teacher, you now have a lot more freedom to include images, tables, bulleted and numbered lists, and special characters in quiz and poll questions in your Office Mixes.

Office Mobile apps for Windows 10 are here!—The Office Mobile apps—Word, Excel, PowerPoint and OneNote—give you on-the-go productivity on Windows 10 tablets and small screen devices, with full fidelity viewing. The apps are fully cloud connected, and your docs are now automatically saved for you. Plus, new features, like Tell Me, make it easier for you to do what you want. You can download and install the apps from the new Windows Store today in 190 countries.

Office 365 for Business and Education updates*

Preview of new Skype for Business services in Office 365—Office 365 enterprise customers can register for three technical previews of the new Skype for Business voice and meetings capabilities in Office 365: Skype Meeting Broadcast, PSTN Conferencing and Cloud PBX with PSTN Calling. Later this year, with strategic partners, direct connections to Office 365 Skype for Business customers will be delivered through Azure ExpressRoute for Office 365.

Office 365 now offers integration with educational open source software—Now teachers and students can move back and forth between Office 365 and Moodle or Open edX without the need to log in each time. For example, if you’re logged in to Office 365 and working on a Word document, you can easily upload the document to Moodle as an assignment. You can also allow Moodle or Open edX to appear in the My Apps app launcher within Office 365, synchronize your Outlook calendars to a Moodle course calendar, embed an Office Mix in Moodle, and more.

Compliance toolset for public folders—The Office 365 archiving and eDiscovery toolset is being extended to include public folders. You can now place public folder content on hold to preserve it for legal or regulatory requirements and perform eDiscovery functions on public folder data, including search, preview and export. Entire public folders or specific content can be preserved immutably, and all administrative activities on public folders are fully audited.

Skype for Business Windows Phone app is here!—The new app includes many enhancements, including an intuitive interface, more emoticons and improved server communications. The enhanced security with at-rest data encryption means your conversation history and voicemail are encrypted by default. And your recent conversations are now synchronized across devices, whether they took place on your PC, tablet or phone, as long as you’re running the latest server software. Find out how you can upgrade.

New activity logging and reporting capabilities for Office 365—The new activity logging and reporting capabilities provide even greater visibility into actions taken on your content and greater control over access to your data in Office 365. They include: the Office 365 activity report to investigate a user’s activity, comprehensive logging capability for user and admin activity events, the Search PowerShell command or cmdlet, and a preview of the Office 365 Management Activity API.

Power Query for Excel updates—The recently added or improved features include: improvements to the ODBC Connector, Navigator dialog improvements, an option to enable Fast Data Load versus Background Data Load, support for Salesforce Custom environments in Recent Sources list, easier parsing of Date or Time values out of a Text column with Date/Time information, and a new Unpivot Other Columns entry in the column context menu.

New IT management controls added to OneDrive for Business—The new management options to protect and control the flow of your information include: limiting file sync to domain-joined PCs, auditing all actions taken against files, setting storage quotas, and preventing unintentional sharing to “Everyone” or “All Users.” Read what the new controls can do and take a walk through them with Office Mechanics to learn how to implement them.

Document collaboration in Yammer just got better!—Deeper integration with Office Online makes it easier than ever to incorporate document collaboration into teamwork. Click the Edit File link in Yammer and a new browser tab opens with a full-screen view of the document. You can make changes directly in the document using Office Online, and they’re automatically saved in Yammer. You can also now share and work on files with external participants. And with integration with Office 365, the reliability and performance of document collaboration in Yammer has improved.

Tips to get started using the Mobile Device Management (MDM) feature for Office 365—It’s easy to get this built-in feature up and running to manage and secure mobile devices when they’re connected to your Office 365 organization. Learn how to set up MDM for Office 365, configure Security Groups and Device policies, enroll devices, and wipe enrolled devices and run reports.

Office 365 channels are live on IFTTT—When you activate the Office 365 channels—Mail, OneDrive for Business, Calendar and Contacts—you can automate what happens with your Office 365 data to increase productivity. For example, you can create Recipes to program activities, like automatically saving a photo to OneDrive for Business or sharing that a new Office 365 contact was added to your team’s Trello board or Slack team. Check out the Office 365 sample Recipes to help you get started.

Introducing Send—the app designed for in-and-out email—Send is a new app built for sending your coworkers quick, brief messages—no signatures, subject lines or salutations required. The app connects to Office 365 business and school email accounts to surface your frequent and recent contacts and enables you to have all of your communications in Outlook for reference later. Send is available for iPhone in the U.S. and Canada, and is coming soon to Windows Phone and Android phones.

Azure Rights Management support comes to Office for iPad and iPhoneAzure Rights Management provides an easy way to protect data by assigning a policy to the data available in Office 2013, Office 2010 and Office for Mac. Now this policy-driven protection is available in Office for iPad and on iPhone devices, so you can view rights-protected Office documents natively on your iOS devices.

Windows 10 updates for Office 365 admins—IT admins can benefit from Windows, Office and Azure Active Directory integration in three areas: joining Windows 10 to Azure Active Directory for single sign-on (SSO) to Office 365 and other services, using the Business Store portal in Windows Store to deliver Office apps, and adding Windows 10 devices to Mobile Device Management for Office 365. Read the blog post and watch the video to find out how.

Office 365 Developer updates

Office 365 Dev Digest for July—Stay up to date with what’s new in Office 365 development. Read the digest for the latest dev news, like one-click access to third-party apps and the new Office Dev Show. Get new and updated documentation, code samples, and patterns and practices samples, plus links to podcasts, blog posts, videos about companies using Office add-ins to extend the value of Office, and upcoming events.

A new way to keep up with all the Office 365 Dev news, tips and tricks—Watch The Office Dev Show, a new dedicated Channel 9 show devoted to all things Office 365 dev-related! The show, hosted by Sonya Koptyev, will include guests from the Office 365 Extensibility engineering team and key community members. It will feature new code and capabilities added for devs to customize the Office platform, including desktop, online and mobile versions, as well as a “Get Started” series on building on the platform. The show airs weekly, on Wednesdays.

Office 365 channels are live on IFTTT—When you activate the Office 365 channels—Mail, OneDrive for Business, Calendar and Contacts—you can automate what happens with your Office 365 data to increase productivity. For example, you can create Recipes to program activities, like automatically saving a photo to OneDrive for Business or sharing that a new Office 365 contact was added to your team’s Trello board or Slack team. Check out the Office 365 sample Recipes to help you get started.

Please note that some of the updates may take time to show up in your Office 365 account, because they’re being rolled out to customers worldwide.

—Andy O’Donald @andyodonald


*Not all updates apply to every Office 365 plan; please check the individual post for specifics.

The post What’s new: July 2015 appeared first on Office Blogs.

Optimizing Yammer for teams

Thu, 08/13/2015 - 09:00

Today’s post was written by Juliet Wei, senior product marketing manager for the Yammer team.

When we first set out to create Yammer, we started with the simple idea that information is more valuable when it’s shared. As an enterprise social network, Yammer revolutionized information sharing in the workplace by giving millions of people a platform to make their voices heard and discover what others across the company are working on.

Recently we announced Yammer’s on a mission to bring the benefits of open collaboration to teamwork. Since then, we’ve introduced Office Online integration for better document collaboration in Yammer; external messaging, which lets teams easily connect with people outside their company; and Yammer for Apple Watch to enable a whole new way of staying connected with your team. Today we’re unveiling another set of exciting changes to Yammer, including a fresh new look and feel that’s designed for teamwork from the ground up.

As teams spin up around a project or initiative, they need a way to filter out the noise and focus on the task at hand. Yammer groups provide a great setting for teamwork by empowering people to share and collaborate within the right context and with the right set of people. However, the default experience in Yammer to date has been the home feeds which were intended for broad network-wide sharing. To encourage teams to make Yammer groups their go-to destination, we’re delivering a number of UI enhancements and improving the experience inside groups. Some of the changes we’re delivering on the web include:

  • Discovery feed—We’re updating the current home feed experience to focus on group updates and discovery. The renamed Discovery feed surfaces conversations you’re missing out on from relevant groups and enables you to stay connected to the most interesting content from other teams across your company. Updates in the Discovery feed clearly identify which groups the conversations come from and give you the ability to quickly navigate to and join the groups you’re not already a member of straight from the feed.
  • Real-time group activity—We’re giving you better peripheral vision into your groups no matter where you are in Yammer. Real-time indicators in the left-hand navigation pane call your attention to group activity as it happens, alerting you to all your currently active groups and teammates.

The Discovery feed surfaces group conversations you’re missing out on and makes it easy for you to navigate to and join groups from the feed. Group activity shows up in real time in the left-hand navigation pane.

  • Immersive group experience—Because Yammer groups serve as a home base for teams, we’re giving them a greater sense of place and making them more engaging with a full-width header, a cleaner look to focus your attention on high impact activity and content, and a wider feed for your team conversations.
  • Next Group notification—Getting through the most important updates in your groups quickly is key when you’re juggling multiple projects. When you’re done viewing the new conversations in each group, a banner appears prompting you navigate to your next group, so you can get through your projects faster.

Groups have a greater sense of place and are more engaging. The Next Group notification prompts you to move on after you’ve viewed the new conversations in a group.

We’re also taking major steps to reorient Yammer’s mobile apps around groups to meet the needs of fast-moving teams. Over the coming months, you’ll see significant changes to your mobile experience, including a better way to get through your group content and new capabilities that boost mobile team collaboration.

  • Group Updates feed—The Group Updates feed provides a simple workflow through relevant content in your groups, so you can catch up on urgent conversations and discover what others are working on. You can navigate easily between the feed and your groups, as well as join groups you’re not already a part of from the feed itself. The Group Updates feed will come to Android first with iOS following shortly after.

The Group Updates feed provides a simple workflow on mobile, enabling you to quickly catch up on your groups and easily navigate between the feed and your groups.

  • Yammer for Apple Watch—As announced last week, Yammer for Apple Watch provides instant notification of your conversations and activities at a glance and lets you take quick action, so you have fewer to-dos at the end of the day. It’s a great companion app for the Yammer mobile and web experiences.
  • Powerful new photo-sharing and markup—Translate images into action with the ability to attach multiple images at once and even mark up the parts of the images you want to call out with your finger to help others see what you see.

Translate images into action by marking up photos with your finger and sharing them with your team.

  • Attach files from external file storage services—Yammer’s mobile apps let you find and attach all your files, including those stored on external services such as OneDrive and Dropbox, as well as files stored in Yammer and on your mobile device.
  • Inline at-mentioning—Bringing others into the conversation has never been easier with inline at-mentioning now available on mobile. Yammer’s type-ahead functionality suggests people and groups to address while you compose your message, removing the need to at-mention them separately.
  • Search and invite coworkers by email—Finding your coworkers on Yammer is possible, even if they haven’t started using Yammer yet. Searching by name or email enables you to find existing members and invite new members to join Yammer from your Yammer mobile app.

All of these experiences take place against a backdrop of continual improvements in Yammer, such as a new responsive design optimized for larger screen sizes and faster performance on web and mobile.

Up next in 2016: deeper integration with Office 365 to open up even more possibilities for teams. We’re working on wrapping up the foundational identity work with Azure Active Directory, leveraging Office Graph signals for better people and group suggestions; using Office Online for multi-user coauthoring in Yammer; and hooking into the Office 365 Groups service to enable cross-workload scenarios with OneDrive, Outlook, OneNote and Skype. And to improve collaboration with extended team members, we’ll also be delivering external groups, which lets users invite outside participants into their Yammer groups.

We’re excited about taking teamwork to the next level with these changes and hope you are too. Give your teams the gift of Yammer and start using Yammer groups for your projects and initiatives today.

—Juliet Wei


Frequently asked questions

Q. Where can I go to learn more about using Yammer for team collaboration?

A. If you’d like to learn more about how Yammer helps improve teamwork, join our YamJam. On Wednesday, September 9, the Office 365 Network will host a YamJam from 9–10 a.m. PDT / 5–6 p.m. GST. Members of the product engineering team will be on hand to answer your questions. For those unfamiliar with a YamJam, it is similar to a “TweetJam” on Twitter or an “Ask Me Anything” (AMA) on Reddit, except it takes place on Yammer. It provides the opportunity for the community to ask questions and have a discussion with a panel of internal Microsoft experts on a particular topic. Here’s how to participate:

  1. Request access to the Office 365 Network. All requests will be approved as quickly as possible.
  2. Join the Enterprise Social group. You can find it by using the Browse Groups function or through the search bar.
  3. Log in at 9 a.m. PDT / 5 p.m. GST on Wednesday, September 9 to ask questions, follow the discussions and connect with Microsoft team members.

Q. When will these new features be available? Do I need to do anything to enable them in my Yammer network?

A. Yammer develops in short, iterative cycles and only ships features that are proven to increase engagement. While we’ve already shipped many of these experiences on mobile and web to customers, we’re still testing and refining others to ensure we deliver the best possible user experience. This means some users will see an early version of a new feature appear for a while in their Yammer experience while we are testing it, then disappear as we pull it back for further work and finalization. Our goal is to complete and ship the remaining team experiences outlined above to 100 percent of our customers by year end. Because Yammer is a multi-tenant cloud service, no action is required to enable these new capabilities. To see upcoming features and experiences, visit

The post Optimizing Yammer for teams appeared first on Office Blogs.

10 little-known keyboard shortcuts for editing in PowerPoint

Thu, 08/13/2015 - 09:00

If you use PowerPoint at work or at home, keyboard shortcuts can be a great time saver. Here are some little-known keyboard shortcuts I’ve discovered over the last few years while working on the PowerPoint team. These keyboard shortcuts are designed for PowerPoint for Windows. If you are using PowerPoint for Mac, you can still use them if you replace Ctrl with CMD (⌘) unless stated otherwise. I hope you find these keyboard shortcuts as useful as I have!

Draw horizontal or vertical lines

Press and hold the Shift key while inserting lines to make sure they are perfectly horizontal, vertical or at a 45-degree angle.

Keep objects in proportion

Press and hold the Shift key while resizing shapes and other objects to keep their proportions consistent. This is handy if you want to resize a circle without accidentally turning it into an oval.

Duplicate an object

Adding a bunch of identical objects? Just select your object and press Ctrl+D to duplicate it. This also works on slides.

Copy and paste formatting

If you want to format an object to look just like another object without reapplying all of the formatting by hand, use the formatting clipboard. Select the object whose formatting you want to copy and press Ctrl+Shift+C. Then, select the objects that you want to have the same formatting and press Ctrl+Shift+V to paste the formatting. This also works on the slide thumbnails if you have a slide background or theme that you want to copy from slide to slide.

This keyboard shortcut makes use of the Format Painter feature, which also allows you to copy formatting from one shape to another. The keyboard shortcut is a good one to remember since it packs even more power—once you’ve copied the formatting, you can paste the formatting onto as many shapes as you like without having to copy it again.

Group and ungroup

To group objects together, just select the objects and press Ctrl+G. To ungroup, select the object and press Ctrl+Shift+G. If you’re a Mac user, press CMD+Option+G to group and CMD+Option+Shift+G to ungroup.

Insert a new slide

Press Ctrl+M to insert a new slide after the currently selected slide. For PowerPoint for Mac, the keyboard shortcut is the same; you don’t need to substitute CMD.


Press and hold the Ctrl key while using the mouse wheel to zoom in and out in the editor. On a touch device, you can pinch to zoom. For PowerPoint for Mac, this is another one where you don’t have to substitute CMD.

Center or align text

To quickly center text, press Ctrl+E. Not happy with your centered text? To go back to left alignment, press Ctrl+L, or press Ctrl+R to right align the text.

Clear formatting

To remove all formatting from selected text, press Ctrl+Spacebar. This will reset the text back to the default formatting.

PowerPoint content placeholders have logic built in to make sure your text has the right size and formatting to match the rest of your presentation. If you’ve changed the formatting for some text or you have pasted in text that already had formatting on it, you can use the clear formatting shortcut to make the text match the design of the rest of your presentation again.

To clear formatting on PowerPoint for Mac, simply click the Clear Formatting button  on the Home tab.

Start Slideshow

Done editing and ready to present? To start a Slideshow from the first slide, just press F5. If you want to start from the current slide, press Shift+F5 instead.

As a bonus, here are a few more keyboard shortcuts you might have forgotten about. Happy editing!

Action Windows Mac Select all Ctrl+A ⌘+A Bold Ctrl+B ⌘+B Copy Ctrl+C ⌘+C Paste Ctrl+V ⌘+V Undo Ctrl+Z ⌘+Z Redo Ctrl+Y ⌘+Y Save Ctrl+S ⌘+S New presentation Ctrl+N ⌘+N Find text Ctrl+F ⌘+F Check spelling F7 F7


—Lauren Janas, program manager for the PowerPoint team

The post 10 little-known keyboard shortcuts for editing in PowerPoint appeared first on Office Blogs.

Episode 058 with Paul Katz on building Office add-ins for enterprise—Office 365 Developer Podcast

Thu, 08/13/2015 - 09:00

In this episode, Jeremy Thake and Richard DiZerega talk to Andrew Salamatov about the Outlook announcements at Build and Ignite along with a two hackathons that were run in New York and Chicago.

Download the podcast.

Weekly updates Show notes

Got questions or comments about the show? Join the O365 Dev Podcast on the Office 365 Technical Network.

The podcast RSS is available iTunes or search for it on “Office 365 Developer Podcast” or add directly with the RSS

About Paul Katz

Paul Katz is president and chief software architect of EfficiencyNext, a software solutions company in Washington DC. Paul has worked with Microsoft technologies for the last 18 years and has been an active SharePoint developer over the last 5 years, pursuing integration stories both by the book and by using new design patterns. Most recently, Paul has migrated much of his skills onto Microsoft Azure and Microsoft Office 365, leveraging tighter DevOps models the new platforms enable.

A busy parent with two kids, Paul understands the need to extract value out of every minute and sees Office 365 and the Add-Ins model as powerful tools for doing so.

About the hosts

Jeremy is a technical product manager at Microsoft responsible for the Visual Studio Developer story for Office 365 development. Previously he worked at AvePoint Inc., a large ISV, as the chief architect shipping two apps to the Office Store. He has been heavily involved in the SharePoint community since 2006 and was awarded the SharePoint MVP award four years in a row before retiring the title to move to Microsoft. You can find Jeremy blogging at and tweeting at @jthake.


Richard is a software engineer in Microsoft’s Developer Experience (DX) group, where he helps developers and software vendors maximize their use of Microsoft cloud services in Office 365 and Azure. Richard has spent a good portion of the last decade architecting Office-centric solutions, many that span Microsoft’s diverse technology portfolio. He is a passionate technology evangelist and frequent speaker are worldwide conferences, trainings and events. Richard is highly active in the Office 365 community, popular blogger at, and can be found on twitter at @richdizz. Richard is born, raised and based in Dallas, TX but works on a worldwide team based in Redmond. In his spare time, Richard is an avid builder of things (BoT), musician, and lightning fast runner.

Useful links

The post Episode 058 with Paul Katz on building Office add-ins for enterprise—Office 365 Developer Podcast appeared first on Office Blogs.

Managing Office 365 updates

Wed, 08/12/2015 - 09:00

Today’s post was written by Arpan Shah, senior director for the Office 365 team.

Over the past year, we released over 450 updates to Office 365, as noted by Julia White in this recent Office Mechanics show. As customers move from on-premises software to the cloud, they need new tools and processes to manage and administer change. We are committed to not only deliver the best productivity experience to end users but also provide an optimum experience to admins and developers who run and build on the service.

On today’s Office Mechanics show, I’m excited to tell you about some of the improvements we’ve made to Office 365 change management and tools—all based on your feedback.

Rolling out updates

I want to assure you that we recognize how Office 365 updates can potentially impact your organization. To ensure we deliver high quality updates and give you time to prepare, we will continue to improve the way updates are rolled out (illustrated below) to catch issues and obtain your feedback early.

It begins with our feature teams of engineers (Ring 0) who build and test proposed changes. Next, our Office 365 team (Ring 1) takes a test drive before releasing proposed updates to all Microsoft employees (Ring 2). Only after passing three internal hurdles do updates begin rolling out to our First Release customers (Ring 3). Once validated by our First Release customers, we incorporate their feedback before worldwide rollout (Ring 4). The sheer scale of Office 365 means that we stagger release to tenants, with some changes taking a few weeks or more before they’re implemented worldwide.

First Release lets you try updates early

First Release is designed to help customers prepare for updates. You can opt in to experience updates ahead of worldwide rollout within your tenant. In the show, I demonstrate how easy it is to turn on First Release in the Office 365 admin center for your organization as well as the new capability—based on your feedback—which allows you to select specific people to receive updates early. Learn how you can see changes before the rest of your organization when you enable First Release.

Making your life easier

We’re working hard to make your life easier in other ways, including some great resources:

  • Office 365 Roadmap—Follow Office 365 features as they progress through the development lifecycle, from development to rollout and launch. To stay up-to-date, it’s best to check the Roadmap every couple of weeks, or at least once a month. We added a “Recently updated” filter based on your feedback.
  • Message Center—This is where we post messages related to key changes to the service that you need to either be aware of or take some action. We recommend checking the Message Center on a daily basis. Note, you must be an Office 365 admin to access the Message Center.
  • Admin App—We updated the Office 365 Admin App on Windows Phone, iOS and Android so you can access Message Center, monitor service health and do simple admin tasks from whatever phone you prefer.
  •—This is your one-stop shop for everything you need to deploy and drive adoption of Office 365. Announcement and flyer templates and other great resources are here to help end users onboard and get excited about upcoming changes.

Please watch today’s show for demos of these Office 365 resources and see how easy it is to sign up for First Release, use the mobile Admin App and take advantage of Provide your thoughts in the “Join the conversation” section below. We’re listening to your feedback and continuously making improvements.

—Arpan Shah

The post Managing Office 365 updates appeared first on Office Blogs.

New Outlook partner add-ins and expanded rollout of preview

Wed, 08/12/2015 - 09:00

Earlier this year, we announced a preview of the new that lets you make the most of the moments that matter to you, featuring a refined inbox, new ways to collaborate, an upgraded calendar and support for partner add-ins. Today, we are pleased to announce new partnerships with Evernote, Yelp, IFTTT and Wunderlist to deliver solutions for both consumer and commercial Outlook users. Additionally, the Uber, PayPal, Evernote and Boomerang add-ins are beginning to roll out today. We’re excited about how partners are enhancing the Outlook experience through this integration.

In addition to new partners, we are also expanding the preview of the new to a broader audience. We enhanced the service based on feedback from our initial set of preview users and are broadening the rollout so that more users get access to these features faster.

Partner add-ins extend your email capabilities

Partner add-ins help you get more done right from your inbox—from finding cool restaurants for a dinner with friends to setting up a ride to get there and paying your portion of the tab. Here are more details on what you can do with these partner solutions:

  • Uber—Need a ride to your meeting or event? No problem, set up an Uber ride reminder for any calendar event with a single tap. Prior to the time of your ride, you get an Uber reminder on your phone with the destination already set. Simply swipe the notification, confirm your Uber ride, and your car will be on its way! Starting today, the Uber add-in is available in Outlook 2013 and Outlook on the web for users with Office 365 and Exchange 2013 mailboxes. It’s coming to users of the new within the next month.

  • PayPal—Need to pay your portion of the dinner tab or send money to your loved ones on their birthdays? You can do this directly from your inbox using the PayPal add-in for Outlook. Starting today, the PayPal add-in is available in Outlook 2013 and Outlook on the web for users with Office 365 and Exchange 2013 mailboxes. It’s coming to users of the new within the next month.

  • Evernote—Sharing your work with colleagues is simple with the Evernote Outlook add-in. Start an email, use the add-in view to find the note you want, and click to send it on its way. You can also clip emails from Outlook to Evernote, save them into a designated notebook, and add tags for an extra level of organization. Working effectively in and out of your inbox has never been easier. Starting today, the Evernote add-in is available in Outlook 2013 and Outlook on the web for users with Office 365 mailboxes. It also works with Exchange 2013 mailboxes but requires your Exchange IT admin to install the add-in. It’s coming to users of the new within the next month.

  • Boomerang—Schedule emails to send at the perfect time, get a reminder if your email doesn’t receive a response, and add a smart calendar assistant that lets you schedule meetings and share your real-time availability—all without leaving your email. Starting today, the Boomerang add-in is available in Outlook 2013 and Outlook on the web for users with Office 365 mailboxes. It’s coming to users of the new within the next month.

  • IFTTT (coming soon to—Want to add the weather report to your calendar at 6 a.m. every day? Or automatically send a notification to your phone when you receive a high importance mail? You will soon be able to use IFTTT to automate tasks and take action on your email in It works anywhere, anytime, on any device. IFTTT is already available in Office 365. We are now excited to announce it’s coming soon to as well.
  • Yelp (coming soon)—Need to find some cool restaurants for a dinner get-together with your friends? Stop the back and forth in email! Use the Yelp add-in in Outlook to find and suggest restaurants or coffee shops of your choice. The add-in will provide Yelp pictures, reviews, restaurant address and phone number and will insert these details directly into the body of your message or meeting invite.
  • Wunderlist (coming soon)—You will be able to create to-dos within Wunderlist right from your email using the Wunderlist add-in in

Are you interested in building apps for Outlook?

You can use Outlook add-ins and Outlook REST APIs for mail, calendar and contacts to reach both Office 365 and users. Learn more at

Join the conversation, we’re listening

As we expand the rollout of the new and add new partner solutions, we’re eager to hear your thoughts. Joining the conversation in the updated experience is easy—just click Feedback under the gear icon and you can make your suggestion without leaving your inbox. If you’d like to see and vote on other ideas, you can always visit Outlook.UserVoice and sign in with your Microsoft account.

We hope you’re eager to try out these new features. Watch this space for more news from the team, including new partner add-ins and features.


—The team


Frequently asked questions

Q. How can I get started with the new add-ins?

A. Starting today, the Uber, PayPal, Evernote and Boomerang add-ins are available in Outlook 2013 and Outlook on the web for users with Office 365 mailboxes. The Uber, PayPal and Evernote add-ins also work for users with Exchange 2013 mailboxes. These add-ins will be available to users of the new within a month.

Instructions for installing add-ins:

  1. In Outlook 2013, click the File menu and then click Manage Apps. If you are an Office 365 web user, click the gear icon on the top right, and then click Manage Apps/Add-ins.
  2. In the Manage Apps/Add-ins page, click the + sign and then select Add from the Office Store.
  3. Select the add-in you want to install and then click the Add button to begin installation.
    Note: For Evernote, Exchange 2013 users require their Exchange IT admin to install the add-in.

Q. You mention these updates are available to Office 365 users. Which Office 365 subscriptions are eligible?

A. The add-ins can be used with all Office 365 commercial subscriptions that include the web-based version of Outlook, including Business, Enterprise, EDU and Government plans. IT departments can manage user access to these and other add-ins through the Office 365 Administration center.

Q. What’s changed in the new version of

A. The new will let you do more, faster, through features such as a refined inbox, a new Skype experience, simplified sharing from OneDrive; new themes; and a new and improved calendar with search, as well as add-ins from a variety of partners. See our May blog post for more details about the features available in the preview.

Q. When will I get the update?

A. We’re broadening the rollout of the preview, in stages, over the next several weeks. We are bringing new users into the preview gradually so we can respond to feedback in a timely way as we improve the product leading into general availability.

The post New Outlook partner add-ins and expanded rollout of preview appeared first on Office Blogs.

Announcing the preview of Skype for Business apps for iOS and Android

Tue, 08/11/2015 - 09:30

Today’s post was written by Jared Goralnick, principal group program manager for the Skype for Business team.

We’ve seen great momentum in the first few months since the arrival of Skype for Business, and today, I’m excited to announce the preview of the new Skype for Business apps for iOS and Android. Here’s a look at what’s new and how you can participate in the preview.

What’s new?

We’ve infused Skype simplicity throughout the new iOS and Android apps, created a new dashboard for easy navigation of your contacts, calls and meetings, and updated the In-Call and In-Meeting experience.

The updated dashboard brings the contact search bar, your upcoming meetings and most recent conversations to one place.

  • Contact search bar—Search your Global Address List by first name, last name, email alias or even a phone number! On iOS, your phone contacts are also included in the search.
  • Upcoming appointments—Here you can see your current and next meetings in your calendar. You can either click through to read more about the meeting or click the Quick Join icon to join the meeting right away.
  • Recent conversations—Makes it easy to refer back to your most recent chats, phone calls and meetings.

We rebuilt the In-Call and In-Meeting experience with new features that make it easier to navigate calls and meetings on your mobile phone or tablet.

  • Larger buttons make it easier to mute, add participants and manage your call.
  • Video, which now fills the screen, brings you closer to your colleagues.
  • We made it easier to navigate between video and content with just one tap by simplifying the IM, video and content panes. While you can still view content in full screen, you can now also view content and see the speaker’s video at the same time!
Join our preview

If you have Lync 2013 on your iOS or Android device, you’ll get the new Skype for Business app as an update later this year. Skype for Business mobile apps work for anyone on Lync Server 2013, Skype for Business Server 2015 and Skype for Business Online.

To ensure IT administrators can prepare their end users and organizations for this change, we’ve added our Skype for Business iOS and Android apps to our Skype for Business Preview program.

To participate in the preview, IT administrators can visit to nominate up to four end users for iOS and four for Android to participate in the preview. Please apply by Friday, August 14, 2015 to be considered in our first batch of participants. We will begin notifying IT admins via email of their acceptance starting the week of August 17, 2015.

Sign up for the Skype for Business for iOS and Android Preview today!

The post Announcing the preview of Skype for Business apps for iOS and Android appeared first on Office Blogs.

Breaking down hierarchical data with Treemap and Sunburst charts

Tue, 08/11/2015 - 09:00

So far, we introduced you to our new cast of modern chart types and placed the spotlight on Waterfall charts—the classic financial powerhouse chart. Today, we dive deeper into the Treemap and Sunburst charts to help you visualize hierarchical data beyond the classic bars and circles. Bold and modern, the Treemap and Sunburst charts complement and strengthen the existing proportional chart types, like pie, doughnut and stacked column.

You can download the sample data we used for this blog post and try these new charts with the Office 2016 Public Preview.

What is hierarchical data and what does it look like?

Hierarchical datasets are perfect for layers within the data where natural groupings exist. They can be organizations within a business, regions within a country, makes or models of a product, or disciplines within a subject. Hierarchical data just requires some level of order and organizational structure. The example below, following a small bookstore inventory, illustrates the look and feel of hierarchical data.

Notice the table headings: Genre, Sub-Genre and Topic. These naming conventions create a hierarchical dataset. Topic is a subset of Sub-Genre, while Sub-Genre is a subset of Genre. Recognizing data within a hierarchy is intuitive and simple. In a sparse hierarchy form of data, like the example above, the parent—the category that represents a collection of data points (e.g. Genre)—is identified to the left. In the case of an empty cell, the parent category is the previous (or above) line item. If all the cells were filled out, like in the example below, a Treemap or Sunburst chart can still be created.

Regardless of the format of your hierarchical data, you can create a Hierarchy Chart by clicking the Treemap or Sunburst icon on the Insert ribbon to reveal insights into your data.

Picking between Treemap and Sunburst

After getting acquainted with the concept of hierarchical data and the Treemap and Sunburst charts, you might wonder, “Why use one over the other?” The answers lie in what information you want to convey in the chart. Treemaps, by their rectangular nature, are better suited for comparison among hierarchical levels. Just in the way our minds differentiate size and shape, rectangles and straight lines are easier to compare than slices and angles. Treemaps are optimized to show lots of data, because it stretches to within its bounding box, whereas plotting a Sunburst is fitting a circular chart into any rectangular window. Space that could be used to tell a story with your data is lost in the corners.

When space is not an issue, Sunburst shines through by painting the full picture of the hierarchy and thereby illustrating the different depths of hierarchical groups. A Treemap loses the categories in the middle. Upon further analysis of the “Children’s Books” at the top-left of Treemap, the Sub-Genre of “Age 3-5” is not shown, whereas the Sunburst adds that additional layer of information in the same colored slice. From the Sunburst, we know “ABCs” and “Tolstoy for Tots” are grouped together under the “Age 3-5” parent group.

Sunburst also wins in adding the dimension of depth to each parent branch. The Sunburst unveils that the “Children’s Books” Genre has Sub-Genres that extend into specialty topics. In your work, use the uneven branching to emphasize and draw attention to a single slice, further teasing apart the contributions. For example, a sales report may want to highlight a specific month. A deeper look into that category will elicit more insights and naturally draws attention to your message.

Tips to create hierarchical charts

We want you to design beautiful charts that are intuitive and friendly. With that in mind, we grouped associations by color. Displaying all data labels—especially long ones—would give the illusion that your chart is uncomfortably bursting at the seams. So labels are automatically truncated or dropped off of the visual to produce an elegant, uncluttered look. Simply enlarge the size of the chart to add more information in a clean, measured way. The Sunburst on the right shows fewer data labels since there is less chart real estate to display information.

Treemap has the added benefit of adding parent labels—labels specific for calling out the largest parent groupings. To display these options, double-click anywhere on the Treemap, and the Formatting task pane appears on the right. Under the Series Options, you can snap and toggle between Overlapping and Banner, or have no parent labels at all.

The label options for Overlapping and Banner are shown below, respectively, for side-to-side comparison.

Your turn

Try out Treemap and Sunburst, along with the other new charts, in the Office 2016 Public Preview and create a look for your data unlike any other chart you have previously used in Office.

If you have any comments or questions, please feel free to leave them below.

—The Excel team

The post Breaking down hierarchical data with Treemap and Sunburst charts appeared first on Office Blogs.

Office 365 news roundup

Fri, 08/07/2015 - 13:35

Windows 10 is here! The best Windows yet, delivered as a service and kept automatically up-to-date with new innovations and security updates, launched last week as a free upgrade. As part of the launch, we also released the all new Office Mobile Apps for Windows 10. Customers in 190 countries can now download and install the apps from the new Windows Store and immediately start being more productive on the go. In conjunction with the launch, we also spelled out which capabilities in Windows 10 will benefit Office 365 admins.

Windows 10 is big news, but it’s not our only news. As part of our ongoing work to deliver the richest email and calendar experiences on the web, we announced an array of exciting updates to the web version of Outlook in Office 365. “Outlook on the web,” formerly known as the Outlook Web App (OWA for short), is getting an improved user interface (UI) and new features to help you work more efficiently, stay on top of your inbox, and do a better job of managing your calendar. We also launched Send, a new app designed for quick, brief, in-and-out email, similar to a text or instant message. Send is connected to Office 365, which means your conversations are synced with Outlook, letting you continue the conversation from anywhere. And just like regular email, you can message anyone with an email address.

In addition, we announced the general availability of Sway, the digital storytelling app that lets users create and share interactive reports, presentations, assignments, lessons, projects and more. We’ve started rolling out Sway to all eligible Office 365 business and education customers worldwide, and of course, any consumer can use Sway with a free Microsoft account. We also introduced Sway for Windows 10, along with new layout and publishing capabilities.

All of these innovations and improvements are part of our ongoing commitment to make Office 365 the best productivity solution for every device and every platform.

Below is a roundup of some key news items from the last couple of weeks. Enjoy!

Review: Windows 10—Learn why you should upgrade to Windows 10, according to the editors of Wired.

Microsoft’s cloud bets pay off as Office 365 sees big growth—Find out how Office 365 is growing quickly and contributing to the company’s cloud strategy.

UL—product safety leader maintaining security and moving at the speed of innovation with Office 365—Find out why protecting customers’ intellectual property is UL information security director Robert Jamieson’s top priority—and how Office 365 helps him achieve that goal.

Adventist Health System boosts productivity with Office 365 ProPlus while complying with HIPAA—Discover how Office 365 helps this large healthcare organization stay productive, secure and compliant.

Office 365 joins IFTTT to automate routine tasks—Learn more about using IFTTT on Office 365.

Microsoft levels up web version of Outlook for business customers—Find out more about the changes, upgrades and improvements Microsoft has made to the web version of Outlook.

Souping up Office 365—Learn how Microsoft is continuing to improve Office 365.

The post Office 365 news roundup appeared first on Office Blogs.

Catalent—pharmaceutical tech company boosts global efficiency, productivity with Office 365

Fri, 08/07/2015 - 09:00

Catalent, a global pharmaceutical technology company, is undergoing a transformation from a collection of 30 semi-autonomous sites to an increasingly productive, cohesive global organization. One reason is that Catalent deployed Microsoft Office 365 to build a faster, more productive and interconnected work environment. Today, employees are using Office 365 communication and collaboration services to drive engagement, expedite clinical trials, improve customer service, and build a competitive advantage.

“Imagine the communications required to organize the 150,000 clinical shipments that we deliver to 80 countries every year, or the coordination required to successfully deliver the 70 billion doses that we manufacture annually. The more seamless the communication and collaboration among global sites, the more we can build our competitive advantage—that’s the value we are getting from Office 365.” —Michael Del Priore, senior vice president and chief information officer at Catalent

Read the Office 365 case study from Catalent.

The post Catalent—pharmaceutical tech company boosts global efficiency, productivity with Office 365 appeared first on Office Blogs.

Drupal 7 Appliance - Powered by TurnKey Linux