Using the Internet, conduct a thorough search for more information on managing data with data tools in Excel. Choose one topic (explain and also include a use) from the following:
Session 6.1
Split a workbook window into panes
Highlight and remove duplicate values in a data range
Sort a data range by one or more fields
Add subtotals to a data range
Session 6.2
Find and select workbook cells
Filter data based on one or more fields
Create an advanced filter
Convert a data range to an Excel table
Work with table styles and table elements