Using structured references with Excel tables - Microsoft Support
In our example data, we used the name DeptSales.. Use the following rules for table names: Use valid characters Always start a name with a letter, an underscore character (_), or a backslash (\).Use letters, numbers, periods, and underscore characters for the rest of the name.
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, Excel 2013, Excel Mobile
Windows camera, microphone, and privacy - Microsoft Support
In Windows 10, ensure that Camera access for this device, Allow apps to access your camera, and the individual toggle for the Microsoft Store app you wish to use is turned on. If you do not see the app or website you're looking for in the list, it's likely a desktop app. Desktop apps cannot be individually toggled, but access for those apps can be controlled using Allow desktop apps to access ...
Get new themes and desktop backgrounds - Microsoft Support
Select Start , then select Settings > Personalization > Themes.Choose from a default theme or select Get more themes in Microsoft Store if you want to download new themes with desktop backgrounds that feature cute critters, breathtaking landscapes, and other smile-inducing options.
Check the recent sign-in activity for your Microsoft account
If you get an email about unusual activity on your Microsoft account, or if you’re worried that someone else might have used your account, go to the Recent activity page.You’ll see when your Microsoft account was signed in during the last 30 days, along with any device or app-specific info.
Applies To: Microsoft account dashboard
Create a document in Word - Microsoft Support
Learn how to format text, add graphics, and more in Word documents. Create professional-looking documents with ease using our step-by-step guide. Try it now!
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Excel functions (by category) - Microsoft Support
Function. Description. CUBEKPIMEMBER function. Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.
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
SharePoint help & learning
The SharePoint landing page serves as a comprehensive resource for end users exploring functionalities of SharePoint. It offers guidance on getting started with SharePoint, including how to sign in, create SharePoint sites, and set up pages to organize content effectively. Users can access tutorials on managing documents and libraries within SharePoint, as well as leveraging data and lists for ...
Faster and more secure Wi-Fi in Windows - Microsoft Support
Tip: You can also check to see what your network adapter supports by opening the Command Prompt (or Terminal), and then typing the command netsh wlan show drivers.Look next to Radio types supported and see if it includes 802.11be (for Wi-Fi 7) or 802.11ax (for Wi-Fi 6/6e) and look under Authentication and cipher supported in infrastructure mode and see if it includes WPA3 Personal and WPA3 ...
Get Windows updates as soon as they're available for your device
We're committed to delivering continuous innovation by releasing new features and enhancements into Windows 11 more frequently. Windows devices get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR). ...