Formatting Data in Excel 2010 for Windows
Excel 2010 (Windows)
| Beginner
- 14 videos | 50m 12s
- Earns a Badge
You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
WHAT YOU WILL LEARN
-
Setting your data typeFormatting dataAligning your dataCustomizing text colors & fill optionsChanging your cell styleUsing document themesUsing formulas to modify your text case
-
Creating a titleFormatting a titleCreating a tableResizing columns & rowsInserting columns & rowsInserting bordersTransferring styles
IN THIS COURSE
-
4m 35sYou can insert a large variety of data types in your Excel 2010 spreadsheet. You can, for example, create dates, percentages, fractions, prices, and text values. You can ensure that these values are correctly displayed by… FREE ACCESS
-
3m 57sIn Excel 2010, you can improve the appearance of your data and make it more readable by adjusting its formatting options. Excel 2010 features a huge library of fonts that can be applied to your text. You can also adjust… FREE ACCESS
-
3m 54sYou can improve the appearance of your table by adjusting your cell's alignment settings. In Excel 2010, you can not only adjust the horizontal alignment of your cells, but also the vertical alignment. It is even… FREE ACCESS
-
3m 47sColor 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 2010, you can apply color to two main elements: your cell's contents, and your cell's… FREE ACCESS
-
4m 57sCell styles can be used in Excel 2010 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… FREE ACCESS
-
2m 30sExcel 2010 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… FREE ACCESS
-
3m 18sExcel 2010 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… FREE ACCESS
-
3m 30sExcel 2010 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… FREE ACCESS
-
2m 46sOnce you've created a title, you can format it to make it presentable and easy to read. Change your title's color, outline and rotation, and even apply special effects, such as shadows, glows, and reflections. FREE ACCESS
-
3m 13sYour data ranges can be arranged in tables. Excel 2010 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… FREE ACCESS
-
2m 59sIf 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 2010 can however… FREE ACCESS
-
2m 58sIf 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 2010, you can also insert multiple columns and rows in a single action. FREE ACCESS
-
4m 23sOne good way of making your data values and ranges stand out in Excel 2010 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… FREE ACCESS
-
3m 23sIf 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 2010, you can use the copy and paste tools to quickly transfer your… 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

Course
Using macros in Excel 365