Insert ASCII or Unicode Latin-based symbols and characters
Inserting ASCII characters. To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad.
Applies To: Excel for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Publisher for Microsoft 365, Excel 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
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 your Windows PC as a mobile hotspot - Microsoft Support
Turn your Windows PC into a mobile hotspot by sharing your internet connection with other devices over Wi-Fi. You can share a Wi-Fi, Ethernet, or cellular data connection.
如何使用电脑健康状况检查应用 - Microsoft 支持
注意: 如果设备上发现兼容性问题会中断使用 Windows 11 的体验,我们会暂时延迟升级,直到问题得到解决。兼容性保障措施有助于确保在升级时获得最佳体验,并且当关键应用或驱动程序尚不兼容时,工作效率不会中断。
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.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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 2016
Use Microsoft Translator in Microsoft Edge browser
If you open a page written in a different language than your preferred languages in settings, Microsoft Edge will automatically prompt you to translate it. The Translate icon appears in the address bar when you go to a web page that’s written in a foreign language. A language is considered foreign to you if it's not included in your Preferred languages list in Settings.
Applies To: Microsoft Edge
将数据从行转置到列,或将数据从列转置到行 - Microsoft 支持
如果有一个工作表,其中列包含数据,需要旋转才能按行重新排列它,请使用 “转置” 功能。 使用它,可以快速将数据从列 ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Connect to a projector or PC - Microsoft Support
When you're in a conference room and need to project, connect your PC using one of the cable connectors in the room, press the Windows logo key + P, and then choose one of the four options:. PC screen only.