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.
SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Mouse and Keyboard Center download - Microsoft Support
Mouse and Keyboard Center download. The Microsoft Mouse and Keyboard Center is an app that helps you make the most out of your Microsoft keyboard and mouse. Mouse and Keyboard Center helps you personalize and customize how you work on your PC. This app is not available for Windows S mode . Download the latest release of Mouse and Keyboard ...
使用 Excel 公式计算还款和存款 - Microsoft 支持
使用函数 PMT (rate、NPER、PV) =PMT (5%/12,30*12,180000) 结果是每月支付 (不包括保险和税款) 966.28 美元。. 利率参数是 5% 除以一年中的 12 个月。. NPER 参数是 30*12,即 30 年按揭付款,每年付款 12 期(按月付款)。. PV 参数是 180000(贷款的现值)。. 了解如何每月为梦想 ...
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, Excel 2013, Excel Mobile
CONCATENATE function - Microsoft Support
Use the TEXT function to combine and format strings. The TEXT function converts a numeric value to text and combines numbers with text or symbols. For example, if cell A1 contains the number 23.5, you can use the following formula to format the number as a dollar amount: =TEXT (A1,"$0.00") Result: $23.50.
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
在 Windows 中如何获取帮助 - Microsoft 支持
以下是查找 Windows 帮助的多种不同方法: 搜索帮助 - 在任务栏上的搜索框中输入问题或关键字,以查找应用、文件和设置并从 Web 获取帮助。
Activate Office - Microsoft Support
Select your version of Microsoft 365 below to learn how to activate Microsoft 365. Activate Microsoft 365 or a non-subscription version of Office. Activate Office that's pre-installed on a new Windows device. Activate an Office purchase or offer that's included on a new Windows device. Activate Office from Microsoft Workplace Discount Program.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
Open the Camera in Windows - Microsoft Support
Windows 11 Windows 10. To open up your webcam or camera, select the Start button, then select All apps, and then select Camera in the list of apps. If you have multiple cameras, you can switch between them by selecting Change Camera at the top right once the Camera app is opened. Open Camera.
File sharing over a network in Windows - Microsoft Support
Windows 11 Windows 10. Note: This article focuses on how to share files or folders over a Local Area Network (or LAN), such as connected computers within your home or workplace. If you are trying to find out how to share a file over the Internet, for example with a friend or family member, OneDrive provides easy ways to accomplish this. For ...
Add or manage an iCloud email account in Outlook
Add a new iCloud account. On the View tab, select View settings. Select Accounts > Email accounts. From the email accounts pane, select the option to add a new account. Select Add Account , in the Suggested account dropdown, enter the iCloud account you want to add, and select Continue. On Sync your iCloud account, select Continue.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows