The Complete SharePoint 2019 Advanced Technical Course

Implement a SharePoint real life project by creating essential documents and executing migration, QA, go live, support, and governance plans within a fictitious company.

Learn how to add a weather web part to a SharePoint communication site, configure multiple cities, switch temperature units, and publish changes for user-specific views.

Learn to insert a world clock web part on a SharePoint 2019 page, edit its title and location names, and restore or discard changes using version history.

Learn to configure a call to action web part in SharePoint Online, including text, background image, button label, link, and alignment to drive user actions.

Create a form in Microsoft Forms, copy the URL, and insert it into a SharePoint page as a web part so users can submit responses directly within SharePoint.

Create your first SharePoint team site, name it, set its privacy to private, and configure the site address, description, language, and members.

Configure a communication site to resemble a team site, adjust top navigation and left-side navigation, add a full-width image, and a countdown timer with a call-to-action to register.

Learn to manage edits with check out and check in in a SharePoint document library, preserve version history, and discard checkout to revert changes or add check-in comments.

Explore SharePoint site contents to view and manage libraries, lists, and items, accessible via settings or left navigation, and understand its role for migration and inventory.

Learn three methods to import an Excel spreadsheet into SharePoint—from the spreadsheet web part to the import spreadsheet app—mapping headers to list columns and selecting ranges.

Export an Excel sheet to SharePoint by formatting data as a table, exporting to a SharePoint list, and managing a read-only connection with live refresh and the option to unlink.

Import excel data into an existing SharePoint list using a saved Excel file, formatted as a table, then automate the import with Power Automate.

Learn to automate SharePoint list updates by creating a manual trigger flow that imports Excel data into a SharePoint list, mapping name and age to existing fields.

Explore two ways to add a user to a SharePoint site or group: share the site only or add as a group member with edit, read, or full control.

Customize the top navigation on your SharePoint site by adding, editing, or removing links. Learn to connect pages like the corporate wiki for quick access from the top bar.

Create a project site from a project site template, configure its name, description, and navigation, set permissions to match the parent, and add tasks, calendars, and sharing for team collaboration.

Learn to add comments in SharePoint via Microsoft Teams, create teams from a SharePoint site, upload files, and post conversations that accompany traditional comments for Office and non-office files.

Create a form in minutes with Microsoft Forms by adding questions, choosing form or quiz, customizing a theme, sharing to collect responses, and analyzing results in BI reports.

Create a SharePoint communication site to broadcast information to a broad audience. Use a responsive hero web part to feature up to five items with images, text, and links.

Learn how to create a blank SharePoint communication site named corporate communication, add a hero web part, upload five images from lab two, then edit and republish the page.

Create a team site from the SharePoint admin center without an Office 365 group, choose a template, name the site, and finish the creation process.

Create a SharePoint team site from an Outlook group to start conversations, share files, upload documents, and connect apps for integrated Outlook and SharePoint collaboration.

Learn to create unique permissions for a SharePoint library by stopping inheritance, assigning targeted access to groups like ABC owners and HR managers, and testing and documenting changes.

Learn to create and customize a SharePoint 2019 permissions level, including adding a new level, copying existing levels, and assigning to users for site administrator tasks.

Add Joe Phillips as the site collection administrator and review site owners with full control, then manage permissions in the SharePoint Admin Center and remove him if required.

Create a SharePoint page, add an image gallery web part, and set a carousel with a 2–3 second transition; copy images from the library and publish the slideshow.

Delete a SharePoint site or subsite via site information or view all site settings, and restore from the site collection recycle bin if needed.

Add a unique identifier (ID column) to SharePoint lists and libraries, enabling auto increment, modern and classic views, renaming to Location ID, and saving the view.

Learn to apply a SharePoint site template to tailor communication and team sites for your organization, including new employee onboarding templates with previews and customized tasks.

Learn to create and manage a SharePoint term store, build term sets for vendor names, and enforce consistent data entry with metadata managed columns and taxonomy.

Explore the Office 365 admin center, add a user with an auto generated password, assign a user role, and review active users before opening the SharePoint admin center.

Learn to access and interpret the site usage report in SharePoint online, tracking unique viewers and visits over 7, 30, and 90 days, with top files and external sharing.

Access the organization profile in admin, edit company details such as name, address, phone, and technical contact, and adjust release preferences from standard to targeted releases for selected users.

Enable or disable the comments section on a modern SharePoint site page using site-level edits or global admin settings in the SharePoint admin center.

Navigate the SharePoint admin center to manage user profiles, edit and map user properties, and search for a user to update or create profiles within the SharePoint Online service.

Learn to monitor updates from Microsoft 365 and other vendors using the message center in the Microsoft 365 admin center, filter to SharePoint specifics, and manage preferences and mobile access.

Explore how to view and manage SharePoint site storage, set storage limits (automatic to manual), and monitor library usage with the storage matrix and alerts.

Generate a site storage report with PowerShell by authenticating to SharePoint Online, connecting to the admin center, and exporting a CSV of site name, quota, usage, and percentage used.

Explore how SharePoint information architecture structures parts for understandability, and apply these principles in a hands-on lab to help users find what they seek online and offline.

Explore SharePoint information architecture and hub sites for a flexible, flat site structure. See how hub sites unify navigation and branding across sites to meet evolving needs.

Create a hub site in the admin center, register it, and associate other sites to share navigation and branding across the collection.