Inserting & Manipulating Data in Excel iPad

Excel iPad    |    Beginner
  • 14 videos | 53m 28s
  • Earns a Badge
Rating 4.5 of 6 users Rating 4.5 of 6 users (6)
A spreadsheet without data is of little use. Discover how to work with data and other elements in Excel for iPad, including copying or moving data, undoing and redoing actions, freezing panes, and adding and modifying images.

WHAT YOU WILL LEARN

  • Select cells in excel for ipad
    Input data in excel for ipad
    Delete items in your spreadsheet in excel for ipad
    Undo and redo actions in excel for ipad
    Create automatic data series in excel for ipad
    Reference your cells in excel for ipad
    Move data within a workbook in excel for ipad
  • Move data between apps in excel for ipad
    Copy and paste data in excel for ipad
    Use the find and replace function in excel for ipad
    Freeze and unlock panes in excel for ipad
    Add images to spreadsheets in excel for ipad
    Modify images in excel for ipad
    Add artistic effects to images in excel for ipad

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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.

YOU MIGHT ALSO LIKE

Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)