Excel on your mobile for free

Using Excel from a mobile seems to be a bit of a joke, but after using it, it is easy to get caught in the game. Of course, we will never create great worksheets as we can do with Excel desktop, but to open its files from any location (street, subway, bus) is very interesting. This article present how to get and use Excel on your mobile.

Since Thursday, November 6, 2014, you can download Microsoft Office on your mobile phone for free. Access to Office from multi-platform is the scope of the new strategy of Microsoft. This is why you can work with Excel, Word, Access from your computers, tablets, laptops and mobiles.

 

 

Download Office Application

Office_App_7Office_App_8From your phone, search for the Office application

Install the Office application and a nice icon appears in your phone's menu :)

 

 

 

 

 

 

 

 

Connection to the cloud

Office_App_4Office_App_15Office_App_14Since Excel 2013 , the connectivity has become the standard work in Office. We have presented how to work with Excel for free from a browser with Office Web App in OneDrive. But beyond the fact to work with Excel in a Web browser, the most important is to save your documents in the cloud. Like this, you can easily load your documents (Excel, Word, Power Point, Access) on any device.

You can connect from different sources. For instance here, I am connected to my personal account in OneDrive and also to my professional Office 365 account. Then, I can easily navigate through the files (Excel, Word and Power Point) of each account.

 

 

The Excel Interface

Of course, it is useless to expect to do the same tasks between Excel desktop and Excel on a mobile phone. The version of Excel on a laptop has more features than in Excel Mobile. However, the most useful features of Excel are available on Office Application on a phone.

Navigation

On a phone, moving into a spreadsheet is simply by sliding your finger on the screen. Similarly, to zoom in or zoom out, simply apply two fingers on the screen as you move closer or further away. This is exactly the same principle as a photo or a map.

In addition, you can view your spreadsheet horizontally or vertically

Office_App_11

Horizontal view

Office_App_10

Vertical view

 

 

Office_App_12To navigate between worksheets in your workbook, you must click on the following icon to display the list of sheets in your workbook.

 

Icone_Feuille

 

 

 


Function

125 functions are present in the mobile version of Excel and they cover all the most used functions in Excel. These function are

  • Financial: DDB, FV, IRR, NPER, NPV, PMT, PV, RATE, SLN, SYD
  • Date and time: DATE , DATEVALUE, DAY , HOUR , MINUTE , MONTH , NOW , SECOND , TIME , TIMEVALUE, TODAY , WEEKDAY , YEAR
  • Math and Trigonometry: ABS, ACOS, ASIN, ATAN, ATAN2, COS, DEGREES, EXP, FACT, INT, LN, LOG, LOG10, MOD , PI, POWER, PRODUCT, RADIANS, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SIN, SQRT, SUBTOTAL, SUM , SUMIF , SUMIFS , SUMPRODUCT, TAN, TRUNC
  • Statistics: AVERAGE , COUNT, COUNTA, COUNTBLANK, COUNTIF , COUNTIFS , MAX, MEDIAN , MIN, RANK, STDEV , STDEVP , VAR , VARP
  • Search: CHOOSE, COLUMN, COLUMNS, HLOOKUP, INDEX , LOOKUP, MATCH , ROW, ROWS, VLOOKUP
  • Database: DAVERAGE, DCOUNT, Dcounta, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
  • Text: CONCATENATE, EXACT, FIND, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SUBSTITUTE, T, TRIM, UPPER, VALUE
  • Logic: AND , FALSE, IF , NOT, OR , TRUE
  • Information: ERROR.TYPE, IFERROR, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISTEXT, N, NA

Editing a cell

Office_App_16To edit a cell, you have 2 options

  • press the icon function
  • double-contact with your finger in a cell

These two actions will you bring up the keyboard to enter your data using the virtual keyboard.

 

 

 

 

 

 

 

Related posts


Permanent link to this article: https://www.excel-exercise.com/excel-on-your-mobile-for-free/


Leave a Reply

Your email address will not be published.