Inserting & Manipulating Data in Excel for iPhone

IN THIS COURSE

• 1.  Selecting cells in Excel for iPhone
  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
• 2.  Inputting data in Excel for iPhone
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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