Office Remote – Windows Phone Remote Access for Microsoft Office

Office Remote

Office Remote turns your Windows Phone into a smart remote for Microsoft Office, providing convenient touch-based control of Word, Excel, and PowerPoint documents projected from your PC. It lets you show what you want, when you want, with all the freedom you need to walk around and connect with your audience.

Office Remote is a Microsoft Research application developed in partnership with Microsoft Office. The goal of our ongoing collaboration is to create more natural and seamless interaction across multiple screens and devices, in ways that help people to create and communicate more effectively.

Video

Releasing Office Remote as a research application is one of many ways in which we hope to gain a deeper understanding of real-world presentation practices. Try it out and let us know what you think. Your feedback is valuable to us, and we will use it to inform the design of new tools, technologies, and applications that have the potential to transform everyday productivity activities for the better.

Requirements

– Microsoft Office 2013 (does not work with earlier or RT versions)
– Bluetooth on your PC (does not work on PCs without Bluetooth)
– Desktop Add-In for Office installed on your PC (download here)

Usage

Open the Office documents you want to project, pick up your phone, and you are ready to present.

Start your PowerPoint slideshow and navigate slides with ease. Large, easy to reach buttons give you direct access to the next and previous slides, while bringing up the list of slide thumbnails gives you fast access to any presentation slide without missing a beat.

Stay on time and on-message with a glanceable timer, progress indicator, and speaker cues extracted from your slide notes.

Want to highlight a key point? Simply activate the touch-based laser pointer for accurate, non-shaky pointing at a distance.

Want to share data? Jump into Excel spreadsheets and hop between sheets and graphs. Wow your audience by controlling complex data slicers from the palm of your hand, bringing your argument to life.

How about more details? Smoothly switch to Word documents, scrolling freely or jumping directly to specific sections or comments.

Here is a full list of features incorporated in Office Remote:

PowerPoint

– Navigate next slide/previous slide
– View slide thumbnails and jump to slide
– View speaker notes on phone
– View presentation timer and slide progress
– Laser point using touch on your phone

Excel

– Navigate rows and columns
– Change sheets by swiping
– Use Slicers, PivotTables and Filters
– Jump to any named object in your workbook
– Change zoom level

Word

– Jump to headings
– Jump to comments
– Screen up/down
– Line up/down
– Change zoom level

 

Download

Mobile App for Windows Phone 8

Desktop Add-In for Office 2013

SkyDrive Pro for iOS v1.1 app released

SkyDrive Pro for iOS v1.1 app released

on October 14

Mark Kashman (@mkashman) is a senior product manager on the SharePoint marketing team.

Microsoft introduced the SkyDrive Pro for iOS v1.0 app June 2013 enabling business users to access and view documents stored in SharePoint Online from iPhones and iPad. Our promise to deliver faster-paced, continuous innovation continues with today’s announcement of the SkyDrive Pro for iOS v1.1 app.

SkyDrive Pro for iOS v1.1 introduces a premier mobile editing experience for Office 365 for business users. The documents you work on remain in their original source location, SharePoint Online in Office 365, enabling you to work with your Word, Excel, PowerPoint, and OneNote documents – to easily keep track of them, even while on the go. To provide this kind of rich editing experience, Microsoft developed a clear connection between SkyDrive Pro for iOS and other Office-related apps (Office Mobile for iPhone, Office Web Apps, and OneNote for iPhone/iPad).

Let’s see how it all works.

View, share, and edit files stored in SkyDrive Pro from your iPhone

1.       Make sure you have both SkyDrive Pro for iOS v1.1 installed and the latest update of Office Mobile for iPhone from the App Store. Both apps now support iOS 7.

2.       Launch SkyDrive Pro for iOS and open one of your Office documents. It will launch in View mode using the embedded Quick Look iOS technology.

3.       In the upper right, select the more options button, and then select Edit. The document opens in Office Mobile for iPhone, while maintaining file integrity in-place in SharePoint Online.

