Formatting Data

Excel for the Web
  • 10 Videos | 36m 32s
  • Includes Assessment
  • Earns a Badge
Likes 3 Likes 3
Excel for the Web makes it easier to enhance the presentation of your worksheets. Discover how you can customize your font options, align data, and use colors. If you are working with large amounts of data, it will be useful to know how to resize rows and columns, as well as set borders. In this course you will also learn how to create table and customize them with the formatting style options to improve the presentation of your data.

WHAT YOU WILL LEARN

  • apply data formats to a data range
    use font format options in a spreadsheet
    insert, customize, and delete borders
    apply font and background colors
    use conditional formatting to highlight data
  • transfer format styles from a worksheet to another
    insert and delete columns or rows
    resize columns and rows in a spreadsheet
    convert a data range into a table and edits its contents
    change the appearance of a table with the formatting styles

IN THIS COURSE

  • Playable
    1. 
    Changing a cell's data format
    3m 46s
    UP NEXT
  • Playable
    2. 
    Formatting your data
    3m 19s
  • Locked
    3. 
    Inserting borders
    2m 37s
  • Locked
    4. 
    Using colors
    2m 58s
  • Locked
    5. 
    Using the conditional formatting tools
    3m 39s
  • Locked
    6. 
    Transferring format styles
    3m 22s
  • Locked
    7. 
    Inserting columns & rows
    2m 40s
  • Locked
    8. 
    Resizing columns & rows
    3m 20s
  • Locked
    9. 
    Creating a table
    2m 40s
  • Locked
    10. 
    Formatting a table
    3m 13s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.