Formatting Data
Excel 2019 (Windows)
| Beginner
- 14 Videos | 49m 13s
- Includes Assessment
- Earns a Badge
- CPE
Refine your data's appearance with Excel 2019 for Windows. In this course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format and align their data. Next, observe how to use colors, which can help data stand out for the reader and make the table easier to read. Discover how to change the cell style; use document themes, and use formulas to modify the text case. Explore how to create clean, professional looking titles, and format titles to make them presentable. Create tables to ease organization; resize columns and rows; insert borders, and columns and rows. Conclude the course by observing how to transfer format styles. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Formatting Data Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
set your data type in your Excel 2019 spreadsheetformat your data in Excelalign your data in Exceluse colors in your Excel 2019 spreadsheetchange your cell style in your Excel 2019 spreadsheetuse document themes in your Excel 2019 spreadsheetuse formulas to modify your text case in your Excel 2019 spreadsheet
-
create a WordArt title in Excelformat a title in your Excel 2019 spreadsheetcreate a table in Excel 2019resize columns and rows in your Excel 2019 spreadsheetinsert columns and rows in your Excel 2019 spreadsheetinsert borders in Excel 2019transfer format styles in Excel 2019
IN THIS COURSE
-
1.Setting your data type4m 4sUP NEXT
-
2.Formatting your data4m 9s
-
3.Aligning your data4m 17s
-
4.Using colors3m 28s
-
5.Changing your cell style3m 55s
-
6.Using document themes3m 25s
-
7.Using formulas to modify your text case3m 20s
-
8.Creating a WordArt title2m 12s
-
9.Formatting a title3m 19s
-
10.Creating a table3m 46s
-
11.Resizing columns & rows3m 21s
-
12.Inserting columns & rows2m 35s
-
13.Inserting borders4m 6s
-
14.Transferring format styles3m 18s
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.