A 6-part course that demystifies pivot tables. This course assumes that you are a beginner to Excel. All that is required for you to do is to follow through the video and understand the basic concepts. This course is strcutured in a way to only focus on the most important elements of creating and working with Pivot tables.
The first thing that the Pivot tables need is to make sure that the data which needs to be analyzed has to be in a specific format. For example if you have a blank column in your table, Pivot tables will want you to either delete that blank column or add some content to it. This lesson deals with the ways to normalise your data in a way suitable enough for the Pivot tables to use.
Now that we have the normalized data, in this lecture we will learn how do we go about creating the Pivot table.
Now that you have the Pivot table ready, you may need to customize it a bit to make sure it looks a bit more user friendly than what it is with the default options. You will learn how to apply different number formats, and how to change the layout of the Pivot tables in a way which brings the key information to the surface.
In this lecture, you take a step further and see how do we apply conditional formatting to the Pivot table results to highlight the content which would be of most interest to the audience.
In this lecture, you learn how to show the information you have in your Pivot table in charts. The default Excel charts may not work very well with the pivot table information. This is where the Pivot charts come into play with a very easy way to quickly turn your Pivot table information into graphs and charts.
In this lecture, you will learn how to use external data (the data which is not in the workbook which carries your pivot table) to create Pivot tables. You can use MS Access, MS SQL and various other data sources to use and present a pivot table summary in Excel as a client.
Now, that you know how to create Pivot tables. This lecture provides a summary of the key tips and tricks you need to keep in mind to get best results from the Pivot tables.
Founded by Amit Kumar, TechNitya.com is a London based professionally managed & committed training company.
TechNitya.com is proud of its team of high energy, passionate, and professional IT trainers/consultants drawn from drawn from both the world of academics as well as active industry practice with specialized knowledge in a variety of environments.
Amit Kumar, who is an MBA with more than 16 years of business management experience, is responsible for finding and recruiting experts around the globe in various domains and helping them turn their expertise into easy to follow and inexpensive courses/tutorials.
For further details…please feel free to contact us at the link below