From the course: Excel: PivotTable Tips
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Counting nonnumerical fields - Microsoft Excel Tutorial
From the course: Excel: PivotTable Tips
Counting nonnumerical fields
- [Instructor] Alright, for this pro-tip I want to share with you how we can use pivot tables to count non-numerical or text-based fields. So when you're working with a pivot that values pane in your field list, is almost always used for quantitative, numerical fields, your numbers. These are your fields you can add, multiply, subtract, and summarize in different sorts of ways. But here's the thing, it can also be used to analyze the count or the frequency non-numerical fields, of text-based fields. And because you can't really aggregate or summarize texts, based on a sum or an average or a max. What we're going to do is use the of summarization which is the default, to display frequencies for each of those text-based values. So let me show you an example of what I mean by that. We're going to be looking at our IMDB movie database here, and the idea is to understand the distribution of our data, of our titles, based on other fields like genre for instance. If we pull genre into both…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Customizing the field list4m 7s
-
(Locked)
Autofitting column width4m 21s
-
(Locked)
Outline and tabular layouts7m 46s
-
(Locked)
Counting nonnumerical fields6m 5s
-
(Locked)
Grouping dates8m 3s
-
(Locked)
Enabling multiple filters5m
-
(Locked)
Grouping values6m 50s
-
(Locked)
Adding value calculations9m 1s
-
(Locked)
Showing empty items6m 22s
-
(Locked)
Configuring slicers and timelines10m 23s
-
(Locked)
Conditional formatting8m 23s
-
(Locked)
Removing and reviving source data8m 19s
-
(Locked)
Adding custom sort lists5m 23s
-
(Locked)
Solve order and list formulas6m 16s
-
-