Microsoft® SharePoint® Modern Experience: Site Owner with Power Platform

In this course, you will create a SharePoint team site and a communication site, connect them with a hub site, create custom page layouts, perform advanced tasks in libraries and lists, and integrate a Power Apps custom application with SharePoint.

Description

Microsoft® SharePoint®, in conjunction with the Microsoft 365 suite of productivity and office automation tools, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. By default, SharePoint provides end users with a generous set of permissions, enabling users to create and customize their own sites as site owners, and create and collaborate on team site content. Users who have grown comfortable with these fundamental content-authoring capabilities may want to move on to more advanced features, such as connecting multiple SharePoint sites through a hub, importing list data from external sources, implementing user input validation features, applying conditional formatting, and using Power Apps® to provide custom user interfaces for data collected in SharePoint. This course focuses on issues related to planning and implementing an intranet with multiple communication sites and team sites interconnected through a hub site to provide unified navigation search, and formatting.

You will:

  • Plan and create a SharePoint-based multi-site intranet, including team and communication sites.
  • Associate multiple sites with a hub site to provide unified navigation, search, and theme.
  • Use advanced SharePoint features to manage content creation in lists and libraries, including custom page templates and various methods to import data.
  • Configure lists with various input validation features to improve the quality of data entry and presentation.
  • Use Power Apps Studio to create a custom user interface for entering data in a SharePoint list.

Target Student:

This course is designed for Microsoft SharePoint site users who are already comfortable using SharePoint as a site user (site visitor or site member), but who want to advance to creating new sites and integrating them with features like Power Apps.

Prerequisites:

To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. You should also have basic SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You can obtain these skills by taking the following Logical Operations courses:

  • Using Microsoft® Windows® 10 (Second Edition)
  • Microsoft® 365 Office for the Web (with Teams®)
  • Microsoft® SharePoint® Modern Experience: Site Basics

Course Content:

Lesson 1: Setting Up a Multi-Site Intranet

Topic A: Plan Your Organization’s Intranet

Topic B: Create and Configure SharePoint Sites

Lesson 2: Connecting Sites to a Hub

Topic A: Create a Hub to Connect Multiple Sites

Topic B: Apply a Site Template

Topic C: Change Site Themes and Navigation

Lesson 3: Populating a Site with Content

Topic A: Create Custom Page Layouts

Topic B: Manage Library Files

Topic C: Manage List Data

Lesson 4: Improving List Data Entry and Presentation

Topic A: Limit What Users Can Enter

Topic B: Create Calculated Columns

Topic C: Use Formulas to Validate Entered Data

Lesson 5: Integrating a Power Apps Application with SharePoint Online

Topic A: Create a Power Apps Application

Topic B: Modify an App

Appendix A: Cleaning Up Unused Resources

Similar courses

Learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues.

More Information

This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. This course is for an on-premise SharePoint environment.

More Information

The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.

More Information

In this course, you will analyze and visualize data using Excel and associated tools.

More Information

Master the skills to create polished, professional technical documents with advanced formatting techniques that enhance consistency, efficiency, and usability

More Information

Using Data Analysis Expressions to solve common business problems in Power BI

More Information

In this course, you will use generative AI to assist you as you work with spreadsheets.

More Information

Use the advanced PivotTable functionality in Excel to analyze your raw data

More Information

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

More Information

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

More Information

Provides a foundation for Excel knowledge and skills

More Information

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

More Information

This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft® Office desktop applications. This course also introduces several productivity apps including Yammer™, Planner, and Delve® that can be used in combination by teams for communication and collaboration.

More Information

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

More Information

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

More Information

Analyze business data, visualize insights, and share those insights across the enterprise

More Information

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

More Information

Use Microsoft Project effectively and efficiently in a real-world environment.

More Information

In this course, you will use generative AI tools to help you develop text and images that you can use in your word processor or desktop publishing application.

More Information

Includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

More Information

You will learn fundamental Word skills

More Information

Tackle more advanced features of Word

More Information

Course Objectives: In this course, you will use a typical SharePoint team site to work collaboratively with other team members. You will: Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site.

More Information

Course Objectives: In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams.

More Information

Learn to streamline your email workflow with practical Outlook tools, including folder management, rules, advanced inbox customization, and search techniques, to achieve better organization and productivity.

More Information

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

More Information

In this course, you will develop and deploy VBA modules to solve business problems.

More Information

In this course, you will perform advanced site-building and administration tasks. You will: Create a custom site template to reduce the time spent creating similarly configured SharePoint sites. Configure managed metadata, including custom term sets, content types, and metadata-based navigation. Control access through permissions. Improve overall security of sites, lists, libraries, folders, list items, and documents.

More Information

In this course, you will analyze and visualize data using Excel and associated tools. You will:: - Perform data analysis fundamentals. - Visualize data with Excel. - Analyze data with formulas and functions. - Analyze data with PivotTables. - Present visual insights with dashboards in Excel.

More Information