Formatting cells and ranges in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 videos | 42m 53s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
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 Course Contents pane or 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

  • 42s
    This video outlines the key content covered in the Microsoft 365: Formatting cells and ranges in Excel 365 course, including how to apply number formats, create an automatic data series, and how to change your cell style. FREE ACCESS
  • 3m 57s
    In Excel 365, you can apply a variety of number formats, such as dates, percentages, and fractions, to name a few. In this video, you will explore how to apply number formats. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.5 Apply number formats. FREE ACCESS
  • Locked
    3.  Inserting drop-down menus
    4m 45s
    Drop-down menus are useful if you want to limit the data values that can be inserted into a cell or speed up data entry. In this video, you will discover how to insert drop-down menus in Excel 365. FREE ACCESS
  • Locked
    4.  Using the Flash Fill feature
    3m 54s
    The Flash Fill feature in Excel 365 allows you to automatically and instantly complete data lists by recognizing patterns in your data. In this video, you will discover how to use the Flash Fill feature. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 2.1.1 Fill cells by using Flash Fill. FREE ACCESS
  • Locked
    5.  Creating automatic data series
    4m 43s
    If you have a numbered list that increases by increments or repeating categories such as dates or days of the week, you can create automatic data series. In this video, you will explore how to create automatic data series in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 2.1.2 Fill cells by using advanced Fill Series options. FREE ACCESS
  • Locked
    6.  Formatting your data's appearance
    4m 26s
    In Excel 365, you can improve the appearance of your data by adjusting the font, font effects, and size. In this video, you will discover how to format your data's appearance. FREE ACCESS
  • Locked
    7.  Changing your cell style
    3m 30s
    Cell styles can be used in Excel 365 to quickly change the color, alignment, and size of any data in a specified cell. In this video, you will discover how to change the cell style. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.7 Apply cell styles. FREE ACCESS
  • Locked
    8.  Transferring format styles
    4m 7s
    If you have formatted an existing table, and you want to reuse the style that you have created, you can transfer it to another data selection. In this video, you will explore how to transfer format styles in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.3 Format cells by using Format Painter. FREE ACCESS
  • Locked
    9.  Customizing number formats
    4m 34s
    Excel 365 features numerous number formats, but occasionally you need to create your own. In this video, you will explore how to customize number formats. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 2.2.1 Create custom number formats. FREE ACCESS
  • Locked
    10.  Applying custom cell formats
    4m 22s
    If you can't find your desired cell format in Excel 365, you can create your own. In this video, you will learn how to apply custom cell formats. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.6 Apply cell formats from the Format Cells dialog box. FREE ACCESS
  • Locked
    11.  Clearing cell formatting
    3m 53s
    If you've applied cell formatting that you want to remove, Excel 365 has a handy feature to use. In this video, you will discover how to clear cell formatting. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.2.8 Clear cell formatting. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 1324 users Rating 4.5 of 1324 users (1324)
Rating 4.5 of 310 users Rating 4.5 of 310 users (310)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 271 users Rating 4.5 of 271 users (271)
Rating 4.7 of 446 users Rating 4.7 of 446 users (446)
Rating 4.5 of 125 users Rating 4.5 of 125 users (125)