4.       Make your edits, review and add comments.

5.       Save the file to SkyDrive Pro.

Select Edit to launch Office Mobile for iPhone from SkyDrive Pro for iOS on your iPhone.

View, share, and edit files stored in SkyDrive Pro from your iPad

1.       Make sure you have the latest SkyDrive Pro for iOS v1.1 installed.

2.       Launch SkyDrive Pro for iOS and open one of your Office documents. It will launch in View mode using the embedded Quick Look iOS technology.

3.       In the upper right, select the more options button, and then select Edit. The document opens in the corresponding Office Web App within the native iPad Safari browser.

4.       View and edit your Word document, present a PowerPoint presentation, or even co-author an Excel workbook. All your files are at your fingertips, managed and shared by you from your SkyDrive Pro.

5.       Save the file to SkyDrive Pro. Share with a colleague. Get work done.

 

Select Edit to launch the corresponding Office Web App on an iPad in the native Safari browser.

 

Open OneNote files from SkyDrive Pro directly to OneNote for iPhone and iPad

The OneNote for iPhone and iPad apps recently added support for Office 365. Now, in combination with this update to the SkyDrive Pro for iOS app, you can both view and edit OneNote notebooks stored in your SkyDrive Pro, natively within the iOS OneNote apps. Your notes appear the same-even rendering ink-across all your devices (Windows, Windows Phone, Android, iOS). The OneNote file remains connected to your SkyDrive Pro in Office 365, allowing you to keep track of your work notes, all in place, even on the go.

1.     Make sure you have the OneNote app installed on your iPhone or iPad.

Install OneNote for iPhone and OneNote for iPad from the App Store.

2.     In the SkyDrive Pro app, select the file from the folder view, and then select Edit.

3.     Review and add to your notebook.

4.     Save your notebook to SkyDrive Pro.

 

Select Edit to open a notebook directly in OneNote in SkyDrive Pro for iOS v1.1 on your iPad (shown here) or iPhone. 

What do you want to see next from SkyDrive Pro for iOS? Let us know in the comments section below, after you play with the latest version. Help shape the future.

Thanks,

–Mark Kashman

Senior Product Manager – SharePoint

@mkashman

 

FAQ

Q:  Which Office 365 plans can use the SkyDrive Pro for iOS v1.1 app?

A:  The SkyDrive Pro for iOS v1.1 app is designed for Office 365 for business users who have usage rights to SkyDrive Pro.  Specifically, these plans are:  Office 365 Small Business (P1), Office 365 Small Business Premium (P2), Office 365 Midsize Business, Office 365 Enterprise E1, E3, and E4, Office 365 Education A2, A3, and A4, and Office 365 government G1, G3, and G4.  Please note that Kiosk users and external users do not have usage rights for SkyDrive Pro personal storage.

Q. Does this announcement apply to Office 365 Home Premium subscribers?

A. No. SkyDrive Pro is not the same as SkyDrive. The “Pro” is based on SharePoint, enterprise-grade content management. Thus, this article does not apply to Office 365 Home Premium, which combines the latest Office applications with 20 GB of SkyDrive storage, which can then be accessed via the SkyDrive for iOS app.

Q. Does this announcement apply to Office 365 dedicated subscribers?

A. No. The SkyDrive Pro for iOS v1.1 app does not yet support Office 365 dedicated plans. We are committed to providing SharePoint Online Dedicated customers access in a future app release.

Q. Does this announcement apply to customers who have deployed SharePoint 2013 on-premises?

A. No. The SkyDrive Pro for iOS v1.1 app does not yet support SharePoint on-premises. We are committed to providing on-premises customers access to their SkyDrive Pro in a future app release.

Q. What is SkyDrive Pro?

A. SkyDrive Pro is cloud storage for organizations and their employees. With SkyDrive Pro, you can upload, browse, and share files across all of your devices, including accessing your most recently used files. And you get all of the security and tools that SharePoint Online offers to help you be more productive at work. To learn more, watch this SkyDrive Pro video and read the “What is SkyDrive Pro?” article on Office.com.

