Formatting Data in Excel for the Web
Excel for the Web
| Intermediate
- 10 videos | 31m 32s
- Includes Assessment
- Earns a Badge
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 46sIn 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 19sMake 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
-
3. Inserting borders in Excel for the Web2m 37sOne 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
-
4. Using colors in Excel for the Web2m 58sAdding 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
-
5. Using the conditional formatting tools in Excel for the Web3m 39sIn 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
-
6. Transferring format styles in Excel for the Web3m 22sIf 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
-
7. Inserting columns & rows in Excel for the Web2m 40sIn 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
-
8. Resizing columns & rows in Excel for the Web3m 20sIn 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
-
9. Creating a table in Excel for the Web2m 40sExcel 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
-
10. Formatting a table in Excel for the Web3m 13sThe 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.
