Zip and unzip files - Microsoft Support
To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.
LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Microsoft Authenticator FAQs - Microsoft Support
Verified IDs are secure trusted credentials that can be used by websites and organizations to make account setup simpler and safer. Usually, you'll use your device's camera to capture a QR code on the site to get a new Verified ID, or a verification of an ID already on your device.
Use the Tasks app in Teams - Microsoft Support
List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.
Applies To: Microsoft Planner, Microsoft Teams, Microsoft To Do
Block or allow (junk email settings) - Microsoft Support
Safe senders and recipients. Safe senders are people and domains you always want to receive email messages from. Safe recipients are recipients that you don't want to block, usually groups that you’re a member of.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create a presentation in PowerPoint - Microsoft Support
Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Record a slide show with narration and slide timings
The slide show opens in the Recording window (which looks similar to Presenter view), with buttons at the top left for starting, pausing, and stopping the recording.Click the round, red button (or press R on your keyboard) when you are ready to start the recording. A three-second countdown ensues, then the recording begins.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016
Set up the Outlook app for iOS - Microsoft Support
Follow the procedure in the Set up access to your company resources article to enroll your iOS phone or tablet. Important: Once you begin the enrollment process, you should complete the process in its entirety since pausing for more than a few minutes usually stops your progress and requires you to start over.If this process should fail, you need to return to the Company Portal app to try again.
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 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook for iOS
Create a new workbook - Microsoft Support
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013