Head Office Chabahil -7 4484097, 9851023208, 9801076620 info@blackhawk.edu.np

 Excel 2016: Data Analysis with Pivot Tables

Excel 2016: Data Analysis with Pivot Tables Training in Kathmandu Nepal

1 - Preparing Data & Creating PivotTables

  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Source

2 - Analyzing Data Using PivotTables

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data

3 - Working with PivotCharts

  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

4 - Getting Started with Power Pivot

  • Enable and Navigate Power Pivot
  • Manage Data Relationships

5 - Visualizing Power Pivot Data

  • Create a Power Pivot Report
  • Create Calculations in Power Pivot

6 - Working with Advanced Functionality in Power Pivot

  • Create a Key Performance Indicator
  • Work with Dates and Time in Power Pivot

Career Opportunity

Get your admission now!

Enroll