FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Create and save a PowerPoint template - Microsoft Support
On the View tab, in the Master Views group, choose Slide Master.. The slide master is the largest slide image at the top of the slide thumbnail list, to the left of your slides. Associated slide layouts are positioned beneath the slide master.
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Overview of PivotTables and PivotCharts - Microsoft Support
You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To: Microsoft Teams
Insert or delete rows and columns - Microsoft Support
Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Manage display language settings in Windows - Microsoft Support
The display language you select changes the default language used by Windows features, such as Settings and File Explorer. Select Start > Settings > Time & Language > Language.
Turn new message alert pop-up on or off - Microsoft Support
A Desktop Alert is a notification that appears on your desktop when you receive a new email message, a meeting request, or a task request. By default, Desktop Alerts are turned on.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
See what's on the Start menu - Microsoft Support
Get started. To pin your favorite apps to the Start menu, select and hold (or right-click) the app you want to pin. Then select Pin to Start .. To group your apps into folders, simply drag an app on top of another with mouse or touch or highlight the app with your keyboard and use the Ctrl + Shift + <Left or Right arrow> keyboard shortcut.. Your apps and programs—right at your fingertips
Insert data from picture - Microsoft Support
Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies.Just take a picture of each one, transfer the pictures to your computer (OneDrive is great for this). Then, click Data > From Picture > Picture From File and follow the on-screen instructions to convert picture to data.
Applies To: Excel for Microsoft 365
What version of Outlook do I have? - Microsoft Support
There are now two versions of Outlook for Windows: new Outlook for Windows and classic Outlook for Windows. To determine if the Outlook for Windows version you're using is new Outlook or classic Outlook, check if there's a File tab on the ribbon. If File doesn't appear, you're using new Outlook.If you have a File tab, you're using classic Outlook.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook Web App