Formatting Data in Excel iPad

Excel iPad    |    Beginner
  • 10 videos | 34m 59s
  • Earns a Badge
Likes 10 Likes 10
To get the most out of your data, it must be accurate and easy to read. Discover data formatting techniques in Excel for iPad, including how to set a cell's format, align data, use colors and styles, and insert borders and hyperlinks.

WHAT YOU WILL LEARN

  • change a cell's data format in Excel for iPad
    format data in Excel for iPad
    align your data in Excel for iPad
    use color in Excel for iPad
    modify cell styles in Excel for iPad
  • transfer format styles in Excel for iPad
    modify your text case in Excel for iPad
    insert borders in Excel for iPad
    make your title stand out in Excel for iPad
    insert a hyperlink in Excel for iPad

IN THIS COURSE

  • Playable
    1.  Changing a cell's data format in Excel iPad
    4m 27s
    You can insert a large variety of data types in your Excel for iPad workbook. You can, for example, create dates, percentages, prices, and text values. You can ensure that these values are correctly displayed by using the… FREE ACCESS
  • Playable
    2.  Formatting your data in Excel iPad
    3m 23s
    In Excel for iPad, 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, and it's even possible to apply strikethrough or… FREE ACCESS
  • Locked
    3.  Aligning your data in Excel iPad
    3m 8s
    You can improve the appearance of your table by adjusting your cell's alignment settings. In Excel for iPad, you can not only adjust the horizontal alignment of your cells, but also the vertical alignment. It is even… FREE ACCESS
  • Locked
    4.  Using colors in Excel iPad
    3m 37s
    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 iPad, you can apply color to two main elements: your cell's contents, and its… FREE ACCESS
  • Locked
    5.  Modifying cell styles in Excel iPad
    2m 54s
    Cell styles determine the font and font size, number format, cell border, and cell shading. Choosing a cell style will allow you to quickly customize the cells in your Excel for iPad document. FREE ACCESS
  • Locked
    6.  Transferring format styles in Excel iPad
    3m 34s
    If you have formatted an existing table and you want to reuse the style that you have created, you can transfer it to another data selection. In Excel for iPad, you can use the copy and paste tools to quickly transfer… FREE ACCESS
  • Locked
    7.  Modifying your text case in Excel iPad
    3m 11s
    Excel for iPad features a certain number of formulas that can be used to convert your text characters. For example, if you have inserted a number of text values and you need to reformat them into capital letters, you can… FREE ACCESS
  • Locked
    8.  Inserting borders in Excel iPad
    4m 3s
    One good way of making your data values and ranges stand out in Excel for iPad is to use the different border tools. You can create borders around entire data ranges, around single cells, or along specified sides of your… FREE ACCESS
  • Locked
    9.  Making your title stand out in Excel iPad
    3m 43s
    You can use the Excel for iPad text styles to ensure that your title stands out from the rest of your document. When you use one of these preset formatting styles, you apply more than one change at a time. The easiest way… FREE ACCESS
  • Locked
    10.  Inserting a hyperlink in Excel iPad
    3m 1s
    Hyperlinks are clickable links that can be inserted into your workbook so that users can be quickly redirected to websites or start email drafts directed towards a specific recipient. Excel for iPad automatically… 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.