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.

A "Transform File" function query uses the "Parameter1" query to specify each file (or binary) as input to the "Sample File" query. This query also creates the Content column containing the file contents and automatically expands the structured Record column to add the column data to the results. The "Transform File" and "Sample File" queries are linked, so that changes to the "Sample File ...

Group items manually or create a custom group. On the View menu, in the Current View group, select Change View, and then select Save Current View As a New View.

You can insert the current date and time in an Excel cell as static values or as dynamic values. A static value is one that doesn’t change when the worksheet is recalculated or opened. A dynamic value is one that is updated each time formulas are recalculated.

For Windows 8 or Windows 8.1, swipe in from the right edge of the screen, and tap Search. If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, and click Search.Type File Explorer in the search box, and then tap or click File Explorer.

Occasionally, dates may become formatted and stored in cells as text. For example, you may have entered a date in a cell that was formatted as text, or the data might have been imported or pasted from an external data source as text.

As you browse the web, you'll see an icon in the address bar that indicates the security of the connection to the site you're visiting. This icon helps you determine if you can safely send and receive information from the site.

Record Teams meetings to reference later or share with others. Meeting recordings capture audio, video, and screen sharing activity, and can be shared securely across your organization.

An administrator might have customized the settings for your Temporary Internet Files folder to prevent you from changing the settings. For example, the administrator can remove the General tab from the interface in the Internet Options dialog box. If you cannot access the Internet Options dialog box or the General tab, contact your administrator for more information.

Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.