Managing data in Excel 365 (2024)

“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 with basic search queries using 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 replace queries particularly when dealing with formulas. Sorting and filtering are key for 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. 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 values 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).”