Something a little different today as Bill switches to the iPad for some Excel-lent entertainment and this is what he reports today in Episode #1874

“I am very impressed with Excel for the iPad. Today, a 20-minute deep dive into Excel for the iPad (Episode #1874to see which features are supported and which are not.

These items work natively on Excel for the iPad:

  • Create on the iPad
  • Enter data
  • Format data
  • All colors
  • Cell Styles
  • Shapes
  • Charts
  • Pictures
  • Merge Cells
  • Insert/Delete Cells/Rows/Sheets
  • Sort
  • Filter (but no Search box in Filter dropdown)
  • Formulas

These items, when created on the PC, will render correctly on the iPad

  • More Charts
  • Pivot tables
  • Sparklines
  • Conditional Formatting
  • Validation
  • Array Formulas
  • SmartArt
  • Array Formulas

These items… I am not sure. They are supposed to work, but I must be doing something wrong or they are buggy:

  • Hyperlinks to Navigate between sheets
  • Pivot Table Slicers

These items are Not Supported At All

  • VBA Macros
  • No Power Pivot (and no External connections)
  • Excel 2013 Slicers on regular Tables
  • Timeline Slicers