Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF (C2=”Yes”,1,2) says IF (C2 = Yes, then return a 1 ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Upload and save files and folders to OneDrive - Microsoft Support
Select the files you want to upload and drag them to OneDrive in the File Explorer Navigation pane. Save a file to OneDrive. Select File > Save a Copy > OneDrive - Personal. Select Enter file name here and type a name. If you want to save to another folder, select Browse, and select the folder you want. Select Save.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Search indexing in Windows 10: FAQ - Microsoft Support
Indexing is the process of looking at files, email messages, and other content on your PC and cataloging their information, such as the words and metadata in them. When you search your PC after indexing, it looks at an index of terms to find results faster. When you first run indexing, it can take up to a couple hours to complete.
Overview of formulas - Microsoft Support
1. Functions: The PI () function returns the value of pi: 3.142... 2. References: A2 returns the value in cell A2. 3. Constants: Numbers or text values entered directly into a formula, such as 2. 4. Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.
Applies To: Excel for the web
連結專案中的任務 - Microsoft Support
連結任務. 選擇 [ 檢視 > 甘特圖] 。. 按住 Ctrl,並選取您想要連結的兩項任務 (位於 [任務名稱] 欄中)。. 選擇 [任務 > 連結任務] 。. 若要移除連結,請選取兩個連結的工作,然後選擇 [ 任務 > 取消連結任務 ] 。. 根據預設,Project 會建立簡單的 完成-開始 任務連結 ...
Applies To: Project Online Desktop Client, Project Professional 2021, Project Standard 2021, Project Professional 2019, Project Standard 2019, Project Professional 2016, Project Standard 2016
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Redeem a gift card or code to your Microsoft account
How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.
Applies To: Microsoft account dashboard
How to use the PC Health Check app - Microsoft Support
How to open PC Health Check. In Windows, use Search on the taskbar to search for “PC Health Check,” then select it from the list of results. If a PC Health Check update is available, you can quickly install it for the latest version. If you don't have PC Health Check installed, you can install it by going to https://aka.ms ...
新增前置重疊時間或延隔時間至任務 - Microsoft 支援服務
若要增加延遲時間,請輸入正數或百分比 (例如 2d) 。. 延隔時間會在兩個具有相依性的工作之間造成延遲。 例如,如果您想要在第一個任務結束和第二個任務開始之間延遲 2 天,請在兩個任務之間 建立完成-開始相依性 ,然後在第二個任務開始之前加上 2 天的延遲時間。
Applies To: Project Online Desktop Client, Project Professional 2021, Project Standard 2021, Project Professional 2019, Project Standard 2019, Project Professional 2016, Project Standard 2016
行から列、または列から行にデータを入れ替える (配置の転換)
Windows Web. 列にデータを含むワークシートがあり、行内で並べ替えるために回転する必要がある場合は、 トランスポーズ 機能を使用します。. これを使用すると、データをすばやく列から行に切り替えることができます。. またはその逆も可能です ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016