Excel Pivot Tables Demystified for Beginners
4.3 (4 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.
146 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Pivot Tables Demystified for Beginners to your Wishlist.

Add to Wishlist

Excel Pivot Tables Demystified for Beginners

A 6-part course that demystifies pivot tables
4.3 (4 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.
146 students enrolled
Created by Tech Nitya
Last updated 12/2013
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 25 mins on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will give the skills required to use pivot tables.
  • This course will empower you to take your data and work with it in new and different ways.
View Curriculum
Requirements
  • Any version of MS Excel
  • Basic working knowledge of Excel
Description

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.

Who is the target audience?
  • This course is appropriate for users who are familiar with basic excel functions.
  • This course is also targeted to the users who want an easy and dynamic way to summarize and analyse data
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+ –
Excel PivotTables Demystified
8 Lectures 24:53

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.

Preview 05:23

Now that we have the normalized data, in this lecture we will learn how do we go about creating the Pivot table.

Preview 05:07

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.

Number formats and layout
04:54

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.

Conditional Format
01:06

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.

Pivot Chart
02:38

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.

External Data
04:12

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.

Summary
7 pages
About the Instructor
Tech Nitya
4.4 Average rating
16 Reviews
436 Students
3 Courses
Software Training, Tutorials, Instructional Design

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

http://technitya.com/contact