Week 6 Discussion Board Managing Data with Data Tools Using the Internet, conduct a thorough search for more information on the following in Excel. Choose one bullet listed below and explain why you chose the site and how it helped you.

Choose from the following topics:

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

Session 6.3

• Create and apply a slicer
• Calculate summary statistics with SUBTOTAL function
• Design and create an interactive dashboard