Inserting & Manipulating Data in Excel iPad

IN THIS COURSE

• 1.  Selecting cells in Excel iPad
  3m 16s
  If you want to add data to a cell in your worksheet, the quickest way to do so is to select it. In Excel for iPad, you can select individual cells and multiple cells. You can manually select text using your touchscreen. FREE ACCESS
• 2.  Inputting data in Excel iPad
  3m 54s
  The cells found in your Excel for iPad spreadsheet can contain both numerical and textual data. There are a number of different ways of inserting, editing and deleting data into your spreadsheet. FREE ACCESS
• 3.  Deleting items in your spreadsheet in Excel iPad
  2m 46s
  If you need to remove data from your Excel for iPad workbook, you can use the delete tools. You can remove entire rows or columns and Excel will adjust your table to ensure that no spaces are left. It is also possible however to simply remove the contents of a cell. You will need to know how to use both methods if you want to get the most out of Excel for iPad. FREE ACCESS
• 4.  Undoing & redoing actions in Excel iPad
  3m 25s
  If you have made a mistake in your worksheet, you might want to use the undo button. Excel for iPad keeps a record of your recent actions and operations. If you want to cancel your previous actions and return your worksheet to a previous state, the undo history is the tool you need. FREE ACCESS
• 5.  Creating automatic data series in Excel iPad
  4m 11s
  You can quickly add data to your worksheet with Excel for iPad's data series tools. You can, for example, create a standard data series that goes up in increments of one. You can also create weekday lists, and insert complex data patterns. FREE ACCESS
• 6.  Referencing your cells in Excel iPad
  6m 28s
  If you want to use the contents of a particular cell or cell range, then you must know how to reference them. This involves inserting the coordinates of your cell in order to extract the value it contains. If you want to begin manipulating your data in Excel for iPad, you are going to need to know how to reference your cell correctly. FREE ACCESS
• 7.  Moving data within a workbook in Excel iPad
  3m 30s
  Sometimes you will need to know how to move data from one location to another. You can move data within individual sheets, from one worksheet to another, and even from one workbook to another. Excel for iPad features a number of different ways of transferring your data from one location to another. FREE ACCESS
• 8.  Moving data between apps in Excel iPad
  3m 46s
  With Excel for iPad, you can move data within individual sheets, from one worksheet to another, and even from one workbook to another. Sometimes, however, you will need to know how to move data from one application to another. The copy and paste tools are very useful for reusing data in other applications on your device. FREE ACCESS
• 9.  Copying & pasting data in Excel iPad
  4m 34s
  When you start copying and pasting data in Excel for iPad, you will find that you have a large number of options available to you. You can, for example, paste everything that you have copied to a new location. You can also paste any formatting that has been applied, paste values, and even remove any formulas from your copied data range. FREE ACCESS
• 10.  Using the find & replace function in Excel iPad
  4m 21s
  To quickly locate data in your Excel for iPad document, you'll use the Find function. There are a number of ways to narrow down your search so that you can quickly and easily find the information you're looking for. It's also easy to replace unwanted data with the desired information. FREE ACCESS
• 11.  Freezing & unlocking panes in Excel iPad
  3m 17s
  If you want to ensure you always have your headers of your Excel for iPad document in view at all times, you'll want to lock them. In this tutorial, you'll learn not only the best way to go about freezing the panes, but also how to modify their appearance. FREE ACCESS
• 12.  Adding an image in Excel iPad
  3m 46s
  You can illustrate your spreadsheet by adding images to your Excel for iPad worksheet. Add photos from the Photos application or images you've found on the web. You can even change the size or orientation of the image once it's added. FREE ACCESS
• 13.  Modifying an image in Excel iPad
  2m 46s
  If you're not happy with the way an image looks, you can cut out unwanted aspects of the image using the crop tool. After inserting the image into Excel for iPad, you'll select what you'd like to conserve and then cut out the rest. FREE ACCESS
• 14.  Adding an artistic effect to an image in Excel iPad
  3m 28s
  You can customize the images you insert into your Excel for iPad document using the artistic filters designed to modify your images. It's possible to add a shadow, reflection or pre-defined filter. FREE ACCESS