4.31 out of 5
1085 reviews on Udemy

Data Analytics with Excel PivotTables

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples
Navya Kannan
51,154 students enrolled
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

About this course

This course will teach you how to do Data analytics with Excel PivotTables. With the help of this course, you will understand the concept, various scenarios, and types of Business analytics. Along with that, you will learn, how to use one of the strongest features of Microsoft Excel, which is the PivotTables

Target audience

Anyone with no knowledge to a basic knowledge of Microsoft Excel can take this course and get a thorough understanding of Excel PivotTables. 

Course Structure

In this short but effective course, you will understand why Data analytics is very important in today’s business to make an effective business decision, and how Excel can help you with this. 

This course takes you through the details of Data analytics and with various examples, helps you understand various aspects where Data analytics plays a vital role. Then you will learn, how you can exploit the power of Excel PivotTable to make your data visually more appealing and easier to analyze. With a step by step guide and examples, this course is easy to comprehend and learn. 


Data Analytics with Excel PivotTables 2016


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 analytics

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 PivotTables

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 PivotTable

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 PivotTable

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 PivotTable

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.


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


In this lecture, you will know the features and benefits of using PowerPivot. You will also be able to install the PowerPivot add-in.    Finally, you will learn how to combine multiple tables using the PowerPivot feature.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3 out of 5
1085 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
Course available for 2 days
30-Day Money-Back Guarantee


1 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Don't Miss Any Course Join Our Telegram Channel Join Channel
+ +