Consolidate multiple worksheets into one PivotTable. Consolidating data is a useful way to combine data from different sources into one report. For example, if you have a PivotTable of expense figures for each of your regional offices, you can use a data consolidation to roll up these figures into a corporate expense report. This report can ...

Get the most out of your subscription with expert advice and support from small business advisors. Business Assist for Microsoft 365 is designed for small businesses to give you and your employees around-the-clock access to small business advisors as you grow your business, from onboarding to everyday use.

1 May 2023: Updated invalid characters and invalid file and folder names. 12 April 2021: Added 50,000 item sharing limits note. 3 March 2021: Maximum file upload size updated to 250 GB. 16 September 2020: Updated info about OneNote notebooks to clarify that the 2GB file size limit applies to SharePoint as well as OneDrive.

However, If you need more disk space on your PC, you can clear the cache manually. In the Search box on the taskbar, enter disk cleanup. Select the Disk Cleanup app from the list of results. On the Disk Cleanup tab, select the Delivery Optimization Files check box. Select OK. On the dialog that appears, select Delete Files. Manually clear the ...

Activate Windows using a product key. A product key is a 25-character code, that looks like this: PRODUCT KEY: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX. During installation, you'll be prompted to enter a product key. Or, after installation, to enter the product key, select the Start button, and then select Settings > System > Activation > Update product ...

Select Start Record. Go through the steps to reproduce the problem you’re trying to diagnose. You can pause and resume the recording at any time. (Optional) As you record, select Add Comment, use your mouse to select the part of the screen that you want to comment on, type your comment, and then select OK. When you’re done, select Stop Record.

To enable activity reporting and gain insight into their online habits, connect family members’ devices through Microsoft Family Safety. This feature allows family organizers to view certain web, search, app and game activity of another family member. This information is accessible through a web browser or the Family Safety app .

Copilot in Windows, with the help of Microsoft Copilot (previously named Bing Chat), provides you with centralized generative AI assistance directly from your Windows device. Copilot in Windows uses your data to help it formulate relevant responses to your requests. For example, that data can be the words that you type or speak when chatting ...

To reset your PC. Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, click Settings, and then click Change PC settings .) Tap or click Update and recovery, and then tap or click Recovery.

Add a web part. Go to the page where you want to add a web part. If you do not see the site page that you want, click Site contents on the Quick Launch bar, in the list of contents, click Site Pages, and then click the page that you want. If the page is not already in edit mode, click Edit at the top right of the page.