Formatting Data in Excel for the Web

Excel for the Web    |    Intermediate
  • 10 videos | 31m 32s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 40 users Rating 4.4 of 40 users (40)
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

  • 3m 46s
    In Excel for the Web, you can enter a variety of data types into your workbook including dates, percentages, monetary and text values. By assigning a cell format to your data, you can ensure that the values in your spreadsheet display properly. FREE ACCESS
  • 3m 19s
    Make your spreadsheet clearer and easier to read by formatting your data. In Excel for the Web, you can choose from a number of different fonts and distinguish table headers using font effects like bold, italics, and underline. You can also increase the size of your font to make it easier to read your data. FREE ACCESS
  • Locked
    3.  Inserting borders in Excel for the Web
    2m 37s
    One good way of making your data values and ranges stand out in Excel for the Web is to use the border tools. You can create borders around entire data ranges, around single cells, or along certain sides of your selection. FREE ACCESS
  • Locked
    4.  Using colors in Excel for the Web
    2m 58s
    Adding color to your spreadsheets can help make specific data elements stand out and can also make your table generally easier to read. In Excel for the Web, you can apply color to two main elements--your cell's contents and its background. In this video, you'll see how to do both in order to create more presentable data. FREE ACCESS
  • Locked
    5.  Using the conditional formatting tools in Excel for the Web
    3m 39s
    In Excel for the Web, you can use the conditional formatting tools to apply the rules to your different data. For example, you can make any value within certain data range stand out by applying a color effect. In this video, you will also see how to clear any conditional formatting tools you have applied to your data. FREE ACCESS
  • Locked
    6.  Transferring format styles in Excel for the Web
    3m 22s
    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 the Web, you can use the copy and paste tools to quickly transfer your format styles, as well as the Format Painter tool. FREE ACCESS
  • Locked
    7.  Inserting columns & rows in Excel for the Web
    2m 40s
    In Excel for the Web, if you need to add data to your worksheet, you can insert a new column or row of cells anywhere that you'd like. You can even insert multiple columns and rows in a single action to save time. FREE ACCESS
  • Locked
    8.  Resizing columns & rows in Excel for the Web
    3m 20s
    In Excel for the Web, you can ensure that your data is readable and correctly displayed by adjusting the size of specific rows and columns. You can also apply the wrap text tool, which automatically adapts the size of data cells to their content--so that your data will never be unintentionally masked. FREE ACCESS
  • Locked
    9.  Creating a table in Excel for the Web
    2m 40s
    Excel for the Web allows you to create blank tables where you can insert your different data. Or to select data ranges that you have already created and format them as a table. FREE ACCESS
  • Locked
    10.  Formatting a table in Excel for the Web
    3m 13s
    The formatting tools and table styles can be used to quickly change the appearance of your table in Excel for the Web. You have a wide range of standard table styles at your disposal, as well as options to activate or deactivate filter buttons or total rows. In this video you will also learn how to convert a table to a data range. 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

Journey Microsoft Excel
Rating 3.6 of 10 users Rating 3.6 of 10 users (10)
Course Complete Guide to Excel 365: Using Formatting, Styles, & Themes
Rating 4.7 of 446 users Rating 4.7 of 446 users (446)
Course Formatting cells and ranges in Excel 365
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Leveraging the Power of Performance Management
Rating 4.7 of 164 users Rating 4.7 of 164 users (164)
Course Illustrating Documents in Excel 2019 for Windows
Rating 4.5 of 233 users Rating 4.5 of 233 users (233)
Course Configuring the Outlook Client in Outlook 365
Rating 4.3 of 191 users Rating 4.3 of 191 users (191)