From the course: Excel: PivotTables for Beginners (2018)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
A word about fields - Microsoft Excel Tutorial
From the course: Excel: PivotTables for Beginners (2018)
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 pivot tables when it comes to the word field. In fact, there are many types of fields, and we'll 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 here is the date field, this is the buyer field, and so on. Why use the word field instead of column? Because the word field is used a lot in the pivot table menus and dialog boxes. Pivot tables simply don't call these columns. They call them fields. So getting used to calling them fields now will help you a lot later. There are also pivot table fields. Let me show you what I'm talking about. I'm going to switch to this tab, and I'm going to show you this little pivot table here, sum of amount and $69,977. Why make such a small pivot table? Because it illustrates the concept of another term, which is the value field. A value field is a…
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.