Customizing text & number formats in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 videos | 41m 43s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 310 users 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

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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 4.5 of 319 users Rating 4.5 of 319 users (319)
Rating 4.3 of 364 users Rating 4.3 of 364 users (364)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Rating 4.5 of 1324 users Rating 4.5 of 1324 users (1324)
Rating 4.5 of 1501 users Rating 4.5 of 1501 users (1501)