From the course: Excel: PivotTables for Beginners
Join today to access over 24,200 courses taught by industry experts.
A word about fields - Microsoft Excel Tutorial
From the course: Excel: PivotTables for Beginners
A word about fields
- [Instructor] It seems like every app nowadays has its own jargon or set of terminology, and this is true with tables and PivotTables when it comes to the word field. In fact, there are many types of fields, and we're going to go over the basic ones here in this video. In your data, or in this case, this table, think of the columns as being fields. So this is the date field, this is the buyer field, and so forth, and so on. Why use the word field instead of a column? Because field is used a lot in the PivotTable menus and dialog boxes. PivotTables simply don't call these columns, they call them fields. So getting used to calling them fields will help you a lot later. There are also PivotTable fields. Let me show you what I'm talking about. I'm going to head over to this tab here and I'm going to show you this little PivotTable here. It says sum of amount, $69,977. Why make such a small PivotTable? Well, it…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.