September 26, 2014 9:12 am

Office 365: Excel on your Lumia

With 1 terabyte of OneDrive storage and the latest version of Office across your devices, Office 365 is the perfect solution for getting things done with as little effort as possible.

And little effort is precisely what you need when using Office productivity apps on the go via your Lumia and the Office Mobile app, which comes pre-installed.

Excel-on-the-go

Excel is a staple of any workforce. It auto-calculates complex sums, helps you gain new insights by viewing patterns in raw number form or by using graphs, and much more. All you need to do is to input the data.

On your Lumia, you can create new Excel spreadsheets using a blank template. Alternatively, the pre-installed Budget, Event schedule, or Mileage tracker Excel templates may be the better option depending on what you need.

However, if you just need to review or edit any of your previous Excel worksheets–providing you’re signed in using your Office 365 or Microsoft account–you’ll find them in the “recent” or “places” tab of the Office app.

Adding or editing text or numbers is straightforward. Tap on a cell, then cast your eye towards the top of the screen where you’ll see the formula bar and Function icon.

For just words or numbers, select the formula bar and the on-screen keyboard will pop up, ready for you to type away.

Excel

If you’re a wizard with Functions, hit the ‘Fx’ key to find the one you need, such as COUNT, COUNTIF, SUM, VARP, and plenty more.

For a better-looking spread sheet, try turning that data into a graph. Options available are Column, Line, Pie, Bar, Area, and XY (scatter).

Saving and sharing your Excel spreadsheet couldn’t be simpler.

Press the back icon on your Lumia to exit the program and it’ll ask if you want to save the document, overwriting the previous version saved.

Within the Share option, you can send the file via Bluetooth, email, OneDrive, OneNote or Tap to share (NFC).

With Office 365 and OneDrive synchronization, anything you create on your PC or tablet is saved to the Cloud. That means you always have access to the latest version of your document, as long as you’re connected to the Internet.

Are you using Excel with Office 365? Let us know how you’re using it, below.