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.

Gebruik uw Microsoft-account om u aan te melden bij Microsoft-services zoals Windows, Microsoft 365, OneDrive, Skype, Outlook en Xbox Live.

Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.

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.

Add your work or school account. On your computer, note the Code and Url information on the Configure mobile app page.Keep this page open so you can see the code and URL.

Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, select Excel Add-ins and then click Go. If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.

Find out how to get a DVD player app, add-on, or plug-in, or whether you can upgrade your edition of Windows to add DVD playback.

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.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

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.