Advanced PivotTable for Analyzing Data

Summarize, Analyze, and Visualize all types of data on PivotTable and PivotChart easily and effectively.
Free tutorial
Rating: 4.7 out of 5 (6 ratings)
1,101 students
45min of on-demand video
English [Auto]

Build PivotTable or PivotChart from worksheet data
Connect PivotTables from other sources and Power BI
Work with PivotTable Values and play around the design and formatting
Utilize a PivotTable Slicer to filter data and Organize PivotTable Timeline to filter date
Utilize a PivotTable with the Data Model to analyze data in multiple tables
Analyze and Visualize data by using PivotTable and PivotChart allowing you to readily observe comparisons, patterns, and trends


  • No experiences are required. You will learn everything you want !


Why need PivotTable and PivotChart?

A PivotTable may be used to summarize, analyze, explore, and show summary data. PivotCharts provide visuals to the summary data in a PivotTable, allowing you to readily observe comparisons, patterns, and trends. PivotTables and PivotCharts both allow you to make informed decisions regarding crucial data in your organization. You may also build PivotTables by connecting to other data sources just like SQL Server tables, SQL Server Analysis Services cubes, Azure Marketplace, Office Data Connection (.odc) files, XML files, Access databases, and text files, or by using existing PivotTables.

What will you learn?

1. Build PivotTable and Pivot Chart

  • Create a PivotTable from worksheet data

  • Refresh PivotTables

  • Work with PivotTable Values

  • Work with calculating values in a PivotTable

  • Create Calculated Fields

  • Create a PivotChart

2. Field Arrange, Slicer and Timeline

  • Use slicers to filter PivotTable data

  • Create a PivotTable timeline to filter dates

3. Connect to other data source

  • Connect PivotTables from other sources

  • Change the source data for a PivotTable

  • Use another PivotTable as a data source

  • Create a PivotTable connected to Power BI Datasets

Who need the course?

  • This course is useful for all people who are working in data sector such as data engineer, data analyst and data scientist.

  • This course is also useful for M&E specialist to increase additional capacity

  • Everyone who is willing to understand about the data analysis.

Who this course is for:

  • All Non-profit, Private Sector staffs who are working with data.


Monitoring, Evaluation and Learning Specialist
Nhoeb Khan
  • 4.4 Instructor Rating
  • 40 Reviews
  • 2,407 Students
  • 4 Courses

I am Nhoeb Khan, a professional Monitoring and Evaluation Specialist,

15 year experiences in many Development Projects. I will develop fantastic courses for you to improve your career !

My Background

I have more than 12 years of experiences related to all sectors in NGO or INGO, particularly in Management, Monitoring and Evaluation sector in multiple programs. I have started working since 2006 from the bottom level of position to the top level of position. Please check my draft experiences from the present down to the past, in the following:

• Worked as M&E specialist at ECODIT LLC for USAID Project title as USAID CGFA.

• Worked as Senior M&E, Data science and Research Specialist at USAID Tech for Green Cities

implemented by Institute for Development Impact (I4DI) owned HQ in Washington DC.

• Worked as Regional M&E Manager at USAID CMEP implemented by University Research Co.,LLC

(URC) in Cambodia.

• Worked as Senior M&E Officer at CARE Cambodia based in Ratanakiri province in Cambodia.

• Worked as Regional M&E and program Specialist at the Consortium of 4 NGOs in Battambang, Banteay Mean Chey and Pursat provinces in Cambodia.

• Worked as an M & E Assistant at USAID/Cambodia HARVEST for 4 years, USD 60 million project in Cambodia

around Boeng Tonle Sap Lake region.

Contact Me

Please feel free you reach out to me via email: nhoebkhan@gmail.com

Top companies trust Udemy

Get your team access to Udemy's top 19,000+ courses