Formatting cells and ranges in Excel 365
Excel Microsoft 365 (2021)
| Beginner
- 11 Videos | 42m 53s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
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 courseapply number formats in Excel 365insert drop-down menus in Excel 365use the Flash Fill feature in Excel 365create automatic data series in Excel 365format data's appearance in Excel 365
-
change the cell style in Excel 365transfer format styles in Excel 365customize number formats in Excel 365apply custom cell formats in Excel 365clear cell formatting in Excel 365
IN THIS COURSE
-
1.Course Overview: Formatting cells and ranges in Excel 36542sUP NEXT
-
2.Apply number formats3m 57s
-
3.Inserting drop-down menus4m 45s
-
4.Using the Flash Fill feature3m 54s
-
5.Creating automatic data series4m 43s
-
6.Formatting your data's appearance4m 26s
-
7.Changing your cell style3m 30s
-
8.Transferring format styles4m 7s
-
9.Customizing number formats4m 34s
-
10.Applying custom cell formats4m 22s
-
11.Clearing cell formatting3m 53s
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.