How to use the FILTER function in Excel to filter a range of data based on criteria you define.

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Training: With OneDrive, you can sync files between your computer and the cloud, so you can get to them from anywhere.

Add an easy to maintain Table of Contents using heading styles that automatically updates when you make changes to your headings.

The Planner app in Microsoft Teams brings together all your tasks and plans across the Microsoft 365 ecosystem in a single convenient location. It helps you manage tasks more efficiently for individual plans and team initiatives, as well as larger scale projects that are aligned to goals and key strategic objectives.

Search for files. Looking for an older file? Search is a powerful tool to find all your online files. Type a word or phrase in the Search box.

Learn how to change the refresh rate for your display in Windows to determine how smoothly motion appears on your screen.

Try it! Microsoft 365 subscribers can set up automatic replies for when they are out-of-office or unavailable to respond to email. Select File > Automatic Replies.

See a list of options available for starting Windows in diagnostic modes such as safe mode.

Use Excel to create a chart from scratch or with recommended charts. Learn how to add a trendline and customize your chart style.