Customizing text & number formats in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 41m 43s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 1 Likes 1
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 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

  • Playable
    1. 
    Course Overview: Customizing text and number formats in Excel 365
    49s
    UP NEXT
  • Playable
    2. 
    Separating data into multiple cells
    5m 2s
  • Locked
    3. 
    Using formulas to modify text case
    3m 41s
    FREE ACCESS
  • Locked
    4. 
    Combining data values into a single cell
    4m 8s
    FREE ACCESS
  • Locked
    5. 
    Customizing text formats
    4m 41s
    FREE ACCESS
  • Locked
    6. 
    Customizing the date and time format
    3m 45s
    FREE ACCESS
  • Locked
    7. 
    Using color in custom formats
    3m 22s
    FREE ACCESS
  • Locked
    8. 
    Creating random values
    4m 12s
    FREE ACCESS
  • Locked
    9. 
    Ranking a value
    3m 55s
    FREE ACCESS
  • Locked
    10. 
    Rounding a number
    4m 50s
    FREE ACCESS
  • Locked
    11. 
    Using replacement formulas
    3m 19s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Applying custom formatting in Excel 365
COURSE Customizing charts in Excel 365
COURSE Creating advanced charts in Excel 365