In a Teams channel, click + to add a tab → SharePoint. Browse to the site and you'll see both document libraries and lists — select the list you want. Team members can view and edit it directly in Teams without switching to a browser.
Wiki
Get notified in Teams when a file in a SharePoint library is changed
In the document library, select the file → three dots → Alert me. Set the frequency (instant, daily, or weekly) and the notification goes to your email. For a Teams notification instead, use the Automate button at the top of the library → Create a rule → A file is...
Use the Button web part to add a prominent call-to-action link on any page
Edit the page → click + to add a web part → search for Button. Add your label and URL, then choose alignment and style. The Button web part renders as a clean, styled link — much more noticeable than a bare hyperlink buried in a paragraph.
Save a page as a template so every new page starts with the right layout
Open the page you want to use as a starting point → click the three dots (⋯) in the top toolbar → Save as template. Give it a name and description. When anyone clicks + New → Page on this site, your template appears in the picker alongside Microsoft's defaults.
Promote a news post from a subsite up to the hub so more people see it
If your sites are connected to a hub, news from any connected site appears automatically in the hub home's News web part — no extra step needed. To boost a specific post, open it → click Promote (the megaphone icon in the top toolbar) → Share to Teams or Send as email...
Schedule a news post to go live at a specific date and time
Create your news post as normal → instead of Publish, click the arrow next to it → Schedule. Pick the date and time you want it to go live. The post stays in draft until then — useful for announcements you write in advance or want to time for a Monday morning.
Export a SharePoint list to Excel for one-off offline analysis
At the top of any list, click Export → Export to Excel. SharePoint downloads a query file that opens in Excel and pulls in the current data. The connection stays live — right-click inside Excel → Refresh to pull the latest list data at any time without...
Group list items by a column to make long lists scannable
Click the header of the column you want to group by → Group by [Column name]. Rows collapse into expandable sections, making it easy to scan by status, department, or owner. To remove grouping, click the same column header → Remove grouping. Save it as a view to share...
Create a list alert so you get an email when a specific item changes
Select a list item → three dots → Alert me. Choose whether you want an alert for any change or only specific ones (e.g. changes by others, or changes to a particular column), and set the frequency to instant, daily, or weekly digest. Alerts are built in — no Power...
