Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.

Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.

Go to Settings > Apps > Apps & features to change whether you're shown app recommendations when trying to install apps from outside the Store.

By importing a snapshot of your Google calendar into Outlook, you can see it alongside other calendars in the Outlook Calendar View. To keep the imported calendar up-to-date, subscribe to the Google Calendar in Outlook.

The View in File Explorer command uses a temporary folder that opens in File Explorer.That folder only lasts until you close it and the content is saved to SharePoint. So using View in File Explorer gives you one-time access to the SharePoint library by way of your desktop folders. By default, the View in File Explorer menu option will not be visible to you or users in the SharePoint modern ...

Note: If you start to play a DVD or VCD in the Player Library, the Player automatically switches to Now Playing mode. The Blu-ray Disc format is not supported in Windows Media Player. To play a Blu-ray Disc, you need to use a non-Microsoft program that supports Blu-ray playback and a device capable of reading Blu-ray Discs.

Alternatively, you can install any website by going to the top corner of the browser and select Settings and more … > Apps > Install this site as an app.

=RAND()*(b-a)+a. If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number. The formula will calculate and leave you with just a value.

Keys with an Fn key or F Lock provide two sets of commands for many keys. This includes the top row of standard function keys (F1–F12). Standard commands are labeled on the front of the keys (such as F3).

Track your tasks in My Tasks. Planner offers a purpose-built My Tasks view, designed to centralize all the tasks relevant to you. My Tasks is organized into four distinct views, each serving a unique purpose: Private tasks: Private tasks is a place for you to quickly jot down tasks at the speed of thought.This is a place where you can create tasks that do not belong to a plan yet.