Course Outline
Session 1: Introduction to SharePoint
An overview of SharePoint and its primary features
Differentiating between Team sites and Communication sites
Navigating the SharePoint interface: menus, pages, and main sections
Managing permissions and user access
Integrating SharePoint with other Microsoft 365 applications
Session 2: Document Libraries in SharePoint
Setting up and customizing document libraries
Implementing version control and reviewing document revision history
Configuring permissions within document libraries
Utilizing metadata for efficient organization and search
Automating approval workflows for documents
Session 3: SharePoint Lists
Understanding SharePoint lists and their distinction from document libraries
Creating custom lists and applying templates
Enhancing collaboration through list views, filters, and grouping
Implementing calculated and conditional columns
Connecting SharePoint lists with Power BI for reporting purposes
Session 4: SharePoint and Power Automate
Developing approval workflows for document management
Automating notifications for updates in libraries and lists
Transferring form data from Microsoft Forms to SharePoint
Synchronizing data between SharePoint and other applications (e.g., Excel, Planner)
Handling errors and exceptions within workflows
Session 5: SharePoint and Power Apps
Building a Canvas app based on a SharePoint list
Inserting and modifying SharePoint data directly via Power Apps
Tailoring forms for lists and libraries
Leveraging Power Apps components for advanced user interactions
Deploying and sharing the application with users
Session 6: Project Review
Presentation of a project developed using SharePoint
Assessment of permission settings and site architecture
Optimizing automated processes created with Power Automate
Gathering participant feedback on the solution
Suggesting enhancements for future deployments
Requirements
Intended Audience:
Team leaders and business users responsible for managing or contributing to SharePoint content.
Project coordinators, as well as HR, marketing, or operations professionals engaged in document workflows.
IT specialists who support internal users or configure Microsoft 365 environments.
Individuals interested in leveraging Microsoft 365 tools to automate business processes.
Prerequisites:
Basic digital proficiency: Participants should be at ease with web browsers and Microsoft Office applications (such as Outlook, Word, and Excel).
Familiarity with Microsoft 365: Previous experience with Microsoft Teams or OneDrive is beneficial, although not essential.
No coding expertise required: This course is tailored for non-technical users; however, optional exercises involve basic logic development in Power Automate and Power Apps.
Testimonials (1)
Very clear, very instructive, very encouraging.