Formatting Data in Excel 2013 for Windows
Excel 2013 (Windows)
| Beginner
- 13 videos | 1h 14m 41s
- Earns a Badge
Excel 2013 provides numerous features that allow you to display data in a visually appealing way. Learn how to format and align data, use colors and themes, create titles and tables, resize and insert columns and rows, and add borders.
WHAT YOU WILL LEARN
-
Setting your data type
Formatting your data
Aligning your data
Using colors
Changing your cell style
Using document themes
Using formulas to modify your text case -
Creating a title
Creating a table
Resizing columns & rows
Inserting columns & rows in a table
Inserting borders
Transferring format styles
IN THIS COURSE
-
6m 44sYou can insert a large variety of data types in your Excel 2013 spreadsheet. You can, for example, create dates, percentages, fractions, prices, and text values. You can ensure that these values are correctly displayed by using the format tools. These tell Excel 2013 how to classify your data and how to adjust its appearance in your spreadsheet. FREE ACCESS
-
6m 7sIn Excel 2013, you can improve the appearance of your data and make it more readable by adjusting its formatting options. Excel 2013 features a huge library of fonts that can be applied to your text. You can also adjust the text size and apply different font effects, such as bold, italics and underline. FREE ACCESS
-
3. Aligning your data in Excel 2013 for Windows5m 44sYou can improve the appearance of your table by adjusting your cell's alignment settings. In Excel 2013, you can not only adjust the horizontal alignment of your cells, but also the vertical alignment. It is even possible to adjust the orientation of any text that you have inserted into your cell. FREE ACCESS
-
4. Using colors in Excel 2013 for Windows6m 34sColor 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 2013, you can apply color to two main elements: your cell's contents, and your cell's background. FREE ACCESS
-
5. Changing your cell style in Excel 2013 for Windows6m 23sCell styles can be used in Excel 2013 to quickly change the color, alignment, and size of any data in a specified cell. These styles can be used to control the appearance of multiple cells simultaneously. You can also create your own customized cell styles. FREE ACCESS
-
6. Using document themes in Excel 2013 for Windows4m 37sExcel 2013 themes can be used to change the overall appearance of your spreadsheet. You can also change the color sets in use, the fonts, and even some graphical effects. These tools can be used to quickly give your spreadsheet a completely new look. FREE ACCESS
-
7. Using formulas to modify your text case in Excel 2013 for Windows4m 49sExcel 2013 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 use the UPPER formula. You can also convert values into lower case, and even make data entries into proper nouns. FREE ACCESS
-
8. Creating a title in Excel 2013 for Windows5m 56sExcel 2013 features the WordArt tool which can be used to create attractive and professional-looking titles. This tool is extremely customizable: you can change your title's color, outline and rotation, and even apply special effects, such as shadows, glows and reflections. FREE ACCESS
-
9. Creating a table in Excel 2013 for Windows6m 50sYour data ranges can be arranged in tables. Excel 2013 can very quickly create a table using a data range that you have selected. Once you have created a table, you can apply a filter, sort your data according to different criteria, and change your cells' overall appearance. Excel 2013 can recognize when a table has been inserted, so you can easily access its related options and make any changes you deem necessary. FREE ACCESS
-
10. Resizing columns & rows in Excel 2013 for Windows5m 58sIf you want to ensure that your data is readable and correctly displayed, then at some point early on you will need to know how to resize your columns and rows. These changes can be made manually. Excel 2013 can however also automatically resize your columns or rows so that every data value is correctly displayed. You can even resize multiple rows and columns simultaneously. And if you would rather not resize a cell, you can always adjust the wrap settings to adapt its contents instead. FREE ACCESS
-
11. Inserting columns & rows in a table in Excel 2013 for Windows3m 20sIf your table is missing some data, you can insert a new column or row. This is much easier than simply starting your table again. In Excel 2013, you can also insert multiple columns and rows in a single action. FREE ACCESS
-
12. Inserting borders in Excel 2013 for Windows5m 45sOne good way of making your data values and ranges stand out in Excel 2013 is to use the different border tools. These border tools can be used to adjust the color, thickness and style of any outline effects that are applied to your cells. FREE ACCESS
-
13. Transferring format styles in Excel 2013 for Windows5m 55sIf 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 2013, you can use the copy and paste tools to quickly transfer your format styles. You can also use the dedicated format painter tool, which allows you to select a format and apply it to a new selection. 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.
