Create and share a Dashboard with Excel and Microsoft Groups
Create PivotCharts. Click anywhere in the first PivotTable and go to PivotTable Tools > Analyze > PivotChart > select a chart type. We chose a Combo chart with Sales as a Clustered Column chart, and % Total as a Line chart plotted on the Secondary axis. Select the chart, then size and format as desired from the PivotChart Tools tab.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Map a network drive in Windows - Microsoft Support
Open File Explorer from the taskbar or the Start menu, or press the Windows logo key + E. Select This PC from the left pane. Then, on the File Explorer ribbon, select More > Map network drive. In the Drive list, select a drive letter. (Any available letter will do.)
Quick start: Create a macro - Microsoft Support
Record a macro. In the Code group on the Developer tab, click Record Macro. Optionally, enter a name for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording. Perform the actions you want to automate, such as entering boilerplate text or ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2016 for Mac, Excel 2013, Excel 2010
Using tags in Teams - Microsoft Support
Team owners can choose which members of their team are allowed to add tags. Select Teams on the left side of the app, and find your team in the list. Go to More options , select Manage team , choose the Settings tab, and then navigate to the Tags section. Here you can control whether team members or team owners can manage tags.
Applies To: Microsoft Teams
Sign in to SharePoint - Microsoft Support
Sign in to SharePoint. SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint. Tip: If you don't see the SharePoint app under All apps, use the Search box near ...
Applies To: SharePoint in Microsoft 365
How do I create macros? - Microsoft Support
In the list under the button that you want to reassign, select Macro. Click Create a new Macro. An empty macro is created and added to the macro list. In the Name box, type the name of the new macro. Click in Editor, and enter your macro. You can record events such as keystrokes, mouse clicks, and delays between actions.
What's new in recent Windows updates - Microsoft Support
What's new in recent Windows updates. Windows 11 Windows 10. New features in recent Windows updates will help you customize your PC, increase security, and get more creative with Windows. With these updates, it'll also be easier to get things done on your PC and across your other devices, including syncing to Android phones (7.0 or later).
A file is in a different format than its extension indicates in Excel
When you open a file in Excel, you get an message that the file name extension doesn't match the actual file format. For example, the file has an .xlsx file name extension but it's really a text file and should have a .txt file name extension. Before you click Yes to open the file, you may want to consider the reasons why the file might have an ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Starter 2010
Analyze the wireless network report - Microsoft Support
To create the wireless network report. In the search box on the taskbar, type Command prompt, press and hold (or right-click) Command prompt, and then select Run as administrator > Yes. At the command prompt, type netsh wlan show wlanreport. This will generate a wireless network report that’s saved as an HTML file, which you can open in your ...
PC is charging slowly or discharging while it’s plugged in
When your PC is plugged in, you might see a status message that says your PC is charging slowly or discharging when you hover over or select the Battery icon on the taskbar. This might happen if you’re using a charger that didn’t come with your device. To speed up charging, use the charger and cable that came with your device. The charger ...