Managing data in Excel 365 (2024)
Excel 365 (2024)
| Intermediate
- 12 videos | 52m 57s
- Includes Assessment
- Earns a Badge
- CPE
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). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this managing data in excel 365 (2024) course
Use the go to and find and replace commands to search for data
Find and replace values, formats, and formulas
Sort data in a worksheet
Perform an advanced sort by creating and using custom sort lists
Use column filters and apply multiple filters to worksheet data -
Apply filter arguments to text, numeric and date values
Filter data using advanced options
Hide and remove duplicate values from a range
Group items to manage how to display data in a worksheet
Create outlines to group content
Add and remove subtotals
IN THIS COURSE
-
1m 2sThis video outlines the key content covered in this Managing data in Excel 365 (2024) course, including how to find and replace values or functions, sort and filter data, and group items to create outlines and insert subtotals. FREE ACCESS
-
5m 7sExcel 365 boasts efficient tools like Go To and Find and Replace to simplify data searches. In this video, learn how to effectively search within a worksheet. This video aligns with the MO-210 Microsoft Excel Exam objectives: Search for data within a workbook and Navigate to named cells, ranges, or workbook elements. FREE ACCESS
-
3. Finding and replacing items in Excel 3655m 49sIncorrect data values in Excel 365 can be swiftly substituted, with the flexibility to replace entries either individually or in bulk. Search queries may be customized to locate specific values or formulas, which can then be efficiently updated using advanced options. In this video, explore how to use the Find and Replace tool in Excel 365. FREE ACCESS
-
4. Sorting data in Excel 3654m 43sExcel 365 features sort options to organize data within a table. Learn how to specify criteria such as alphabetical order or from smallest to largest value to arrange a data range. Excel 365 enables the creation of multiple sort levels to alter data presentation. Discover how to group data within a cell range and reorganize these levels for tailored sorting. In this video, explore how to sort data in Excel 365. This video aligns with the MO-210 Microsoft Excel Exam objectives: Sort data by multiple columns. FREE ACCESS
-
5. Performing advanced sorting in Excel 3655m 1sCustom sort lists in Excel 365 facilitate non-alphabetical sorting for data such as days of the week, months, or text-based rankings like priority levels. Advanced options also include header management, sort orientation adjustment, and case-sensitive sorting. In this video, explore how to perform advanced sorting in Excel 365. FREE ACCESS
-
6. Filtering data in Excel 3654m 19sExcel 365's filtering options enable users to display data selectively by setting criteria to include or exclude categories. Quickly adjust visible data with column filters, and refine datasets by applying multiple filters to columns. This video aligns with the MO-210 Microsoft Excel Exam objectives: Filter records. FREE ACCESS
-
7. Customizing filter arguments in Excel 3654m 43sExcel 365 allows the use of filter arguments to query cell ranges and display values meeting specific criteria such as 'equals,' 'contains,' and 'between.' Multiple arguments can be combined using "AND" or "OR". Additionally, entries with colored fills can be sorted by color to isolate specific values, such as those highlighted in red. In this video, learn how to create filters with text, numeric, and color arguments. FREE ACCESS
-
8. Performing advanced filtering in Excel 3654m 13sExcel 365 allows for advanced filter criteria using an auxiliary table. Set the filter, choose the data range, and criteria cells to start the process. These cells can be merged for robust filtering operations. In this video, discover advanced tools to filter data. FREE ACCESS
-
9. Hiding and removing duplicate values in Excel 3654m 11sExcel 365's filter feature can hide duplicates temporarily, while its Remove Duplicates command permanently deletes them from a data table or range. In this video, discover how to hide and remove duplicate values within a data table or cell range. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Remove duplicate records. FREE ACCESS
-
10. Grouping items in Excel 3655m 16sGrouping rows and columns in Excel 365 is a great way to summarize data and add structure to data tables. In this video, discover how to group and ungroup items, create subgroups, and hide and expand groups in a worksheet. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Group and ungroup data FREE ACCESS
-
11. Creating outlines to group content in Excel 3654m 26sAuto Outline in Excel 365 facilitates data analysis by enabling the grouping of content. The appearance of the outline is also customizable to fit user preferences. In this video, explore how to create outlines to group content in Excel 365. FREE ACCESS
-
12. Adding subtotals to data tables in Excel 3654m 6sIn Excel, subtotals automatically summarize complex data by showing sums or averages, clarifying aggregates. Grouping by subtotals segments the data for easier analysis. In this video, learn how to use subtotal to analyze your data. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Calculate data by inserting subtotals and totals 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.
