You are here

Feed aggregator

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

MS Access Blog - Fri, 04/08/2016 - 09:00

Excel 2016 includes a powerful new set of features based on Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

Today, we are pleased to announce two updates to this powerful feature set. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved Data Connectivity features:

  • ODBC Connector—Support for selecting User/System DSNs
  • CSV Connector—Ability to specify Column Delimiter in the Source dialog
ODBC Connector—Support for selecting User/System DSNs

A common request from customers using the ODBC Connector was being able to select from a list of available DSNs on their machine when specifying the connection details in the Import from ODBC wizard in Power Query in Excel.

With this update, we added a new drop-down menu so users can select an existing DSN from the list of available User/System DSNs on their machine. In addition to selecting an existing DSN, users can specify additional Connection String details or select “None” in the DSN drop-down to specify a full Connection String independently from any existing DSNs (equivalent to the behavior prior to this update).

CSV Connector—Ability to specify Column Delimiter in the Source dialog

We improved the Source dialog for the CSV Connector so that users can customize the Column Delimiter option. Before this update, the Column Delimiter option could only be modified via editing the underlying M formula for the Source step.

How do I get started?

Excel 2016 provides a powerful set of capabilities for fast, easy data gathering and shaping, which is available under the Get & Transform section on the Data ribbon. Updates outlined in this blog 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.

—The Excel team

The post April 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in appeared first on Office Blogs.

What’s new: March 2016

MS Access Blog - Fri, 04/08/2016 - 09:00

March brought a new tool for migrating your Evernote notes to OneNote, PowerPoint Designer enhancements and new language support in Office for Mac and Skype Translator, plus collaboration and Power Pivot updates. For business users, Skype for Business meetings experiences and voice services are being expanded, video viewer statistics are rolling out in Office 365 Video, a new reporting portal in the admin center is rolling out, new update options are available for Office 365 ProPlus and Office 365 Connectors is here. The redesigned OneNote Class Notebook—designed and built with teachers—is available worldwide. And for devs, there’s a new site for keeping up with the latest news and resources.

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: February 2015.

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

Windows tablets and iPad Pro updates—Take a video tour of the recent updates to the Office experience for Windows 10 tablets and what’s new with Office for the iPad Pro. Watch demonstrations of time savers and touch optimizations in Excel, slide design and transition updates in PowerPoint and ink annotation in Word—and across the Office apps. Also, see the inking experiences translate to the iPad Pro and more.

Sway integration in Microsoft Photos and support for Living Images—With the integration of Sway in Microsoft Photos, it’s easier and faster than ever to use the photos and videos on your Windows device to create and share interactive stories of your adventures. With just one click, you can create a Sway from a Microsoft Photos album. You can also now add Living Images from your Windows 10 device to your Sways to breathe more life into your creations.

Collaboration in Office—chat with your co-editors in real time via Skype!—Now, when you’re working with other people on a OneDrive document in Office Online, you can communicate with your fellow editors in real time via Skype, without leaving the document. To start a chat, just click the blue Chat button next to the list of co-editors for your shared document. And if IMs aren’t enough, you can quickly turn your conversation into a group call or video chat.

Make the move from Evernote to OneNote today—OneNote is one of the most popular note-taking apps. If you’ve hesitated to switch to OneNote because all your ideas and information reside in Evernote, wait no more. Download the new OneNote Importer tool today (available for Windows now and coming soon for Mac). The Importer tool migrates your Evernote notes into OneNote, so you can have all your notes in one place, on all your devices. Find out how to download the tool and get started using it.

New feature updates for Power Pivot in Excel 2016—New and improved features are available as part of your Office 365 subscription. You can now save the data model diagram view as a high resolution image file that you can use for sharing, printing or analyzing. Enhancements to the Edit Relationship dialog help you create faster and more accurate data relationships. Several important bug fixes improve your overall modeling user experience.

Excel Online updates—The March Excel Online updates help you with some of your most common spreadsheet tasks. The addition of more number formats to display your data gives you new ways to format data. You can now connect your spreadsheet to more places using hyperlinks. And the new Filter dialog in Search dialog helps you easily find the values you want to display, giving you even more ways to explore data using PivotTables. Read what else is new.

New to Office 365 in March—move from Evernote to OneNote, PowerPoint Designer updates and more—This month’s updates include a tool for migrating your Evernote notes to OneNote, the ability to search in OneNote for handwriting in photos, enhancements to PowerPoint Designer and new language support in Office for Mac (Arabic and Hebrew) and Skype Translator (Arabic). For commercial customers, Skype for Business meetings experiences and voice services are being expanded, Office 365 Project Portfolio Dashboard will soon be available to add to Project Online and video viewer statistics have rolled out to Office 365 Video.

