Excel Pivot Tables -Artful Decision making in data Analysis
4.3 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,104 students enrolled

Excel Pivot Tables -Artful Decision making in data Analysis

Decode Excel Pivot tables with real world case studies. Master the Art and Science of Pivot tables.
4.3 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,104 students enrolled
Created by Amey Vidvans
Last updated 2/2018
English
Current price: $111.99 Original price: $159.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 17 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • In depth understanding of Pivot table mechanism.
  • Learn to handle any kind of the data with confidence.
  • Improve productivity by learning tips and tricks.
  • Prepare stunning Dashboards displaying key performance indicators.
  • Learn to generate trends and pattern to draw out conclusions.
  • Improved productivity and decision making.
Requirements
  • Basic Knowledge of Microsoft Excel
  • Desire to improve efficiency.
Description

*** Course with Applied learning approach, Easily Learn to develop trends and patterns, Decode Pivot table with practical examples, Life time Access, and 100% money-back guarantee!*** 

Why you need improve data Handling skills ?  –    

Data Analysis has become an inseparable parts of our lives. Enormous amount of data is collected on daily basis in every industry IT, Hospitality, Aviation, Banking , Tourism and Real Estate .

Data always remain in abstract form. It doesn’t make a sense unless until you process them, draw trends and patterns.

Data has it’s own simple language you just have to understand it.Once learn, you discover amazing new facts, information or insights about the data ,which will immensely improve your thinking and decision making. And remember Success in personal and professional life depends upon quality of data analysis and decision making.

Master the art of Excel pivot table to make strategic decisions –    

A Pivot Table is a simple and an extremely powerful tool that you can use to slice and dice data.    

You can track and analyze hundreds of thousands of data points with a compact table. That table can be changed dynamically to get different perspectives of the data. .   

 Creating pivot table is extremely simple and fast process. Reports can be created just by dragging and dropping, without performing any calculations. More over pivot table creates very interactive reports which further help you take correct decision.   

 Content and Overview: -    

Irrespective of the domain and industry, apart from giving necessary knowledge, tool and techniques this is my attempt to help you improve decision making process.   

I have tried to use applied learning approach while designing the course. This approach integrates class room learning with real-world situations. In this entire course we will learn pivot table, through some real life situations which you are likely to face. Every lecture we will try to unfold pivot table through real life problems.      What will you learn?    

  • Mechanics of the Pivot table.   

  • Structuring the Table data in proper format.   

  • How to design pivot table as per your needs.   

  • How to prepare excellent reports using various pivot table tools.   

  • How to make correct use of Visuals such as Charts and Conditional Formatting to improve understanding.   

  • How to use filtering tools such as Timelines and slicers to improve focus on critical areas.   

  • How to use power query.    

Who is the target Audience?   

  • Anyone who wants to learn the art of data analysis.

  • Anyone who handles excel on day to day basis.

  • Anyone who wants to improve decision making and there by becoming more productive. 

  • Anyone who wants to achieve something substantial in life by applying simple principles, 

From,

Any of the industry IT, Hospitality, Aviation, Banking, Tourism and Real Estate to name a few, and       

Any of the department Marketing, Sales, Production, Accounting, Finance, HR and QAQC to name a few.

Post purchase support : - A complete support and assistance is available for you.I would really love to see you use this on regular basis .

Money Back Guarantee : - On top of it UDEMY gives money back guarantee for 30 days if you are not satisfied.

See you inside the course and add this amazing tool to your knowledge portfolio.



Who this course is for:
  • Anyone who uses excel on regular basis.
  • Basic Excel users who wants to take their skills to new level.
  • Any one who wants to become productive in workplace.
  • Anyone who wants to improve decision making.
Course content
Expand all 14 lectures 01:28:39
+ Anatomy of the Pivot Table
7 lectures 37:12
Decoding mechanics of Pivot Table - Columns Area
03:46
Decoding mechanics of Pivot Table - Filters Area
04:12
How to Structe the Table Data
07:48
Design Tab
07:56
+ Detailed Analysis with Visualization
4 lectures 27:35
Sales Analysis with Pivot Chart
07:51
Share Market Daily Trending data analysis with Conditional formatting -1
05:22
Share Market Daily Trending data analysis with Conditional formatting -2
06:47
Detailed Sales Analysis using calculation under show value as option
07:35
+ Dashboard
2 lectures 15:28
Creating the Dashboard using slicers and Timeline
10:31
Data Analysis with Dashboard
04:57
+ Data consolidation
1 lecture 08:24
Prepare Cash flow Summary report using Power Query
08:24