SharePoint with List Creation and Management

Inquire now

Duration 2 Days – 14 hrs.

 

Overview

This practical training course equips participants with the knowledge and hands-on skills to effectively use Microsoft SharePoint and Microsoft Lists for managing structured data, automating processes, and improving team collaboration.

The course focuses on creating, customizing, and managing SharePoint lists as powerful low-code tools for business solutions such as task tracking, issue management, approvals, and data monitoring. Participants will also learn how to enhance lists using views, permissions, and basic automation with Power Automate, enabling them to streamline workflows and improve operational efficiency.

By the end of the training, participants will be able to design and deploy real-world SharePoint list solutions tailored to their organizational needs.

 

Objectives 

  • Understand the fundamentals of SharePoint Online and Microsoft Lists
  • Create and manage SharePoint lists for business use cases
  • Configure columns, metadata, and list structure
  • Design and customize views for better data visualization
  • Manage list permissions and access control
  • Apply data validation and business rules
  • Automate list processes using Power Automate (basic workflows)
  • Integrate SharePoint lists with Microsoft Teams, Excel, and Outlook
  • Apply best practices for list design, governance, and performance

 

Target Audience 

  • Business Users and Power Users
  • Administrative and Operations Staff
  • Project Coordinators and Team Leads
  • IT Support and SharePoint Site Owners
  • Anyone responsible for tracking data, managing workflows, or organizing information

 

Prerequisites 

  • Basic knowledge of Microsoft Office (Excel, Outlook)
  • Familiarity with web-based applications
  • No prior SharePoint experience required

 

Course Outline

 

Module 1: Introduction to SharePoint & Microsoft Lists 

  • Overview of SharePoint Online in Microsoft 365
  • Understanding sites, libraries, and lists
  • Introduction to Microsoft Lists
  • Business use cases of SharePoint lists
  • SharePoint Lists vs Excel

Module 2: Creating SharePoint Lists

  • Creating lists from:
    • Blank list
    • Templates (Task tracker, Issue tracker, Asset list)
    • Excel import
  • Planning list structure and naming conventions
  • Understanding list components

Module 3: Columns & Data Structure 

  • Creating and managing columns:
    • Text, Number, Date, Choice, Yes/No
  • Lookup columns and relationships
  • Required fields and default values
  • Managing and editing list data

Module 4: Views & Data Visualization 

  • Creating custom views
  • Filtering, sorting, and grouping data
  • Calendar and gallery views
  • Highlighting and formatting data
  • Basic JSON formatting (intro)

Module 5: Forms & List Customization 

  • Customizing list forms
  • Improving usability and data entry
  • Introduction to Power Apps (optional overview)
  • Conditional formatting basics

Module 6: Permissions & Security

  • SharePoint permission levels
  • List-level vs item-level permissions
  • Sharing lists with users and groups
  • Best practices for data security

Module 7: Automation with Power Automate 

  • Introduction to Power Automate
  • Creating simple workflows:
    • Email notifications
    • Approval workflows
  • Trigger-based automation from SharePoint lists
  • Workflow best practices

Module 8: Integration with Microsoft 365 

  • Using SharePoint lists in Microsoft Teams
  • Exporting and syncing with Excel
  • Email alerts via Outlook
  • Collaboration scenarios

Module 9: Best Practices & Governance 

  • Designing efficient and scalable lists
  • Naming conventions and standardization
  • Performance considerations
  • Governance and lifecycle management

Module 10: Hands-On Workshop 

  • Build a complete SharePoint solution:
    • Custom list creation
    • Columns and views
    • Permissions setup
    • Basic automation workflow
  • Use case examples:
    • Task tracker
    • Issue log
    • Approval system
  • Presentation and feedback

 

 

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy