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.
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
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
What Microsoft 365 business product or license do I have?
After your organization signs up for Microsoft 365, the admin can assign different Microsoft 365 licenses to each user account. The different licenses include different services, such as SharePoint in Microsoft 365 and Skype for Business Online. See the different Office 365 for business plans. Note: This topic is for Microsoft 365 for business.
Applies To: Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 Germany - Enterprise
Find your Office product key - Microsoft Support
Find your Office product key. Office 365 Office 2019 Office 2016 Office 2013. Many tasks for Office products don't require a product key because your Microsoft account takes care of them instead. Using product keys with Office.
Use Microsoft Teams for work or school in Windows 11
Taskbar icon. Apps. Check your version of Teams. For Microsoft Teams (free), select Settings and more > Settings > About Teams , then look under Version to see if you have the latest version or need to Update now. For Microsoft Teams (work or school), select Settings and more > About, then look under Version.
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
How to earn Microsoft Rewards points - Microsoft Support
Here are some of the ways you can earn Microsoft Rewards points: Search with Bing *. Search the web through the search box on the taskbar on your Windows 10/11 device. Buy stuff from Microsoft Store online (from your mobile device, on Xbox One, in the Microsoft Store app on your Windows 10/11 or Windows 8.1 device, or via the web). For more ...
Applies To: Microsoft account dashboard
Use the Microsoft Wireless Display Adapter - Microsoft Support
Here are some things to know before you start using your adapter: The adapter works best if you have both an HDMI port and a USB charging port on your HDTV, monitor, or projector.
ピボットテーブルを作成してワークシート データを分析する - Microsoft サポート
集計方法. 既定では、[ 値] 領域に配置されたピボットテーブル フィールドは SUM として表示されます。 Excel がデータをテキストとして解釈すると、データは COUNT として表示されます。 これが、値フィールドのデータ型が混在していないことを確認することがとても重要である理由です。
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
Upgrade Windows Home to Windows Pro - Microsoft Support
To upgrade from Windows 11 Home to Windows 11 Pro manually, first check which edition you’re running and your activation state: Select Start > Settings > System > Activation. At the top of the Activation page, you see your edition: either Home or Pro. You‘ll also see if you’re activated under Activation state . Open Activation settings ...
Scan a document or picture - Microsoft Support
A scanner you've connected using a wired, wireless, or network connection. An app for scanning files, such as Windows Scan, available for free from Microsoft Store. The Windows Scan app can help you scan pictures or documents and save them to your PC as JPEG, bitmap, or PNG files. For more info, see Install and use a scanner in Windows.