technifyed

Great Learning via Great Learning Academy

Pivot Tables in Excel

4.63,205 ratings at Great Learning Academy

Overview

Discover the significance of Pivot Tables and learn the essentials of creating them efficiently. Explore diverse methods for summarizing data and delve into various tools, mastering their implementation for insightful analysis. Gain expertise in style options, insert slicers for enhanced interactivity, and seamlessly change data sources. Understand the importance of refreshing data for dynamic updates. Conclude with a comprehensive summary, ensuring a solid grasp of Pivot Table fundamentals.

Transition seamlessly to Excel Graphs and Charts, where you'll receive a concise introduction to their role in data visualization. Implement and understand various chart types within Excel workbooks, concluding the course with a summary to solidify your proficiency in both Pivot Tables and Excel Graphs. Elevate your Excel skills and make data-driven decisions effortlessly!

What you'll learn

  • Pivot Tables in Excel
  • Data Analysis
  • Data Summarization
  • Excel Reporting
  • Pivot Table Tools
  • Excel Style Options
  • Data Slicers
  • Data Source Management
  • Data Refresh
  • Excel Graphs and Charts
  • Data Visualization
  • Excel Workbook

Syllabus 15

  1. Pivot Tables in Excel

    Pivot tables are used to sort, count, total or reorganize the data stored in a table. Pivot tables are one of the most powerful features in Excel for Data Analytics. In this module, understand what Pivot tables are used for and how they are used by looking into examples shared by the instructor.

  2. Pivot Table and Its Importance
  3. How to create a Pivot Table
  4. Different ways to summarize data
  5. Various Tools
  6. Implementation of various tools
  7. Style Options
  8. Insert Slicer
  9. Change Data Source
  10. Refresh
  11. Summary on Pivot table
  12. Agenda to Excel Graphs and Charts
  13. Introduction to Graphs and Charts in Excel
  14. Implementation and Explanation of Charts on Excel Workbook
  15. Summary on Graphs and Charts

Advantages and disadvantages

Advantages

  • Free, short, with a free certificate.
  • Made in India, with examples Indian students will recognise.
  • Free certificate when you finish.
  • Completely free.
  • Self-paced: start any time.
  • A clear syllabus (15 parts) you can see before you start.

Disadvantages

  • Introductory; the certificate carries little weight with employers.
  • Expect follow-up calls and emails about paid programs.

Some points apply to every course of this kind; see how we rank.

Free, with a free certificate

  • Free: Sign up with your email or phone to watch.
  • Certificate: Free when you finish the videos and quiz.

Taught by

  • Tony TomTony Tom is a Research Analyst at Great Learning, bringing strong analytical skills and a structured engineering mindse…

Great Learning is in Tier 4: commercial training companies and platform-made courses of our institution ranking (58/100).

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 18.650 Statistics for Applications, Fall 2016

MIT 18.650 Statistics for Applications, Fall 2016 View the complete course: http://ocw.mit.edu/18-650F16 Instructor: Philippe Rigollet This course offers an in-depth the theoretical foundations for statistical methods that are useful in many applications. The goal is to understand the role of mathe…

Free video22 videos, 28 hours

Stanford University · YouTube

AI Luminaries

A curated collection of videos featuring top experts in artificial intelligence.

Free video20 videos, 15 hours

Stanford University · YouTube

Generative AI Program

-Learn more and enroll in the program: https://online.stanford.edu/programs/generative-ai-technology-business-and-society-program Recent advancements in generative AI are reshaping industries, pushing technological boundaries, and revolutionizing creative processes. In this fast-changing landscape…

Free video24 videos, 2 hours

Stanford University · YouTube

Artificial Intelligence

For more information about Stanford's Artificial Intelligence programs visit: https://stanford.io/ai Delve into the exciting world of Artificial Intelligence with insights and research from the world's top experts. This playlist offers a comprehensive journey, from foundational machine learning con…

Free video187 videos, 142 hours

Stanford University · YouTube

Stanford CS229: Machine Learning led by Andrew Ng | Autumn 2018

Led by Andrew Ng, this course provides a broad introduction to machine learning and statistical pattern recognition. Topics include: supervised learning (generative/discriminative learning, parametric/non-parametric learning, neural networks, support vector machines); unsupervised learning (cluster…

Free video21 videos, 28 hours

Massachusetts Institute of Technology · YouTube

MIT 6.034 Artificial Intelligence, Fall 2010

View the complete course: http://ocw.mit.edu/6-034F10 Instructor: Patrick Winston In these lectures, Prof. Patrick Winston introduces the 6.034 material from a conceptual, big-picture perspective. Topics include reasoning, search, constraints, learning, representations, architectures, and probabili…

Free video30 videos, 24 hours

Enter your email and the official page opens. Phone is optional.