Customizing text & number formats in Excel 365

IN THIS COURSE

• 1.  Course Overview: Customizing text and number formats in Excel 365
  49s
  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. FREE ACCESS
• 2.  Separating data into multiple cells
  5m 2s
  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. FREE ACCESS
• 3.  Using formulas to modify text case
  3m 41s
  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. FREE ACCESS
• 4.  Combining data values into a single cell
  4m 8s
  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. FREE ACCESS
• 5.  Customizing text formats
  4m 41s
  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. FREE ACCESS
• 6.  Customizing the date and time format
  3m 45s
  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. FREE ACCESS
• 7.  Using color in custom formats
  3m 22s
  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. FREE ACCESS
• 8.  Creating random values
  4m 12s
  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. FREE ACCESS
• 9.  Ranking a value
  3m 55s
  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. FREE ACCESS
• 10.  Rounding a number
  4m 50s
  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. FREE ACCESS
• 11.  Using replacement formulas
  3m 19s
  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. FREE ACCESS