Formatting cells in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 10 videos | 34m 19s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 3.2 of 6 users Rating 3.2 of 6 users (6)
Excel 365 offers a wide range of formatting options to enhance the presentation of your worksheet data. This video explores essential formatting tools in Excel. First, you will see how to change the appearance of cells. See how to add style to your worksheets by formatting text, borders, and cell backgrounds. Next, you will learn how to change the way data is arranged in your spreadsheet. Find out how to merge cells together and modify the vertical and horizontal alignment of text. See also how to wrap text and change text orientation. In addition, the course explores a number of other tools for formatting cells and worksheets. Discover how to use the Format Cells dialog box and change your cells' number format. Learn how to apply consistent formatting with Cell Styles, Format Painter, and by grouping worksheets. Finally, see how to clear formatting from selected cells. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in formatting cells in excel 365 course
    Modify font type, size, style, and color
    Format cell borders and background
    Merge and unmerge cells
    Modify cell alignment, orientation, and wrapping
  • Format alignment, font, border, and fill via the format cells dialog box
    Apply different number formats to cells
    Use built-in and custom cell styles
    Transfer formatting using format painter, autofill, and grouping worksheets
    Clear cell formats

IN THIS COURSE

  • 56s
    This video outlines the key content covered in the Formatting cells in Excel 365 course, including merging and unmerging cells, changing the number format, and transferring formatting in Excel 365. FREE ACCESS
  • 5m 11s
    Formatting your worksheet's text can help your data stand out. In this tutorial, you will see how to change the font formatting of your data, including font type, size, style, and color. Find out more in this tutorial. FREE ACCESS
  • Locked
    3.  Formatting cells' appearance in Excel 365
    4m 38s
    In Excel, you can change your cells' appearance by adding borders and background colors. In this tutorial, you will see how to change the border style and fill of selected cells. FREE ACCESS
  • Locked
    4.  Merging and unmerging cells in Excel 365
    2m 34s
    In Excel, you can merge several cells into a single cell. This can be useful if you want to create headers or labels across several rows or columns. After cells have been merged, you can easily unmerge them. In this tutorial, you will learn how to merge and unmerge cells. This video aligns with MO-210 Microsoft Excel Exam objective: Merge and unmerge cells. FREE ACCESS
  • Locked
    5.  Aligning cells in Excel 365
    3m
    You can improve your worksheet's appearance by changing the alignment of your cells' contents. In this video, you will discover how to change the horizontal and vertical alignment, wrap text, and adjust text orientation. This video aligns with MO-210 Microsoft Excel Exam objectives: Modify cell alignment, orientation, and indentation; and Wrap text within cells. FREE ACCESS
  • Locked
    6.  Applying advanced formatting in Excel 365
    4m 57s
    In addition to the Office Ribbon, you can find formatting options in the Format Cells dialog box. There, you will find more advanced options for formatting the alignment, font, border, and fill of your cells. See how in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Apply cell formats from the Format Cells dialog box. FREE ACCESS
  • Locked
    7.  Changing the number format in Excel 365
    2m 55s
    In Excel, you can apply different number formats depending on the type of data you are working with. For example, numbers can be formatted as currency values, times, percentages, and more. You can also modify formatting aspects such as decimal places and comma style. Watch the video to learn about number formatting in Excel 365. This video aligns with MO-210 Microsoft Excel Exam objective: Apply number formats. FREE ACCESS
  • Locked
    8.  Applying cell styles in Excel 365
    3m 33s
    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 MO-210 Microsoft Excel Exam objective: Apply cell styles. FREE ACCESS
  • Locked
    9.  Transferring formatting in Excel 365
    4m 24s
    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, as well as how to format a group of worksheets simultaneously. This video aligns with MO-210 Microsoft Excel Exam objectives: Format cells by using Format Painter, and Format multiple worksheets by grouping. FREE ACCESS
  • Locked
    10.  Clearing formats in Excel 365
    2m 11s
    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 MO-210 Microsoft Excel Exam objective: 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 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 125 users Rating 4.5 of 125 users (125)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Rating 4.7 of 241 users Rating 4.7 of 241 users (241)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)