Microsoft Power Query for Excel

Microsoft Power Query for Excel enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia.

With the Power BI Preview edition, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. For more information about how to share queries, see Share Queries.

http://www.microsoft.com/en-us/download/details.aspx?id=39933

With Power Query, you can

  • Find and connect data across a wide variety of sources.
  • Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as PowerPivot and PowerView.
  • Create custom views over data.
  • Use the JSON parser to create data visualizations over Big Data and Azure HDInsight.
  • Perform data cleansing operations.
  • Import data from multiple log files.
  • Perform Online Search for data from a large collection of public data sources including Wikipedia tables, a subset of Windows Azure Marketplace, and a subset of Data.gov.
  • Create a query from your Facebook likes that render an Excel chart.
  • Pull data into PowerPivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections.
  • With the Power BI Preview edition, you can share and manage queries as well as search data within your organization.

Power Query Data Sources

  • Web page
  • Excel or CSV file
  • XML file
  • Text file
  • Folder
  • SQL Server database
  • Windows Azure SQL Database
  • Access database
  • Oracle database
  • IBM DB2 database
  • MySQL database
  • SharePoint List
  • OData feed
  • Hadoop Distributed File System (HDFS
  • Windows Azure Marketplace
  • Active Directory
  • Facebook

Prerequisites:

  • Requires Microsoft Office Professional Plus 2013 or Office 365 ProPlus.
  • Supports 32-bit or 64-bit machines. If you are using the 32-bit version of Excel 2013, you must use the 32-bit version of the add-in. If you are using the 64-bit version of Excel 2013, you must use the 64-bit version of the add-in. The two versions are not interchangeable.
  • Requires Windows 8, Windows 7, or Windows Server 2008 R2 (requires Microsoft .NET Framework 4.0).
  1. Download and install Office 365 ProPlus.
  2. Make sure Excel is not running.
  3. Download and install Microsoft Power Query Preview for Excel.
    • Open the folder where you downloaded Microsoft Power Query Preview for Excel.
    • Double-click the downloaded installer file, and then follow the steps in the wizard.
    • After the installation is complete, click Finish.
    • Microsoft Power Query for Excel will appear as a new tab on the Excel ribbon.ImagePower BI for Office 365 from Atidan

Powermap Preview for Excel 2013 is released!

Power Map is a 3D data visualization tool for Excel that provides an immersive experience for making discoveries in data that might never be seen in traditional 2D tables and charts. Power Map lets you plot geographic and temporal data visually, analyze that data in 3D, and create cinematic tours to share with others.
http://www.microsoft.com/en-us/download/details.aspx?id=38395Image
With Power Map you can:

  • Map Data: Plot more than a million rows of data* in 3D visually on Bing maps and visualize the data with 3D columns, bubble/pie charts, heat maps, and regions.
  • Discover Insights: Discover new insights by seeing your data in geographic space and seeing time-stamped data change over time.
  • Share Stories: Capture screenshot “scenes” and build cinematic, guided interactive or video “tours” that can be shared broadly, engaging audiences like never before.
  • Image

Fuzzy Lookup Add In for Excel

Fuzzy Lookup Add-In for Excel

The Fuzzy Lookup Add-In for Excel was developed by Microsoft Research and performs fuzzy matching of textual data in Microsoft Excel. It can be used to identify fuzzy duplicate rows within a single table or to fuzzy join similar rows between two different tables. The matching is robust to a wide variety of errors including spelling mistakes, abbreviations, synonyms and added/missing data. For instance, it might detect that the rows “Mr. Andrew Hill”, “Hill, Andrew R.” and “Andy Hill” all refer to the same underlying entity, returning a similarity score along with each match. While the default configuration works well for a wide variety of textual data, such as product names or customer addresses, the matching may also be customized for specific domains or languages.

http://www.microsoft.com/en-us/download/details.aspx?id=15011