Create workbook links - Microsoft Support
Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use Magnifier to make things on the screen easier to see
If you are using a mouse, select Start > Settings > Accessibility > Magnifier.Select View, and then open the Keep the mouse pointer or Keep the text cursor drop-down menu, and select how Magnifier behaves when the mouse pointer or text cursor move around the screen. This is something you should experiment with to see which combination works best for you.
View a presentation without PowerPoint - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint Mobile
Camera doesn't work in Windows - Microsoft Support
Test your camera with the Camera app. Select Start , then choose Camera from your apps. If you're asked to allow access to the Camera, select Yes.If the camera works in the Camera app, the problem might be with the app you're trying to use.
Open and close Outlook Data Files (.pst) - Microsoft Support
Note: Depending on how Outlook is set up, it's likely the folder where the .pst file is stored will open automatically.If it doesn't, browse to the file's location. If you're not sure where your Outlook data file is located, see Locating the Outlook data files.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Edit a PDF - Microsoft Support
To edit a PDF, open it in Word. This works best with PDFs that are mostly text. PDFs of book chapters or something that looks like a manuscript from a copier won't be formatted well in Word.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
View your system info - Microsoft Support
Type info in the search box on your taskbar, and then select System Information.
SUMIFS function - Microsoft Support
Argument name. Description. Sum_range (required). The range of cells to sum. Criteria_range1 (required). The range that is tested using Criteria1.. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.. Criteria1 (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, Excel Web App
Organize your ideas with Collections in Microsoft Edge
Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you left off the last time you were browsing the internet.
Remove specific prevalent malware with Windows Malicious Software ...
Microsoft generally releases the MSRT on a monthly cadence as part of Windows Update or as a standalone tool. (For exceptions, see Skipped releases.)Use this tool to find and remove specific prevalent threats and reverse the changes that they made (see Covered malware families).For comprehensive malware detection and removal, consider using Windows Defender Offline or Microsoft Safety Scanner.