Visualizing Data in Tables & Charts in Excel iPad

IN THIS COURSE

• 1.  Creating a quick table in Excel iPad
  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
• 2.  Resizing columns & rows in Excel iPad
  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
• 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
• 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
• 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
• 6.  Formatting an existing PivotTable in Excel iPad
  4m
  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
• 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
• 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
• 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
• 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
• 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