Formatting cells in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 10 videos | 34m 19s
- Includes Assessment
- Earns a Badge
- CPE
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
-
56sThis 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 11sFormatting 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
-
3. Formatting cells' appearance in Excel 3654m 38sIn 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
-
4. Merging and unmerging cells in Excel 3652m 34sIn 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
-
5. Aligning cells in Excel 3653mYou 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
-
6. Applying advanced formatting in Excel 3654m 57sIn 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
-
7. Changing the number format in Excel 3652m 55sIn 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
-
8. Applying cell styles in Excel 3653m 33sCell 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
-
9. Transferring formatting in Excel 3654m 24sIf 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
-
10. Clearing formats in Excel 3652m 11sIf 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.
