Excel - More iPhone Excel - Episode 1745
1,038 views · Published 5 July 2013 · 8:12 · Indexed 12 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: How does the iPad Excel handle certain features? Welcome to the MrExcel podcast. In this episode, we will be discussing more about Excel on the iPhone. I'm Bill Jelen and today, on July 5th, we will be taking a closer look at the functionality of Excel on the iPhone. In our previous episode, I was quite negative about the app, but I was hoping to find some positive aspects to share with you today. So, let's dive in and see what we can discover. Firstly, I wanted to test how an Excel file created in Excel 2013 on a computer would look on the iPhone. I saved a file to the SkyDrive and opened it on the iPhone. To my surprise, all the data was there, but the slicer and table functionality were missing. However, the formatting that was applied on the computer did appear on the iPhone. I tested various formatting options, including theme colors, RGB colors, and cell styles, and they all came through correctly. This was a positive aspect, but unfortunately, there were some limitations as well. One of the limitations I found was that the iPhone does not support enough numeric formats. However, if you create them on the computer, they will appear correctly on the iPhone. I also tested some more complex formulas, such as one that calculates the number of Friday the 13th from a specific date, and I was impressed that the app was able to give me the correct answer. However, I was unable to edit the formula or format the cell on the iPhone. This led me to try a true array formula, which also did not allow me to edit or format the cell. It seems that while the app can display the correct results, it does not allow for any editing or formatting. Moving on to some of the features that were advertised to work on the iPhone, such as sorting, filtering, and outlining. I tested these features on a data set that I had created on the computer, and unfortunately, the results were not as expected. While the data was there, the icon set, conditional formatting, and sparkline did not appear on the iPhone. The sorting feature, however, did work smoothly and instantly, without the need to click OK. The filter feature, on the other hand, had some limitations, as it did not recognize the headings in the data set and applied the filter to the top row of the selection. The outlining feature was also disappointing, as it only showed a list of all the sheets and did not allow me to outline the data as I could with subtotals. Lastly, I want to address the issue of having to subscribe to Office 365 in order to use Excel on the iPhone, even if you already own Excel 2013 Pro Plus. This seems like an unnecessary expense for those who already have the product on their desktop PC. While there are some positive aspects to Excel on the iPhone, the limitations and the added cost may not make it worth it for some users. Thank you for tuning in to this episode of the MrExcel podcast, and we will see you next time for more insights on Excel on the iPhone. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Excel on the iPhone (00:10) More Features on the iPhone (00:20) Testing Real-Life Situations (00:30) Numeric Formats on the iPhone (00:40) Slicer and Table Functionality (00:50) Testing Cell Styles and Underlining (01:00) Center Cross Selection and Merge (01:12) Testing Formatting on the iPhone (01:23) Testing True Array Formulas (01:35) Sorting, Filtering, and Outline (01:45) Data Set and Slicer on the iPhone (01:55) Complaints About Numeric Formats (02:24) Array formula in iPhone (02:54) iPhone calcs correctly but can not edit array formula (03:36) MMULT function on iPhone can not be edited (04:01) Grouping data on iPhone Excel (04:48) Outline Data on iPhone (05:00) Sorting on iPhone (05:24) Filter on iPhone Excel (05:58) View Cell on iPhone (06:43) Total Filtered Data on iPhone Excel (07:19) Clicking Like really helps the algorithm #excel #microsoft #tutorial This video answers these common search terms: Autosum feature in Excel on the iPhone Excel 2013 Excel on the iPhone Formatting in Excel Formulas in Excel on the iPhone Numeric formats in Excel on the iPhone Outline feature in Excel on the iPhone Slicer in Excel 2013 Sorting and filtering in Excel on the iPhone Table functionality in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153567/ While most in the USA are enjoying a long holiday weekend, another podcast looking at how data created in desktop Excel 2013 will render on the iPhone Excel. Among other things, they get an A+ for sorting, but an F for summing filtered data.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920