Data Analytics with Excel PivotTables 2016
3.9 (222 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,976 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Analytics with Excel PivotTables 2016 to your Wishlist.

Add to Wishlist

Data Analytics with Excel PivotTables 2016

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples
3.9 (222 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,976 students enrolled
Last updated 9/2016
Current price: $12 Original price: $60 Discount: 80% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
  • 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

About this course

This course will teach you how to do Data analytics with Excel PivotTables 2016. 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 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 PivotTables to make your data visually more appealing and easier to analyse. With a step by step guide and examples, this course is easy to comprehend and learn. 


Who is the target audience?
  • 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
Compare to Other Excel Courses
Curriculum For This Course
Data Analytics with Excel PivotTables 2016
8 Lectures 52:28

After this course 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.

Preview 01:15

After this course about business analytics 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

Preview 08:25

After this course, you will understand what makes Microsoft Excel ideal for Data analytics. 

You will understand benefits of using excel.

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

Preview 04:12

After this lesson, 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.

Gettinng Started with PivotTable

After this course on grouping you know how to Group data by date or time items, Group data by numeric items, Group data by selected item


After this course, 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.

Custom calculation

After this course, 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


After this course, 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.

About the Instructor
UpSkill Ladder
4.3 Average rating
265 Reviews
4,461 Students
3 Courses
Designing an Experience

Upskillladder is committed to professional advancement helping talents climb their career ladder with ease. A company started by a group of IT professionals, with a strong background in the e-learning arena, Upskillladder's motto is to revolutionize learning process--taking the less taken path.

We started our journey by providing training materials to corporate, and have recently stepped into the e-learning world. 
With a strong mission of taking technology to the roots and a vision to upskill one and all, we have collaborated with the best of our technical wizards to come up with the choicest of courses in the IT circuit. Our training course materials are designed by a group of peerless SMEs and tutors by the agency of fine instructional designers and graphic designers-a wishful blend of technology and instruction-which assures the best of courses for our students ranging from management to IT.

Navya Kannan
3.9 Average rating
222 Reviews
2,976 Students
1 Course
Software Asset Management Specialist

Started career as IT Service Desk executive for over 2 years. Later moved on to work as Software Asset Management (SAM) Specialist. My role involved taking care of Software compliance across the company. After continuing in this role for closer to 3 years, I started working as a Risk Consultant with the Big 4s. My role was to conduct software publisher specific audits to check an organisation's compliance status. This activity required extensive reporting, mainly with the help of Microsoft Excel and other tools.