# Customizing text & number formats in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
• 11 videos | 41m 43s
• Includes Assessment
• CPE
Rating 4.5 of 310 users (310)
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

## WHAT YOU WILL LEARN

• Discover the key concepts covered in this microsoft 365: customizing text and number formats in excel 365 course
Separate data into multiple cells in excel 365
Use formulas to modify text case in excel 365
Combine data values into a single cell in excel 365
Customize text formats in excel 365
Customize the date and time format in excel 365
• Use color in custom formats in excel 365
Create random values in excel 365
Rank a value in excel 365
Round a number in excel 365
Use replacement formulas in excel 365

## IN THIS COURSE

• This video outlines the key content covered in the Microsoft 365: Customizing text and number formats in Excel 365 course, including how to customize text formats, using color in custom formats, and how to round a number in Excel 365.
• If you have a large amount of data inserted into your cells, you can use Excel 365 functions to split your entries and extract the individual components. In this video, you will discover how to separate data into multiple cells in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objectives: 4.3.1 Format text by using RIGHT(), LEFT(), and MID() functions and 4.3.2 Format text by using UPPER(), LOWER(), and LEN() functions.
• 3.  Using formulas to modify text case
Excel 365 contains numerous functions that convert text characters. In this video, you will discover how to use formulas to modify text case in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.3.2 Format text by using UPPER(), LOWER(), and LEN() functions.
• 4.  Combining data values into a single cell
In Excel 365, you can combine data taken from multiple cells using the CONCAT and TEXTJOIN functions. In this video, you will explore how to combine data values into a single cell in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.3.3 Format text by using the CONCAT() and TEXTJOIN() functions.
• 5.  Customizing text formats
If data values in an Excel 365 spreadsheet don't display clearly, such as long numbers exceeding 15 digits or bulky text entries, this can be resolved using custom number formats. The number format you choose can be modified according to your specific preferences and you can re-use it again later. In this video, you will explore how to customize text formats in Excel 365.
• 6.  Customizing the date and time format
Depending on which country or region you're presenting data in, not everyone uses the same time and date format. Excel 365 offers a variety of different date and time formats, but you can also create your own. In this video, you will explore how to customize the date and time format in Excel 365.
• 7.  Using color in custom formats
If you'd like certain data values in your Excel 365 workbooks to be outlined in a specific format or color automatically, now you can do this and more. Using the Number Format tool, you can change the formatting, font, and fill color of your data in Excel 365. In this video, you will discover how to use color in custom formats in Excel 365.
• 8.  Creating random values
If you need randomly generated codes, are holding a lottery, or drawing lots, Excel 365 has functions you can use. In this video, you will explore how to create random values in Excel 365.
• 9.  Ranking a value
If you want to find out where a particular value places in a list of data entries, Excel 365 has functions you can use. In this video, you will explore how to rank a value in Excel 365.
• 10.  Rounding a number
When presenting numeric values in a spreadsheet, you ideally want all the numbers to be rounded to the same number of digits for consistency and accuracy. In Excel 365, there are many different functions that you can use to round your data values up or down. In this video, you will discover how to round a number in Excel 365.
• 11.  Using replacement formulas
If you need to correct errors in your data, you can use an Excel 365 function to do it for you. If want to make changes to text data in your worksheet, you can make modifications with replacement and substitution functions. In this video, you will explore how to use replacement formulas in Excel 365.

## 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

Rating 5.0 of 1 users (1)
Rating 4.5 of 380 users (380)
Rating 3.0 of 2 users (2)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 2242 users (2242)
Rating 4.4 of 282 users (282)
Rating 4.4 of 6009 users (6009)