advanced spreadsheet

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.

Below is the bullet I have chosen.

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