Working with Microsoft Excel tables, Pivot Charts and Pivot Tables

In this tutorial you are going to learn the following as per enumerated below

• Explore structured range of cell data
• Freeze a rows and columns
• Creating and planning Excel table
• Renaming and formatting Excel Table
• Delete, edit and add records in Excel table
• Sort excel cell data
• Filter Cell data
• Insert total row to summarize Excel table
• Insert subtotals into a range of cell data
• Use Outline  button to hide or show the details
• Creating and modifying Pivot Table
• Filtering and sorting Pivot Table
• Grouping a Pivot Table item
• Creating Pivot Chart