Visualizing Data in Tables & Charts in Excel iPad

Excel iPad    |    Intermediate
  • 11 videos | 35m 36s
  • Earns a Badge
Likes 28 Likes 28
You can make your data in Excel for iPad easier to read and analyze using tables and charts. Learn how to create and modify tables and PivotTables, sort and filter data, and insert and format charts.


  • create quick tables in Excel for iPad
    resize columns and rows in Excel for iPad
    insert columns and rows in your table
    sort data in your table
    filter data in your tables
    format an existing PivotTable
  • sort and filter your PivotTable data
    insert charts in Excel for iPad
    format charts in Excel for iPad
    label charts in Excel for iPad
    present negative values in your charts


  • 3m 45s
    Your data ranges can be arranged into tables. Excel for iPad can very quickly create a table using a data range that you have selected. Once you have created a table, you can apply a filter and sort your data according to different criteria. FREE ACCESS
  • 3m 56s
    If you want to ensure that your data is readable and correctly displayed, then at some point early on you will need to know how to resize your columns and rows. These changes can be made manually. Excel for iPad can however also automatically resize your columns or rows so that every data value is correctly displayed. You can even resize multiple rows and columns simultaneously. And if you would rather not resize a cell, you can always adjust the wrap settings to adapt its contents instead. FREE ACCESS
  • Locked
    3.  Inserting columns & rows in a table in Excel iPad
    2m 59s
    If your table is missing some data, you can insert a new column or row. This is much easier than simply starting your table again. FREE ACCESS
  • Locked
    4.  Sorting the data in your table in Excel iPad
    2m 24s
    The sort options in Excel for iPad are a very good way of changing how your data values appear in your Excel workbook. You can sort your data in alphabetical or numerical order. FREE ACCESS
  • Locked
    5.  Filtering the data in your table in Excel iPad
    3m 22s
    The filters in your document are a great way of hiding or showing particular data values in your workbook on Excel for iPad. You can even combine these different filters to simplify your table. FREE ACCESS
  • Locked
    6.  Formatting an existing PivotTable in Excel iPad
    Excel for iPad does not allow you to create PivotTables in your workbook. You can, however, edit and format existing PivotTables that have been created in another app or program. It is important to know how to manage and format these columns to ensure the values they contain are clearly displayed. Learn to modify the style, color, font and size of your text. FREE ACCESS
  • Locked
    7.  Sorting & filtering your PivotTable data in Excel iPad
    3m 35s
    In Excel for iPad, you can use a PivotTable to analyze your data. This is particularly useful as it allows you to combine data from a variety of different sources. You can even use the sort and filter options to hide or show particular data values in your PivotTable. FREE ACCESS
  • Locked
    8.  Inserting a chart in Excel iPad
    2m 37s
    Charts can be used to analyze and present your data in a visually attractive manner. Excel for iPad comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
  • Locked
    9.  Formatting your chart in Excel iPad
    2m 4s
    Once you have inserted a chart into your Excel for iPad document, you can modify the formatting. You can, for example, change the color scheme, font size and text style. Learn how to customize your chart in this tutorial. FREE ACCESS
  • Locked
    10.  Labeling your chart in Excel iPad
    4m 20s
    Your Excel for iPad charts will often contain a large amount of information. You can make your charts easier to read by adding and adjusting different information elements, including the title and legend. FREE ACCESS
  • Locked
    11.  Presenting negative values in your chart in Excel iPad
    2m 36s
    If your chart contains negative values, your Excel for iPad chart will be automatically adjusted. You can use different chart styles to visualize your negative values in different ways. FREE ACCESS


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.