Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.

Tip: In Windows 7, you can synchronize your computer clock with an Internet time server to keep the computer clock up to date.To do this, select the date or time in the bottom right-hand corner of your screen, and then select Change date and time settings.Select the Internet Time tab, select Change settings, select Synchronize with an Internet time server, and then select Update now.

Choose Open all, or Open all in new window, or Open all in new InPrivate window.

将你的收藏夹保存在此处或将其拖拽到你希望的任何位置。 你还可以创建、删除或重命名”收藏夹”文件夹。

使 Excel 在检测到模式时可自动填充数据。 例如，年中的月份，月中的日期或数字序列。 此外，还可以分析数据（如拆分列中的名字和姓氏），或连接数据（如连接两列中的名字和姓氏）。

If you already have a Microsoft account that you use to sign in to other Microsoft services (such as Windows, Outlook, OneDrive, Office, MSN, and Skype), use that account to create your Xbox account as well.

Note: To create an email message using a keyboard shortcut, press Ctrl + Shift + M.

找到来自 Web 的动态 GIF. 也可以使用“插入联机图片”或“插入剪贴画”功能在 Web 上搜索 GIF，具体取决于 PowerPoint 版本。在功能区的“</c2>插入</c0>”选项卡上，选择“插入联机图片”或“插入剪贴画”。

When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports