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.

Learn how to create a SharePoint blog as a subsite, configure blog template, set navigation, manage categories and posts, customize layout to boxed or basic, and share your new blog.

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 disable the new folder command in a SharePoint library via the edit new menu or advanced settings, turning off folder creation.

Sync a SharePoint library to OneDrive for offline work and automatic updates. Sign in to OneDrive and manage local folders so changes sync back to SharePoint.

Learn five ways to add comments in SharePoint—from office documents in a browser to non-office files—plus metadata column, version history, and via Microsoft Teams.

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.

Bring an Excel spreadsheet into SharePoint as a new list using the import spreadsheet app, selecting the file and range to import locations and managers.

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 to create a SharePoint 2019 communication site with a hero web part, choosing topic, showcase, or blank designs, and explore the predefined layouts and content sections.

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 your first SharePoint document center site for archiving by building a classic document management center from the admin center and configuring the site name, URL, and administrator.

Convert a classic SharePoint page to a modern experience by creating a new private site collection, then build and publish a modern home page.

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 picture library, upload images, switch views to thumbnails or tiles, and share, download, or copy links to collaborate across your site.

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.

Configure a new employee onboarding template on a SharePoint 2019 communication site, rename the site, build pages, and connect onboarding checklists, payroll links, and connections to Teams and Yammer.

Explore third-party tools like Sword Point to enhance SharePoint design, learn to install via app catalog, deploy to sites, and configure for modern and classic pages.

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.

Create a new private site collection in the SharePoint admin center by selecting a team site template with a classic experience and setting the title and the URL.

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.