PowerPoint Designer—what’s new and what’s next—Three enhancements give you more creative options and greater visual impact—within seconds. With support for multiple images, you can now insert more than one image to represent your ideas. New color extraction capabilities add even more value to Designer’s automated recommendations. And facial recognition enhancement improves Designer’s cropping capabilities for images with faces. Better visual options for bulleted text, data points and lists are on the way.

Office 365 for Business and Education updates*

Announcing the new Office 365 admin center—The new Office 365 admin center—now rolling out worldwide—makes it faster, easier and more efficient to manage Office 365. It shows frequent tasks directly on the dashboard and simplifies the admin experience. The new Search bar helps you quickly find the feature you want to use. Significant improvements to Office 365 reporting are rolling out, too. Read about these and the enhancements that are on the way, like customization and contextual help.

Updates for Get & Transform in Excel 2016 and the Power Query add-in—Excel 2016 includes Get & Transform, a set of features that provides fast, easy data gathering and shaping capabilities. Updates to Get & Transform include many new or improved data transformation features, like new filters and the ability to copy and paste queries between Power BI Desktop and Excel. The updates are available to Office 365 subscribers. If you have Excel 2010 or Excel 2013, you can get these updates by downloading the latest Power Query for Excel add-in.

Introducing the Class Notebook add-in for OneNote—designed and built with teachers—The OneNote Class Notebook has been redesigned, with the teacher at the center every step of the way. Top-requested features include: easy and quick distribution of pages or new sections to students; individualization through distribution of pages to specified students or student groups; rapid sequential reviewing of student work and more. The preview of the Class Notebook add-in for OneNote is now releasing in 43 languages, across 61 worldwide markets, so teachers around the world can try it out immediately.

New update options for Office 365 ProPlus using System Center Configuration Manager—IT admins can now manage Office 365 client updates—including those for Office 365 ProPlus, Visio Pro for Office 365 and Project Pro for Office 365—directly via the System Center Configuration Manager built-in software updates workflow engine. Watch the video to see how it works. The new capability is available in the upcoming release of Configuration Manager update 1602, currently in Technical Preview.

Office 365 integration and updates to Dynamics CRM—With new capabilities that span Office 365 Groups, the Office Graph and inherited Protection Center controls, Office 365 and Dynamics CRM work even better together to help boost productivity. Watch the video that goes hands-on with the latest Dynamics CRM to highlight Office 365 integration for sellers, admins and developers, demonstrating how CRM creates Office 365 Groups to improve collaboration, how you can access CRM data in Outlook email and more.

Expanding the reach of Skype for Business meetings and voice services in Office 365—Skype for Business Cloud PBX, Meeting Broadcast and PSTN services launched three months ago, and the first major geographic expansion is already under way, with PSTN Conferencing available for purchase in 32 countries. More expansion is on the way, including new support for hybrid deployments and new meeting room solutions, as well as improvements to unified reporting, management and analytics for enterprise communications. Find out what’s coming that can help you power modern meetings.

New reporting portal in the Office 365 admin center—The new reporting portal in the Office 365 admin center is rolling out now. It provides you with valuable insights about how the Office 365 services are being used and delivers details down to the individual user level. New reports provide insights you can act on, and the cross-service portal gives you more visibility into your organization’s use of Office 365.

What’s new—Office 365 Video—Watch the video to see highlights of the innovations rolling out now, including video viewer statistics, a more centralized way to upload videos, the ability to upload your own subtitle files and choose your own thumbnail, enhanced discoverability, and an easier way to insert a video into a SharePoint page or team site. New admin controls were added, too, giving admins control over who can download videos based on channel permissions and over Yammer settings per channel.

Introducing Office 365 Connectors—Office 365 Connectors, a brand new experience that delivers relevant interactive content and updates from popular apps and services to Office 365 Groups, is here. Whether you’re tracking a Twitter feed, managing a project with Trello or watching the latest news headlines with Bing, Office 365 Connectors surfaces all the information you care about in the Office 365 Groups shared inbox, so you can easily collaborate with others and interact with the updates as they happen. Find out how Office 365 Connectors can enhance your team collaboration.

Office 365 developer updates

The latest news for devs—For the latest dev news, code samples, resources and documentation, as well as help getting started with Office 365 APIs, Office add-ins and more, follow this site.

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: March 2016 appeared first on Office Blogs.

