Managing data in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Excel 365 provides a variety of methods for effectively handling data entries. In this course, explore options for navigating and selecting special items, finding and replacing data values, as well as grouping, sorting, and filtering data entries. First, discover how to navigate and locate specific items using basic search queries with the 'Go To' command. For selecting unique items, such as blank cells and visible data values, learn how to use the 'Go To Special' options. Next, explore the Find and Replace features to refine search and replacement queries, particularly when dealing with formulas. Sorting and filtering are key to managing data in Excel 365. Learn to categorize and display data by cell values or types, organize it with various sorting options, and apply multiple criteria for filtering. Furthermore, delve into using column filters to sift through information and implement multiple filters for values in a worksheet. Additionally, discover how to filter data to show unique values, eliminate duplicate entries in a data range, and reveal values that meet specific filter criteria. Finally, explore the options for grouping rows and columns in a worksheet by creating outlines or adding subtotals. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.