
Set up and navigate SharePoint sites, manage documents, and leverage lists, libraries, and site pages with powerful web parts and permissions, plus Power Apps and Power Automate.
Learn how to set up a SharePoint team site and understand the team vs communication site distinction, including logging into office.com, choosing a site name, privacy, and roles.
Explore adjusting settings on a SharePoint team site, including site information and logo, applying themes, and navigating the quick launch panel with documents, conversations, notebooks, pages, and recycle bin.
Publish internal news posts or link to external updates on your SharePoint site, adding images and optional comments. Explore the activity feed and quick links.
Upload and manage documents in SharePoint using drag-and-drop or the upload option, create Word or Excel files via Word Online, auto-save to the site, and rename as needed.
Learn how to store tabular data in SharePoint by creating a custom list, adding an employee ID numeric column and a department choice column, and importing data.
Learn to export data to Excel, switch between modern and classic SharePoint views, and apply filters and sorts to a custom list to manage employee data.
Upload files to a SharePoint document library using drag and drop, notify teammates, and manage file properties with autosave, then use check out and check in to publish edits.
Enable versioning in a SharePoint document library and manage major versions, minor versions, content approval, and check-out. View version history and restore or revert to older versions.
Use quick edit to bulk edit documents in a spreadsheet-like grid, add the 'about the document' column, drag and drop files, and sort by a sequence number with folders first.
This lesson demonstrates creating a department choice type column, grouping documents by department, and saving a view to retain changes across sessions, with grouping taking priority over sorting.
Learn to create alerts in SharePoint that notify you of document edits by email or text. Configure alert conditions and delivery options, including immediate, daily, or weekly summaries.
Discover how to manage permissions in a SharePoint document library, including stopping inheritance, setting groups and visitors, sharing files with email invitations or links, and pinning top documents.
Create and save public list views in SharePoint to display chosen columns, filter IT department employees, sort by title, and apply across libraries.
Explore how to create and customize a SharePoint calendar: add events with titles, locations, times, descriptions, and categories, and set all-day or recurring schedules with end dates.
Explore SharePoint calendar features, switch between month, week, and day views, create focused views, sync with Outlook, export to excel, set alerts, and manage events including recurring ones.
Demonstrates adding a calendar and other apps to a SharePoint home page by inserting web parts, configuring an events calendar, displaying an employee list view, and publishing the page.
Create and customize site pages in SharePoint using the site pages library, including layouts, header options, and background images, then publish and add the page to navigation.
Learn to add sections and web parts on a SharePoint page, create two-column layouts, place text, images, and file previews, and adjust order and layout settings.
Delete and manage web parts and sections on a SharePoint page. Add a three-column section and explore web parts such as Yagmur, document library, Facebook page, and Twitter.
Update your SharePoint home by linking to a site page, hide the link text, and publish; learn to delete, restore, and recover pages from the recycle bin using version history.
Create and customize SharePoint web part page, select templates, and add calendars or document libraries. Compare web part pages with site pages and adjust image dimensions using the image viewer.
Create and customize a SharePoint wiki page by using the site contents and new wiki page option, editing text, inserting images, and pasting HTML to render templates.
Learn how to sync SharePoint libraries with OneDrive to access documents offline, choose which files to sync, set the local sync location, and understand per-user permissions.
Learn to create and reuse site columns in SharePoint to standardize fields across lists, such as adding a country dropdown and applying it to both employee data and projects lists.
Add an existing site column to employee data and projects lists, then update all lists simultaneously to reuse the country field across the SharePoint site.
Create and customize site and list content types in SharePoint, define a parent content type, and add columns such as title, country, employee ID, project ID, and team member allocated.
Create a new custom list in SharePoint, enable content type management, and add employee and project content types for structured data and dynamic views.
Create and manage sub sites within a SharePoint team site for different teams, using inherited or unique permissions and the site contents and sub sites tab to shape navigation.
demonstrate managing site permissions by owners, members, and visitors, using advanced settings to add or remove users, and grant internal access via everyone except external users.
Stop inheriting permissions and establish unique access on the sales sub site. Create visitors, members, and owners groups with edit, read, or contribute rights, and use them as email lists.
Enable access requests and route them to designated admins, with group-based approval, while managing site collections via advanced permission settings and master site collection administrators.
Explore the Power Platform basics—Power Apps, flows, and Power BI—and learn to build canvas and model-driven apps from templates or data sources.
As the corporate world adopts more remote working practices, the role of SharePoint as not just a document management tool but as a full collaboration tool is evolving.
More than ever, SharePoint is playing a significant role in the success of companies managing their everyday work.
Several of us experienced professionals at Earn and Excel collaborated and created a very practical and powerful training for SharePoint that will have you making the most of this brilliant tool for your team's needs.
We have added some training on Power Apps which works in conjunction with SharePoint