April’s MTC Studios webcast series—”Unlocking the Power of Your Data Platform”

MS Access Blog - Fri, 04/08/2016 - 09:00

In the emerging data economy, how well a business uses advanced analytics to get insights from data can become a major competitive differentiator.

Join the Microsoft Technology Centers’ (MTC) four-part webcast series—live or on-demand—to learn more about how you can improve your business performance dramatically, through mission-critical capabilities, comprehensive security and deep business insights, with a modernized database platform.

Part 1—”Running Your Mission Critical Line of Business Applications”

This session focuses on how SQL Server can help you achieve the performance you need for mission critical workloads. Read more.

Part 2—”Unlock Insights from Your Data”

This session focuses on how you can improve productivity and deliver insights faster with SQL Server’s new capabilities. Read more.

Part 3—”Microsoft Advanced Analytics”

This session focuses on how you can capture, transform, analyze and visualize data in its native format with SQL Server. Read more.

Part 4—”Azure HyperCloud: Cost Reduction, Increased Agility and Improved Scalability”

This session focuses on how to extend and modernize your database infrastructure by leveraging the cloud. Read more.

To register for the full series, visit “Unlocking the Power of Your Data Platform” webcast series.

You can also register for individual sessions below. All sessions begin at 10 a.m. PT and last 45 minutes.

The post April’s MTC Studios webcast series—”Unlocking the Power of Your Data Platform” appeared first on Office Blogs.

Microsoft Translator now offers the most comprehensive translation solution for the iOS ecosystem

MSDN Blogs - Thu, 04/07/2016 - 10:25

Today we are announcing two new features for the Microsoft Translator app for iOS, making it the most comprehensive free translation solution for iPhone, iPad and iPod users. In addition to text, conversation and image translation already available, we are adding support for offline (i.e. not connected to the Internet) and webpage translation.

Until now, iPhone users needed an Internet connection if they wanted to translate on their mobile devices. Now, by downloading the Microsoft Translator app and the needed offline language packs, iOS users can get near online-quality translations even when they are not connected to the Internet. This means no expensive roaming charges or not being able to communicate when a data connection is spotty or unavailable.

The new offline language packs use the same Deep Neural Network technology we recently introduced in the Microsoft Translator app for Android. Deep Neural Networks, also known as Deep Learning, are a state-of-the-art machine learning technology that have been used for almost a year by the Microsoft Translator online cloud service to deliver high-quality translations to Microsoft Translator apps and They are also used to power the speech translation technology in the new speech translation API and Skype Translator.

Deep Neural nets allowed Microsoft Translator to be the first translation service to deliver online-quality* translations when downloadable language packs were added to the Android app in February 2016. Now available for iOS users as well, they provide the highest-quality offline translation available on the market.

In conjunction with this release, we are also adding 34 new languages to the list of offline languages supported by Microsoft Translator apps on both Android and iOS. Language packs can now be downloaded for all of the following languages. You can always view up-to-date language lists at

Arabic Greek Romanian Bosnian Hebrew Russian Bulgarian Hindi Serbian Catalan Hungarian Slovak Chinese Simplified Indonesian Slovenian Chinese Traditional Italian Spanish Croatian Japanese Swedish Czech Korean Thai Danish Latvian Turkish Dutch Lithuanian Ukrainian Estonian Malay Urdu Filipino Norwegian Vietnamese Finnish Persian Welsh French Polish   German Portuguese  

In addition to the new downloadable offline language packs, this update to the Microsoft Translator app for iOS includes a new Safari extension which lets users translate web pages within their Safari browser. After you have turned your extension on, whenever you find yourself on a webpage in a language you don't understand, just click on "Microsoft Translator" from your list of available extensions and it will be translated automatically.

Thanks to these new offline and Safari extension features users now have access to an unprecedented breadth of support for all their translations needs.

For instance, next time you travel, you can use the Microsoft Translator to:

  • Get from the airport or a conference to your hotel by pinning preplanned translations to your favorites.
  • Respond to something you didn't plan ahead for by getting quick translations of short phrases by typing or speaking into your phone. You can also speak the phrase into your Apple Watch if your phone is in your pocket or purse.
  • Translate instant messages, texts and other content by simply copy-pasting it from and to the Translator app.
  • Translate signs and restaurant menus with the image translation feature. This also works with pictures you receive by email or save from online sites or social media posts.
  • Download the new offline language packs so you'll be sure to be able to translate text and images if you don't have an internet connection.
  • Use the text to speech feature to let the app do the talking and ensure you have the right pronunciation.
  • Use the conversation feature to engage in natural conversations to find out the best local restaurants from the concierge, a cab driver, or maybe just someone you happen to meet.
  • View that restaurant's website in your own language before you visit using the new Safari extension
