Formatting cells and ranges in Excel 365
Excel Microsoft 365 (2021)
| Beginner
- 11 videos | 42m 53s
- Includes Assessment
- Earns a Badge
- CPE
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
-
42sThis 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 57sIn 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
-
3. Inserting drop-down menus4m 45sDrop-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
-
4. Using the Flash Fill feature3m 54sThe 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
-
5. Creating automatic data series4m 43sIf 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
-
6. Formatting your data's appearance4m 26sIn 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
-
7. Changing your cell style3m 30sCell 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
-
8. Transferring format styles4m 7sIf 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
-
9. Customizing number formats4m 34sExcel 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
-
10. Applying custom cell formats4m 22sIf 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
-
11. Clearing cell formatting3m 53sIf 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.
