Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analytics with Excel Pivot Tables
Rating: 4.3 out of 5(2,952 ratings)
113,855 students

Data Analytics with Excel Pivot Tables

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples
Created byNavya Kannan, Learnsector LLP
Last updated 9/2025
English

What you'll learn

  • Understand the importance of Data analytics in today's business.
  • Understand the types of Business analytics and real life examples of Business analytics
  • How to use Excel PivotTables to easily and effectively work on your reports and make your data visually more appealing.
  • You will learn the different features of PivotTables like Grouping, Calculated Field, Calculated Item, Slicers, PowerPivot and Charts

Course content

1 section • 8 lectures • 1h 14m total length

  • Introduction1:15

    At the end of this lecture, you will be able to explain the different types of  Analytics, describe the various areas where analytics can be applied.

    You will also be able to use PivotTables, one of the strongest features of Excel, to perform effective data analysis with examples.

  • Business analytics8:25

    In this lecture, you will understand what Business Data analytics is, various real-life scenarios where data analytics is widely used.

    You will be able to explain the different types of analytics namely-  Descriptive Analytics, Diagnostic Analytics, Predictive Analytics, and  Prescriptive analytics.   

    You will also understand the benefits of data analytics and how it helps in making better decisions.

  • Excel and PivotTables4:12

    In this lecture, you will understand what makes Microsoft Excel ideal for Data Analytics. You will understand the benefits of using Excel.

    Finally, you will know the points to remember when you get your data ready for importing to a PivotTable.

  • Getting Started with PivotTable11:43

    In this lecture, you will understand the usage of Recommended PivotTables and Custom PivotTables, various components of a PivotTable, and how to format your PivotTables.

    Once you have your PivotTables ready you will also know how to add charts to it.

  • Grouping in PivotTable7:27

    In this lecture, you know how to group data by Date or Time items, group data by Numeric items, group data by Selected item.

  • Custom calculation in PivotTable9:17

    In this lecture, you will be able to use Custom calculation, how to add a Calculated field and add a Calculated item in your worksheets. You will also understand the restrictions with a calculated item.

  • Slicer2:47

    In this lecture, you will be able to add a slicer to your PivotTable. With these interactive slicers, you will be able to filter your data quickly and easily

  • PowerPivot, Power Query, and Data Model29:25

    In this lecture, you will know the features and benefits of using Data Model and PowerPivot. You will also be able to explore the features of Power Query.

Requirements

  • All you need is a Microsoft Excel installed on your desktop.
  • With a basic know-how of Excel you are good to go ahead with this course

Description

About this course

This course is designed to provide you with the necessary knowledge and skills to perform data analytics using Excel Pivot Tables. Through this course, you will gain a comprehensive understanding of the concept of data analytics, different types of business analytics, and how Pivot Tables can be used to perform data analysis.

Target audience

The course is intended for individuals with little or no prior knowledge of Microsoft Excel. Anyone who is interested in gaining an in-depth understanding of Excel Pivot Tables can benefit from this course.

Course Structure

The course is structured in a way that allows you to learn about the importance of data analytics in making effective business decisions. You will learn about the various aspects where data analytics plays a vital role and how it can help businesses to gain a competitive advantage.

The course will then introduce you to Excel Pivot Tables and how they can be used to analyze and present data in a visually appealing manner. You will be guided step-by-step on how to create Pivot Tables, customize them, and manipulate data to gain insights that can inform business decisions.

Throughout the course, you will have access to a number of examples and exercises to help you reinforce your learning. The course is designed to be easy to comprehend and learn, even for beginners.

Upon completion of the course, you will have the necessary skills and knowledge to perform data analytics using Excel Pivot Tables. You will be able to use data to gain insights that can inform business decisions and improve overall performance.

Who this course is for:

  • This course is helpful for anyone who works on Excel reports as this will make reporting more efficient.
  • If you deal with business presentations, then you can make use of this powerful tool to make an impact

Report abuse