for iOS


More Apps:

* Our standard tests have shown the quality of our offline language packs are comparable to the translations you get when connected to the Internet. Calculated using BLEU scores, and tested against legacy offline language packs for Microsoft Translator for Windows and competitor's current solutions. Actual translation quality will vary by language and topic.

Introducing Wunderlist, Facebook and Evernote in Outlook on iOS and Android

MS Access Blog - Thu, 04/07/2016 - 08:00

The Outlook team is passionate about making your life easier by helping you manage and make the most of your time. We believe this starts by having a clear and complete view of what your day looks like. Today, Outlook provides the ability to view calendars from, Office 365, Gmail, iCloud and more—all in one place—with your email, contacts and files all quickly accessible as well. But we know your digital world is so much bigger than that.

This is why we are launching Calendar Apps for Outlook on iOS and Android. With Calendar Apps, you can connect your apps—Wunderlist, Facebook and Evernote to start with—to see all your tasks, events and notes from your digital life in one place: your Outlook calendar. By connecting your calendar with a wide range of services, Outlook will be able to provide you with a far better view of your day, week and months ahead.

Those of you who use and love Sunrise will be familiar with this capability. Since the Sunrise team joined Outlook, we’ve been hard at work bringing all the goodness and extra features from their app directly into our calendar to give you a single, powerful app for managing your personal and professional life. Calendar Apps, along with a two-week mini-calendar, three-day view and iOS calendar widget, have already made it to Outlook, with Connected Calendars up next.

Let’s take a quick look at how Outlook’s calendar can keep you on top of it all.

Outlook calendar with the Facebook, Wunderlist and Evernote Calendar Apps.


Wunderlist is a simple to-do list app that helps you get stuff done. With Wunderlist’s new Calendar App for Outlook, you can get an overview of your most-pressing to-dos, in the place where you plan and schedule your day—your Outlook calendar! We think it’s productivity perfection.

To get started, connect your Wunderlist account with Outlook. Simply swipe from the left while in Outlook’s calendar and next to Calendar Apps tap the Add button. Now, thanks to a little Outlook-Wunderlist magic, all of your to-dos with a due date appear on your calendar in the All Day section. But what about your all-important notes? Just tap to-do and you’ll have all the details you need.

Pro tip—In Outlook’s calendar menu, you can select the lists you want to view on your calendar and specify colors to make your important tasks stand out.

Wunderlist also recently released an add-in for users of the new, Outlook 2013/2016 and Outlook on the web for Office 365. Learn more and install the add-in on their blog.


Facebook’s mission is to help people connect and spend time together in the real world. One of the features that helps people coordinate and plan events with their friends and family is Facebook Events.

After connecting your Facebook account to Outlook, you can view any event you’re invited to or have accepted, as well as your friends’ birthdays. Once you open an event, you can RSVP and view event details and location. If you need additional information, just tap Open in Facebook to jump right into the Facebook app. You’ll never miss your cousin’s birthday again!


Evernote gets you effortlessly organized with notes, to-dos and more. Whether preparing notes for a big meeting or tracking your grocery list, having those notes available on your calendar when you need them makes your whole day easier.

Set a reminder on a note and it will appear on your calendar, complete with a link to the note. Outlook not only shows you what’s important in your day, it gives you immediate access to the information you’ve placed in Evernote, so you’re always prepared.

Evernote also has an add-in for the new, and Office 365 users with Outlook 2013/2016 or Outlook on the web.

Have an idea for Calendar Apps? Let us know by submitting a new feature idea or voting for an existing one in our in-app support (Settings > Help & Support > Suggest a Feature). Stay tuned for more to come, including additional Calendar Apps and integrations with Skype for Business, OneNote and more. We know your digital world is large and Outlook is here to help you stay connected and on top of it all.

The post Introducing Wunderlist, Facebook and Evernote in Outlook on iOS and Android appeared first on Office Blogs.

Build 2016 Follow Up

MSDN Blogs - Wed, 04/06/2016 - 10:24
The indexer had a presence again in BUILD this year. Here are few links for more information:

Code samples for the post and video

Video talk from //BUILD 2016

Companion Blog Post for the Video

Take back your time with Delve Analytics

