Create a SmartArt graphic from scratch - Microsoft Support
To add text, like a title, in an arbitrary position close to or on top of your SmartArt graphic, on the Insert tab, in the Text group, click Text Box to insert a text box. If you want only the text in your text box to appear, right-click your text box, click Format Shape or Format Text Box, and then set the text box to have no background color and no border.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
Improved copy and paste of URLs in Microsoft Edge
In an app, press Ctrl + V to use the default paste, which adds a link with the title of the page as the link text. If you're pasting into an app or website in Microsoft Edge, you can also right-click, select Paste as on the context menu, and then select Link (Default) from the sub-menu.
Use live captions to better understand audio - Microsoft Support
Live captions helps everyone, including people who are deaf or hard of hearing, better understand audio by providing automatic transcription. To make more content accessible to more people, live captions now has the ability to provide translations and will turn any audio that passes through your PC into a single English-language caption experience.
June 11, 2024KB5039212 (OS Builds 22621.3737 and 22631.3737)
Windows 11, version 23H2 ; July 25, 2024—KB5040527 (OS Builds 22621.3958 and 22631.3958) Preview; July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Calibrate your HDR display using the Windows HDR Calibration app
Note: If you have a built-in display that can play streaming HDR video, but doesn’t support HDR games and apps, use Display calibration for HDR video found in Settings > System > Display > HDR.. To check if your display supports HDR games and apps, under Display capabilities on the HDR settings screen, see if the selected display says Use HDR is Supported or Not supported.
Fix connections to wireless displays or docks in Windows
If you’re having trouble connecting to your wireless display or wireless dock, try the following to fix things: Make sure your Windows 10 device supports Miracast.
Stay up to date with news and interests - Microsoft Support
The taskbar can display the temperature in Celsius (°C) or Fahrenheit (°F). To switch between these two units, select the weather icon on the taskbar, select the Edit location and unit icon on the weather card, select Celsius or Fahrenheit on the weather, and select Save. News and interests is supported in any taskbar orientation.
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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 for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Video: What is Microsoft Teams? - Microsoft Support
Training: Learn how to get up and productive quickly with this Microsoft Teams Quick Start. Sign in to Teams, select Teams and Channels, reply to conversation threads, @mention someone, use emojis and stickers, and ask T-Bot questions.
Applies To: Microsoft Teams