Customizing text & number formats in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 1h 5m 9s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
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.

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
    59s
    UP NEXT
  • Playable
    2. 
    Separating data into multiple cells
    5m 51s
  • Locked
    3. 
    Using formulas to modify text case
    4m 23s
    FREE ACCESS
  • Locked
    4. 
    Combining data values into a single cell
    4m 59s
    FREE ACCESS
  • Locked
    5. 
    Customizing text formats
    5m 43s
    FREE ACCESS
  • Locked
    6. 
    Customizing the date and time format
    4m 24s
    FREE ACCESS
  • Locked
    7. 
    Using color in custom formats
    4m 3s
    FREE ACCESS
  • Locked
    8. 
    Creating random values
    5m 8s
    FREE ACCESS
  • Locked
    9. 
    Ranking a value
    4m 47s
    FREE ACCESS
  • Locked
    10. 
    Rounding a number
    5m 53s
    FREE ACCESS
  • Locked
    11. 
    Using replacement formulas
    3m 59s
    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 Printing spreadsheets in Excel 365
Likes 2 Likes 2  
COURSE Getting started with charts in Excel 365
Likes 9 Likes 9  
COURSE Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Likes 0 Likes 0