Formatting cells and ranges in Excel 365

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.