Formatting cells and ranges in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 Videos | 42m 53s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. 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: 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
    42s
    UP NEXT
  • Playable
    2. 
    Apply number formats
    3m 57s
  • Locked
    3. 
    Inserting drop-down menus
    4m 45s
  • Locked
    4. 
    Using the Flash Fill feature
    3m 54s
  • Locked
    5. 
    Creating automatic data series
    4m 43s
  • Locked
    6. 
    Formatting your data's appearance
    4m 26s
  • Locked
    7. 
    Changing your cell style
    3m 30s
  • Locked
    8. 
    Transferring format styles
    4m 7s
  • Locked
    9. 
    Customizing number formats
    4m 34s
  • Locked
    10. 
    Applying custom cell formats
    4m 22s
  • Locked
    11. 
    Clearing cell formatting
    3m 53s

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.