MS Access Blog - Wed, 04/06/2016 - 09:00

Earlier this week, business leaders from some of the most forward-thinking companies in the world gathered in New Orleans for the Microsoft Envision conference. Microsoft CEO Satya Nadella spoke about the digital transformation of society and business, and how the use of intelligent systems can empower organizations by helping people understand more about the way they work. So today, we wanted to provide a deeper look at one of the newer capabilities in Office 365 that does just that—Delve Analytics.

In today’s modern workplace, we have more ways to communicate and collaborate with others throughout the course of our workday than ever before. In Office 365, you email and chat, have audio and video calls and meetings, collaborate on documents and share them with colleagues in the cloud. The Office 365 service processes millions of these interactions every day. Meanwhile, the Office Graph organizes these signals and applies sophisticated machine learning to them, all while maintaining strict privacy controls. As a result, Delve Analytics delivers you insights about how you work, ultimately helping you to work smarter, not harder.

Watch this quick video to learn a bit more about Delve Analytics:

Your personal dashboard for work

If you have an Office 365 sign-in through work and are licensed for E5 or the Delve Analytics add-on, you can access your Delve Analytics personal dashboard. Simply go to the Office 365 web experience at, open Delve from the app launcher and click Analytics on the left-hand side of the window. At the top of your personal dashboard, you’ll see a summary of how much time you’ve spent this week in meetings, on email, in focused work time and working after hours. You can set goals for each of these areas to work towards.

The Network section focuses on who you are interacting with the most, how quickly you read and respond to their emails and displays people you may want to catch up with.

Below that, Email information helps you gain visibility into how much time you spend reading and writing emails, average read rates and response times for emails you send and receive, all of which can help you think about whether there are ways to make your email communications more effective.

The Focus hours module provides data on how often you have at least two hours between meetings, so you can sit down and work. You may have days when you’re stuck in back-to-back meetings and find you don’t have time to sit down and get work done. By evaluating your focus hours, you might be able to simply rearrange your schedule to find more of that time.

The After hours module offers insight into time spent working outside of standard work hours to help provide insight into balance of personal and professional priorities.

The Meetings module will show you how much time you’re spending in meetings, which meetings are taking up the most of your time and the quality of meetings. Meeting quality metrics includes information about why specific meetings on your calendar may have been ineffective, so that you can decide things like whether to change or reduce the attendee list for certain meetings, shorten recurring meetings or cancel an ineffective meeting altogether.

The Delve Analytics add-in for Outlook surfaces insights about emails you have received and sent. The insights include information about email performance like read rate, forwards, replies and email activity over time. For more information on the Outlook add-in, visit Delve Analytics Outlook add-in.

Small changes can add up to big impact

All of the above metrics are designed to equip you with data that can inform even small changes in your day, since we know that when a lot of individuals within an organization make small changes, it can add up to very real and significant change at the organization level.

Check out the Microsoft Mechanics show with Ryan Fuller, general manager of Delve Analytics, to learn more about Delve Analytics and where we’re taking it in the future.

—Nick Robinson, senior product marketing manager for the Office 365 team

Frequently asked questions

Q. How can I buy Delve Analytics?

A. Delve Analytics is available today as part of the Office 365 E5 plan or as an add-on to Office 365 Enterprise plans. See the product website for more details at

Admins can visit Delve Analytics for Office 365 admins to learn more about how to configure Delve Analytics for end users in your organization.

Q. How does Delve Analytics approach privacy?

A. Your Delve Analytics dashboard is made just for you, and nobody else can see it. Most of what you see—such as how much time you spend in meetings or how long it takes someone to respond to your mail—is based on data you can already find in your mailbox. Some of the information you see in your dashboard is based on what others are doing—like the average time people in your organization spend in meetings or how fast large groups are reading your email—but Delve Analytics presents this information in an aggregated form of reporting that is designed to protect individual privacy.

Q. What admin controls are available with Delve Analytics?

A. Admins have the ability to purchase and assign licenses and enable Delve Analytics for all users or a specific set of users within their tenant.

Q. What end user controls are available?

A. Delve Analytics capabilities are designed not to expose any private, personally identifiable information to others. Information that is not otherwise available to you is presented in aggregated form in an effort to protect individual privacy.

Within Delve settings, end users will have an opt-out setting available to prevent their individual data from being contributed to aggregated benchmarks.

The post Take back your time with Delve Analytics appeared first on Office Blogs.


Subscribe to Randy Riness @ SPSCC aggregator
Drupal 7 Appliance - Powered by TurnKey Linux