Customizing text & number formats in Excel 365
Excel
| Intermediate
- 11 videos | 41m 43s
- Includes Assessment
- Earns a Badge
- CPE
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
-
49sThis 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. FREE ACCESS
-
5m 2sIf 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. FREE ACCESS
-
3. Using formulas to modify text case3m 41sExcel 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. FREE ACCESS
-
4. Combining data values into a single cell4m 8sIn 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. FREE ACCESS
-
5. Customizing text formats4m 41sIf 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. FREE ACCESS
-
6. Customizing the date and time format3m 45sDepending 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. FREE ACCESS
-
7. Using color in custom formats3m 22sIf 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. FREE ACCESS
-
8. Creating random values4m 12sIf 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. FREE ACCESS
-
9. Ranking a value3m 55sIf 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. FREE ACCESS
-
10. Rounding a number4m 50sWhen 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. FREE ACCESS
-
11. Using replacement formulas3m 19sIf 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. 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.
