Customizing text & number formats in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 11 Videos | 41m 43s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
To configure how your data displays, you can use the various built-in formatting options in Excel 365, or create your own. In this course, you will learn how to use formulas to separate data entries into various cells as well as to modify the case of your text. In addition, you will find out how to create custom formats for text and date or time values - including how to create custom color formatting for data entries. You will explore how to create randomized values, rank values; and round numbers up or down. Finally, you will explore how to use formulas to make substitutions or replacements for values.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this Microsoft 365: Customizing text and number formats in Excel 365 courseseparate data into multiple cells in Excel 365use formulas to modify text case in Excel 365combine data values into a single cell in Excel 365customize text formats in Excel 365customize the date and time format in Excel 365
-
use color in custom formats in Excel 365create random values in Excel 365rank a value in Excel 365round a number in Excel 365use replacement formulas in Excel 365
IN THIS COURSE
-
1.Course Overview: Customizing text and number formats in Excel 36549sUP NEXT
-
2.Separating data into multiple cells5m 2s
-
3.Using formulas to modify text case3m 41s
-
4.Combining data values into a single cell4m 8s
-
5.Customizing text formats4m 41s
-
6.Customizing the date and time format3m 45s
-
7.Using color in custom formats3m 22s
-
8.Creating random values4m 12s
-
9.Ranking a value3m 55s
-
10.Rounding a number4m 50s
-
11.Using replacement formulas3m 19s
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.