Create a template - Microsoft Support
Tip: To change where your application automatically saves your templates, click File > Options > Save and type the folder and path you want to use in the Default personal templates location box. Any new templates you save will be stored in that folder, and when you click File > New > Personal, you'll see the templates in that folder.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Visio Standard 2016
Recovery options in Windows - Microsoft Support
Info for Windows Insiders. If you’re an Insider and the current preview build isn’t working for you, select Start > Settings > System > Recovery .Next to Go back , select Go back.This won’t remove your personal files, but it’ll remove recently installed apps and drivers, and change settings back to their defaults.
How to adjust power and sleep settings in Windows
To adjust power and sleep settings in Windows 10, go to Start , and select Settings > System > Power & sleep.. Under Screen, select how long you want your device to wait before turning the screen off when you're not using your device.
Give your PC a Fresh Start - Microsoft Support
To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings
Set up your Microsoft 365 sign-in for multi-factor authentication
By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.
Applies To: Office for business, Microsoft 365 admin
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
Upgrade to Windows 10 Pro - Microsoft Support
Windows 10 Pro offers more advanced security and business networking features, including: BitLocker Drive Encryption
Install the Language Accessory Packs for Office 2016
Install language accessory packs after installing Microsoft Office, to add additional display, help, or proofing tools. Install the language accessory pack for your desired language.
Change your default search engine in Microsoft Edge
Keeping Bing as your default search engine provides an enhanced search experience in the new Microsoft Edge , including direct links to Windows apps, relevant suggestions from your organization if you’re signed in with a work or school account, and instant answers to questions about Windows.However, you can change the default search engine to any site that uses OpenSearch technology.
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 IF 函数成对使用。
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 Web App, Excel for Windows Phone 10