Inserting & Manipulating Data in Excel for iPhone

Excel for iPhone    |    Beginner
  • 12 videos | 58m 11s
  • Earns a Badge
Rating 5.0 of 5 users Rating 5.0 of 5 users (5)
A spreadsheet without data is of little use. Discover how to work with data and other Excel elements on your iPhone screen, including copying, moving and formatting data, undoing and redoing actions, and inserting functions.

WHAT YOU WILL LEARN

  • Select cells in excel for iphone
    Input data in excel for iphone spreadsheets
    Create automatic data series in excel for iphone
    Delete items in your excel for iphone spreadsheet
    Undo and redo your actions in excel for iphone
    Copy and paste data in excel for iphone
  • Change cell format in excel for iphone
    Format your data in excel for iphone
    Use colors in excel for iphone
    Use the find and replace function in excel for iphone
    Perform simple calculations in excel for iphone
    Use the function library in excel for iphone

IN THIS COURSE

  • 5m 15s
    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 iPhone, you can select individual cells and multiple cells. You can manually select text using your touchscreen. FREE ACCESS
  • 6m 6s
    The cells found in your Excel for iPhone 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.  Creating automatic data series in Excel for iPhone
    5m 5s
    You can quickly add data to your worksheet with Excel for iPhone'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 automatically fill out tables with existing formulas. FREE ACCESS
  • Locked
    4.  Deleting items in your spreadsheet in Excel for iPhone
    4m 41s
    If you need to remove data from your Excel for iPhone 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 iPhone. FREE ACCESS
  • Locked
    5.  Undoing & redoing actions in Excel for iPhone
    4m 13s
    If you have made a mistake in your worksheet, you might want to use the undo button. Excel for iPhone keeps a record of your recent actions and operations. See how to undo actions as well as restore your worksheet to its original state. FREE ACCESS
  • Locked
    6.  Copying & pasting data in Excel for iPhone
    5m 32s
    When you start copying and pasting data in Excel for iPhone, 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 formulae from your copied data range. FREE ACCESS
  • Locked
    7.  Changing the cell format in Excel for iPhone
    5m 19s
    You can insert a large variety of data types in your Excel for iPhone workbook. You can, for example, create dates, percentages, prices, and text values. You can ensure that these values are correctly displayed by using the format tools. These tell Excel for iPhone how to classify your data and how to adjust its appearance in your spreadsheet. FREE ACCESS
  • Locked
    8.  Formatting your data in Excel for iPhone
    4m 19s
    In Excel for iPhone, you can change how your text appears in your document by modifying the font style and size. You can also create italicized, bold or underlined text. Emphasis will make certain text elements in your document stand out. FREE ACCESS
  • Locked
    9.  Using colors in Excel for iPhone
    3m 43s
    Color can help to make your data stand out to your reader. It can also be used to make it easier to read your table. In Excel for iPhone, you can apply color to two main elements: your cell's contents, and its background. FREE ACCESS
  • Locked
    10.  Using the find & replace function in Excel for iPhone
    3m 58s
    To quickly locate data in your Excel for iPhone 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.  Performing simple calculations in Excel for iPhone
    5m 27s
    The cells in your Excel for iPhone worksheet can be thought of as little calculator spaces. You can use these individual cells to perform simple and complex calculations. Once you have inserted a calculation, any data updates that you make will, by default, be included in any dependent calculations. FREE ACCESS
  • Locked
    12.  Using the function library in Excel for iPhone
    4m 35s
    Excel for iPhone's Function Library can help you to locate and insert the formula you need. These formulae are grouped according to category. Once you have selected the formula you wish to use, Excel for iPhone can guide you through the arguments that you need to specify. 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 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)