Using the Internet, conduct a thorough search for more information on the following in Excel.Choose one bullet listed below and explainwhat this formatting does and how it can be used in your chosen career field. Feel free to also discuss how this can be used throughout your academic endeavors.

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 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