Formatting cells and ranges in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 Videos | 1h 5m 47s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 5 Likes 5
Excel 365 contains several features to aid in data formatting and manipulation. In this course, you will explore various ways to format your data by type, which serves as a way of classifying the data. Learn how to create drop-down menus, fill cells using the Flash Fill feature, and how to create an automatic data series. Next, you will discover how to create an automatic data series using the advanced Fill Series options and how to format data, including options to configure its size or apply font effects such as bold, italic, and underline. Then you'll also see how to apply cell styles; how to format cells with the Format Painter tool; how to create customized number formats; how to apply custom cell formats; and how to clear all formatting from cells.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Formatting cells and ranges in Excel 365 course
    apply number formats in Excel 365
    insert drop-down menus in Excel 365
    use the Flash Fill feature in Excel 365
    create automatic data series in Excel 365
    format data's appearance in Excel 365
  • change the cell style in Excel 365
    transfer format styles in Excel 365
    customize number formats in Excel 365
    apply custom cell formats in Excel 365
    clear cell formatting in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Formatting cells and ranges in Excel 365
    49s
    UP NEXT
  • Playable
    2. 
    Apply number formats
    4m 38s
  • Locked
    3. 
    Inserting drop-down menus
    5m 37s
  • Locked
    4. 
    Using the Flash Fill feature
    4m 39s
  • Locked
    5. 
    Creating automatic data series
    5m 35s
  • Locked
    6. 
    Formatting your data's appearance
    5m 19s
  • Locked
    7. 
    Changing your cell style
    4m 5s
  • Locked
    8. 
    Transferring format styles
    4m 59s
  • Locked
    9. 
    Customizing number formats
    5m 23s
  • Locked
    10. 
    Applying custom cell formats
    5m 10s
  • Locked
    11. 
    Clearing cell formatting
    4m 36s

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