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.

Give your template a name and in the Save as type drop-down, select Outlook Template (*.oft).

Creating a passkey. To create a passkey for your Microsoft account, follow these steps on the device for which you’d like to create a passkey:

To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. The following process assumes that you already have the message you intend to send created and open in Microsoft Word.

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.

Training: Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts with these handy cheat sheets for Microsoft Office.

The default templates folder is opened. The folder location (in Windows 7 and later operating systems) is c:\users\username\appdata\roaming\microsoft\templates.If your template is saved in a different folder, click Browse, and then select the template.

With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.

Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).

Certificate authority (CA) A certificate authority is an entity similar to a notary public.It issues digital certificates, signs certificates to verify their validity and tracks which certificates have been revoked or have expired.