Pivot Table using Microsoft Excel

 What is Pivot Table?
Microsoft Excel 2010 is rich of features and one most important feature is Pivot Table management, development and deployment. In simple words, a pivot table allows you to create an interactive view of your data set. We call this view a pivot table report. With a pivot table report, you can quickly and easily categorize your data into groups, summarize large amounts of data into meaningful information, and perform a wide variety of calculations in a fraction of the time it takes by hand. But the real power of a pivot table report is that you can interactively drag and drop fields within your report, dynamically changing your perspective and recalculating totals to fit your current view.

When Should You Use a Pivot Table Excel?
Large data sets, ever-changing impromptu data requests, and multilayered reporting are absolute productivity killers if you have to tackle them by hand. Doing hand-to-hand combat with one of these tasks is not only time consuming, but it also opens the possibility of an untold number of errors in your analysis. So how do you recognize when to use a pivot table before it is too late?

Generally, a pivot table serves you well in any of the following situations:
You need to find relationships and groupings within your data.
You need to find a list of unique values for one field in your data.
You need to find data trends using various time periods.
You anticipate frequent requests for changes to your data analysis.
You need to create subtotals that frequently include new additions.
You need to organize your data into a format that is easy to chart.

Who Should Attend?
Anybody who once faced a situation as described above needs to know a pivot table.

Breakdown of Contents
The course contents are categorised into the following distinct areas:

• Pivot Table Fundamentals
• Creating a Basic Pivot Table
• Customizing a Pivot Table
• Grouping, Sorting, and Filtering Pivot Data
• Performing Calculations Within Pivot Tables
• Using Pivot Charts and Other Visualizations
• Analyzing Disparate Data Sources with Pivot Tables
• Sharing Pivot Tables with Others
• Working with and Analyzing OLAP Data
• Mashing Up Data with PowerPivot
• Enhancing Pivot Table Reports with Macros
• Using VBA to Create Pivot Tables
• Advanced Pivot Table Tips and Techniques

Registration
Registration is open for Two months long course offered online, live and personalized on http://elearning.aneconomist.com and teaching portal of the virtual classroom from http://www.wiziq.com Registration is for Weekly sessions and each student can register on One to One Weekly session until the course is complete only. You have to select which week you would start your course and what topic of the contents will you learn. There is also an option to request for a special course for with complete set of contents. Registration is purely on rolling basis. Online discussion, lectures and video-lecturing will start on each Saturdays/Sundays. It is compulsory that students confirm their enrolment before Thursday, 7PM GMT. Late fee of 20% will be charged after Thursday 7PM GMT and before 7PM GMT Friday. Later registration will only be allowed for next weekend. Courses materials will be provided when students confirm their registration and enrolment by paying the course fee within 24 hours of registration. All accounts which do not confirm enrolment will be removed from the course portal.
 
Fee
The course fee is £300. 2o% discount is allowed for group of two to 5 registrations. Groups of higher than 5 registrations will be discounted by 30%.

Supporting Material
The learning materials include EBooks, examples of MS Excel documents and related lecture materials will be provided in form of datasets.

Certification
There is Test, Assignment after each Week. Passing this will enable you to request for PASS certificate of the course mentioning your topics, assignment topics, grades in tests and assignments. Hard Copy of the Certificate will mailed at additional £10 to any destination across the world. If you do not need to request your certificate in paper, no charges are applicable. Soft/Scanned copies will be provided free of cost via email and downloadable from course portal.