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
Install the Office application and a nice icon appears in your phone's menu
Connection to the cloud
Since 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.
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
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
- 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.