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
    FREE ACCESS
  • Locked
    4. 
    Using the Flash Fill feature
    3m 54s
    FREE ACCESS
  • Locked
    5. 
    Creating automatic data series
    4m 43s
    FREE ACCESS
  • Locked
    6. 
    Formatting your data's appearance
    4m 26s
    FREE ACCESS
  • Locked
    7. 
    Changing your cell style
    3m 30s
    FREE ACCESS
  • Locked
    8. 
    Transferring format styles
    4m 7s
    FREE ACCESS
  • Locked
    9. 
    Customizing number formats
    4m 34s
    FREE ACCESS
  • Locked
    10. 
    Applying custom cell formats
    4m 22s
    FREE ACCESS
  • Locked
    11. 
    Clearing cell formatting
    3m 53s
    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 Formatting documents in Word 365
COURSE Getting started in Excel 365
Likes 1 Likes 1  
COURSE Creating advanced charts in Excel 365