Excel 2013, Power Pivot and Power View on any device with Azure RemoteApp

I just found out about this great new Azure service that allows you to run any app on any device, including several default templates like Excel 2013 Pro plus. So my first thought was of course, cool lets try to run Excel on the IPad we have at home.

First what is Azure Azure RemoteApp, from the website:

Azure RemoteApp helps employees stay productive anywhere, and on a variety of devices – Windows, Mac OS X, iOS, or Android. Your company’s applications run on Windows Server in the Azure cloud, where they’re easier to scale and update. Users can access their applications remotely from their Internet-connected laptop, tablet, or phone. While appearing to run on the users’ local device, the applications are centralized on Azure’s protected, reliable platform.

Azure RemoteApp combines Windows application experiences with the powerful capabilities of Remote Desktop Services on Microsoft Azure – the cloud for modern business.

So I applied for the preview on Azure last week and got  access today, it now shows up in my Azure portal:

image

Clicking the link gives me the overview of my RemoteApp, of course I don’t have anything set up yet:

 

image

So I create a new RemoteApp where I select the default template image. This image support Office 2013 Pro Plus out of the box (how convenient Smile). Of course you can also create your own templates but I won’t go into those details.

image

After clicking Create it starts the creation process:

image

and after some time it finished creation and provisioning. Now I can start configuring the app:

image

When I chose remoteapp programs I will see what apps are installed by default:

image

Excel is part of it. In the users part I could add additional users. In my case I just added me.

Now to use it you need install an additional application, I am getting started with my windows machine where I downloaded the add through the RemoteApp website:

image

After it downloaded I need to set it up.  All I needed to do was log in with my Microsoft credentials. I now get a list of all my apps that I installed:

image

After selecting Excel it starts loading Excel (takes a bit longer the first time starting the app on your machine):

image

Now I have a version of Excel 2013 running on my machine without installing it (I signed into Office with my credentials as well):

image

The only difference you notice is a different icon in the task bar:

image

The version that is installed is Pro Plus:

image

And best news is that the Excel contains all the add-ins:

image

This means I can open any workbook that contains a model (this is the workbook used for my dashboarding book so it’s a not too shabby workbook):

image

Interestingly enough the memory on machine didn’t grow at all, so it is loading it on the server:

image

That also means you cannot open local documents and it is highly recommended to use things like OneDrive / Onedrive Pro or SharePoint

Now the cool thing is that it also supports running the same app on the IPad or any RT device. For IPad you just need to run the latest Remote desktop app. Here are some pictures running Excel on my daughters IPad, again opening the dashboard workbook:

WP_20140616_16_38_09_Pro

Clicking a slicer updates the numbers:

WP_20140616_16_38_17_Pro

Power View also works:

WP_20140616_16_37_59_Pro

Pretty cool right! It also works on OS X and Android, click here for more details.