MS Excel 2013 Pivot Table Basic to Advance Video Training
4.0 (5 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.
103 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MS Excel 2013 Pivot Table Basic to Advance Video Training to your Wishlist.

Add to Wishlist

MS Excel 2013 Pivot Table Basic to Advance Video Training

Learn Advance Pivot Table with Easy and Practical Examples which help you to understand use of pivot table excel 2013
4.0 (5 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.
103 students enrolled
Created by Veer Tutorial
Last updated 12/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understanding the concept of Pivot Tables
  • Data required to make Pivot Table
  • You will be able to create pivot table and pivot chart
  • You can do Formatting, Conditional Formatting, Printing of Pivot Table & many more...
View Curriculum
Requirements
  • You should have basic understanding of MS Excel 2013 / 2010 / 2007 Version
  • You need a computer with MS Office 2013 installed
  • Most Important, your will to learn
Description

Pivot Table is very important and good feature in Microsoft Excel 2013. You can use pivot to make summary of large data in few clicks. Pivot Table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet of MS Excel, displaying the results in a second table showing the summarized data. You can create dynamic reports by dragging & dropping the field heading of table.

I have been working in excel for more than 15 years and use PivotTable everyday to make MIS (Management information System) and dynamic reports. I put all my experience to create this course. 

We will start learning from basics of PivotTable, end with Advance Techniques for using pivot table. I will also explain some hidden features of pivot table with some practical examples for your practice.

This course is good for 

  • Students / Freshers graduates from any stream (Commerce, Engineer, Doctor etc.)
  • Working professionals can increase their productivity
  • Anyone who wants to make his / her career in MIS & Analytics of data
Who is the target audience?
  • Students who want to make their career in analytics
  • Working Professional to increase their productivity in Excel
  • Who is Preparing MIS (Management information system)
  • Anyone Wants to increase knowledge of Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
01:53:57
+
Introduction & basic understanding of pivot table
8 Lectures 25:48


Recommended Pivot Table Format by Excel
04:06

Re-arrangement of Pivot Table Defaut Format
02:34


Connect with External Data in Excel for Creating PivotTable
03:28

Consolidate Data with PivotTable
04:51

Move, Manage & Copy the PivotTable
02:10
+
Manipulation of Formula and Number Format
5 Lectures 18:57
Manage SubTotal & Grand Total in Pivot Table
04:25

Formatting Number Values
05:04

Use more than one Field in Values
02:58


Use of Group feature with pivot table
02:27
+
Sort and Filter the Data in Pivot Table
6 Lectures 17:42
Sorting Data
03:07

Sorting Data with Custom List
03:39

Filtration by Selection
02:21

Filtration by Rules
02:04


Use of Slicer for Fitration
03:45
+
Manage Pivot Table Layout, Style & Format
3 Lectures 08:56
Use Pivot Table Default Styles
02:20

Use Pivot Table Customs Styles
02:59

Report Layout of Pivot Table
03:37
+
Define Conditional Formatting & Rules for Pivot Table
6 Lectures 21:38
Conditional Formatting for Pivot Table
03:22

Highlight Top Values in Pivot Table
05:35

Use Databar for Highlight Values
04:02


Use of Icons for Highlight Values
02:16

Edit & Clear Conditional Formatting Rules
03:42
+
Pivot Chart
5 Lectures 13:30
Create Pivot Chart
02:31

Edit Pivot Chart
02:41

Formatting of Pivot Chart
03:42

Define Layout of Pivot Chart
02:17

Change Chart Type
02:19
+
Printing of Pivot Table & Pivot Chart
1 Lecture 07:26
Printing of Pivot Table & Chart
07:26
About the Instructor
Veer Tutorial
4.1 Average rating
183 Reviews
1,216 Students
12 Courses
Ultimate Destination for All Computer Course

Veer Tutorial is an Indian company having high quality of computer related courses. We teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.