Learn Pivot Table, Pivot Chart, Pivot Power

  • 0.0
  • (No reviews)

Description

In this course you will learn from  experts on what a Pivot Table, Pivot Chart, Pivot Power is, find a number of examples showing how to create and use Pivot Table, Pivot Chart, Pivot Power in all version of Excel.

What is a Pivot Table in Excel?

An Excel Pivot Table is a tool to explore and summarize large amounts of data, analyze related totals and present summary reports designed to:

  • Present large amounts of data in a user-friendly way.

  • Summarize data by categories and subcategories.

  • Filter, group, sort and conditionally format different subsets of data so that you can focus on the most relevant information.

  • Rotate rows to columns or columns to rows (which is called "pivoting") to view different summaries of the source data.

  • Subtotal and aggregate numeric data in the spreadsheet.

  • Expand or collapse the levels of data and drill down to see the details behind any total.

  • Present concise and attractive online of your data or printed reports.

If you are working with large data sets in Excel,  Pivot Table comes in really handy as a quick way to make an interactive summary from many records. Among other things, it can automatically sort and filter different subsets of data, count totals, calculate average as well as create cross tabulations.

Another benefit of using Pivot Tables is that you can set up and change the structure of your summary table simply by dragging and dropping the source table's columns. This rotation or pivoting gave the feature its name.


Course Info

Created by Ogundipe Sunday
55 minutes on-demand video
5 lectures
837+ students enrolled
0.0 rating from 0+ reviews
English language
Created on May 30, 2023

Ad

Frequently Asked Questions

  • How long is a coupon valid?

    Coupons are issued by instructors to promote their courses, gain traction and reach momentum. The instructor can choose to emit discounted (ex: $11.99 coupon) or 100% off coupon (you pay nothing). Each coupon becomes expired when emitted quota is over (1000 enrollments) OR expiration date has been reach (5 days).

  • What is this "1000 enrollments" from Udemy?
  • Could you please help me to find a coupon for this course?
  • What is exactly your relationship with Udemy?

© INFOGNU - 2024