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
    FREE ACCESS
  • Locked
    4. 
    Using the Flash Fill feature
    4m 39s
    FREE ACCESS
  • Locked
    5. 
    Creating automatic data series
    5m 35s
    FREE ACCESS
  • Locked
    6. 
    Formatting your data's appearance
    5m 19s
    FREE ACCESS
  • Locked
    7. 
    Changing your cell style
    4m 5s
    FREE ACCESS
  • Locked
    8. 
    Transferring format styles
    4m 59s
    FREE ACCESS
  • Locked
    9. 
    Customizing number formats
    5m 23s
    FREE ACCESS
  • Locked
    10. 
    Applying custom cell formats
    5m 10s
    FREE ACCESS
  • Locked
    11. 
    Clearing cell formatting
    4m 36s
    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 Getting started in Excel 365
Likes 1 Likes 1  
COURSE Excel Visualization: Getting Started with Excel for Data Visualization
Likes 0 Likes 0  
COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13