Using the Internet, conduct a thorough search for more information on managing data with data tools in Excel. Choose one bullet from the following list. Tell us what you found regarding application of your selected topic in your chosen career field. Basically, how would you use this to increase your productivity or make some process effective?

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

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

Create and apply a slicer

Calculate summary statistics with SUBTOTAL function

Design and create an interactive dashboard