SharePoint Online: Lists & Views ๐
Microsoft SharePoint Online · Curated Video Lessons
SharePoint lists are one of the most powerful and flexible tools in Microsoft 365 — they're structured data tables that can track almost anything: tasks, contacts, inventory, project milestones, help desk tickets, or any custom business data. Combined with views, which let you filter, sort, group, and format the same list data in multiple ways, SharePoint lists become a no-code database available directly in your browser. This guide covers creating lists, adding columns, building views, and using the modern list experience to its full potential.
๐ SharePoint Lists Tutorial 2024 – Everything You Need to Know
A comprehensive 2024 tutorial on SharePoint Lists covering everything you need to know — from creating a new list from scratch, from an Excel spreadsheet, or from an existing list template, to adding and configuring every column type (single line of text, multiple lines, choice, number, currency, date, person, lookup, yes/no, hyperlink, image), setting required and default values, and building list forms. This tutorial is the best starting point for anyone who wants to use SharePoint lists to track and manage structured data in Microsoft 365.
- List Creation
- Column Types
- List Forms
- Excel Import
Source: SharePoint Lists Complete Series 2024
๐️ SharePoint List Views – Complete Guide
A deep dive into SharePoint list views — covering how to create standard views, datasheet views, calendar views, and gallery views, how to configure filtering, sorting, grouping, and column selection for each view, how to set a default view, how to create personal views vs shared views, and how to use view formatting to apply conditional colours and icons based on list item values. Views are what transform a flat list of data into a meaningful, filtered, and formatted display that actually helps users make decisions.
- Standard Views
- Calendar Views
- Filtering & Sorting
- View Formatting
Source: SharePoint Views Series
๐ Microsoft Lists – Full Tutorial (2024)
A full 2024 tutorial on Microsoft Lists — the modern list experience that works across SharePoint, Teams, and the standalone Lists app. This video covers how Microsoft Lists relates to SharePoint lists (they're the same underlying technology), how to create lists using the new templates (Issue Tracker, Employee Onboarding, Asset Manager, Travel Requests, and others), how to use the grid view for quick data entry, how to configure list rules to send automatic notifications when items change, and how to share and collaborate on a list with your team.
- List Templates
- Grid View
- List Rules
- Team Sharing
Source: Microsoft Lists Tutorial Series 2024
๐จ SharePoint Column & View Formatting – Beginners to Advanced
A beginner-to-advanced tutorial on SharePoint column formatting and view formatting — covering how to use the built-in formatting options to add colour-coded choice columns, progress bars, clickable buttons, icon indicators, and conditional formatting without any code, as well as how to use JSON-based formatting to create fully custom column displays. Column and view formatting is one of SharePoint's most powerful and underused features, turning a plain list into a visually rich dashboard that makes the data far easier to scan and understand at a glance.
- Colour Coding
- Progress Bars
- JSON Formatting
- Conditional Styles
Source: SharePoint Formatting Series
๐ Advanced SharePoint Lists – Power User Tips
An advanced SharePoint lists tutorial with power user tips — covering lookup columns to relate two lists together, calculated columns using formulas similar to Excel, indexed columns for fast filtering in large lists, content approval workflows, list validation settings to enforce data entry rules, the JSON-based list formatting gallery for inspiration, how to use Power Apps to build a custom form for a SharePoint list, and list templates for reusing your list design across multiple sites. These techniques elevate SharePoint lists from a basic tracking tool to a proper business application.
- Lookup Columns
- Calculated Columns
- Content Approval
- Power Apps Forms
Source: SharePoint Advanced Lists Series
Microsoft SharePoint Online · Lists & Views · Video Guide
Comments
Post a Comment