
Explore lookup columns in SharePoint lists, learn their purpose, benefits, and how they differ from site and choice columns. Build and compare site, lookup, and choice columns with practical demos.
Understand how to create true lookup columns in SharePoint 365 Spotlight by retrieving values from another list via manual lookups, with a 12-lookups-per-view limit.
Explore how a choice column provides a drop-down for data entry, how it differs from a lookup column, and how numeric choices can be used in calculations within SharePoint 365.
Create site columns at the top-level of the site collection to share across all subsites; changes propagate, and they do not belong to any specific list or library.
Learn how to create and use site columns in SharePoint, locate Microsoft built columns in site settings, and apply a choice column across lists and libraries for consistent data.
Compare lookup columns to site columns: lookup columns can be created in any list or library with no elevated permissions, while site columns require site collection level permissions.
Explore how lookup columns pull two or more columns across lists for consolidated data, note calculation limitations, and see the spotlight bundle’s basic formulas, excel style functions, and financial calculations.
This course teaches the proper use of Lookup Columns. For the sake of comparison, Site Columns and Choice Columns are also addressed. All are demonstrated and their correct usage explained.
In this course you will learn more about the following topics:
Differentiating Lookup columns from Site Columns and Choice columns
Defining lookup columns
Knowing when to use lookup columns
Understanding how lookup columns are used
Understanding who can create lookup columns
Creating and using Lookup columns
Creating and using Choice columns
Creating and using Site Columns
Examining a pre-built site columns
Creating a new site column
Using a site column
With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!
Released: 5/27/2022