Microsoft Office Tutorials and References
In Depth Information
10. Analyzing Worksheet Data
10. Analyzing Worksheet Data
What You’ll Do
Understand Tables
Create and Format a Table
Create or Modify a Table Style
Format Table Elements
Create Calculations in a Table
Work with Tables
Remove Table Rows and Columns
Enter Data in a Table Using a Drop-Down List
Sort Data in a Table
Display Parts of a Table with AutoFilter
Create Custom Searches
Use Slicers to Filter a Table
Export a Table to a SharePoint List
Analyze Data Using a PivotTable or PivotChart
Modify a PivotTable and PivotChart
Use Slicers to Filter a PivotTable
Display a Timeline to Filter a PivotTable
Chart a PivotTable
Use Power View and PowerPivot
Create Groups and Outlines
Convert Text to Columns
Add Data Validation to a Worksheet
Create a Drop-Down List
Search JabSto ::




Custom Search