Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Check your device performance and health in Windows Security
The Health report starts off by showing you the last time a Device Health scan was run. The time displayed should be basically the current time, as Windows Security tries to run a Device Health scan when you open the Device performance & health page.. Beyond the time of last scan you'll see the status of the key areas that Device Health monitors:
Microsoft アカウントのメール アドレスまたは電話番号を変更する
Microsoft アカウントに関連付けられているメール アドレスと電話番号は エイリアスと呼ばれ、同じ連絡先、オンライン ストレージ、サブスクリプション、アカウント設定を使用します。
Applies To: Microsoft account dashboard
Find out which version of Microsoft Edge you have
Open Microsoft Edge, select Settings and more (...), and then select Settings. Look for your version under About Microsoft Edge.
Insert WordArt - Microsoft Support
You might have tried using shape styles to change the shape of WordArt and then were puzzled that the text didn’t change. Use the text options in the WordArt Styles group instead. Shape styles and effects apply to the box and background surrounding your WordArt, not to the WordArt text.
Applies To: Excel for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Outlook 2021, PowerPoint 2021, Excel 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Outlook 2019, PowerPoint 2019, Excel 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Outlook 2016, PowerPoint 2016
Add or change a VPN connection in Windows - Microsoft Support
A virtual private network (VPN) connection on your Windows 10 PC can help provide a more secure connection and access to your company's network and the internet—for example, when you're working in a public location such as a coffee shop, library, or airport.
Manage accounts and organizations in Microsoft Teams
Using the new Microsoft Teams, you can now be logged into multiple work, school, and personal accounts on the Windows desktop app. Easily switch back and forth between organizations, including guest organizations. See and change your notification settings for your various accounts.
Applies To: Microsoft Teams
CONCATENATE function - Microsoft Support
Problem. Description. Quotation marks appear in result string. Use commas to separate adjoining text items. For example: Excel will display =CONCATENATE("Hello ""World") as Hello"World with an extra quote mark because a comma between the text arguments was omitted.
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
Mailbox storage limits in Outlook - Microsoft Support
Clean up Mailbox. From the Settings > Storage page you should see a breakdown of how much space each folder in your mailbox is taking. Below, you should see a list of the folders represented in the breakdown with the option to permanently delete all items (or those older than 3, 6, or 12 months) in these folders to free up space.
Applies To: Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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