Count unique values among duplicates - Microsoft Support
You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.
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
Sync files with OneDrive on macOS - Microsoft Support
Turn on Finder integration. If you’re on OSX 10.10 or higher, get sync status directly from Finder by enabling Finder overlays in Settings. First, click the Apple logo in the top left corner of your Mac Desktop and select System Preferences, then select Extensions in the top-level menu (shown in the 3rd row from the top).. Under your Added Extensions, select the checkbox for OneDrive.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, OneDrive (work or school), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, SharePoint admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Freigeben und Zugreifen auf einen schreibgeschützten Kalender in ...
Freigeben Ihres Kalenders in einer E-Mail. Wenn Sie jemandem keine Berechtigungen zum Freigeben Ihres Kalenders und zum Anzeigen von Updates erteilen möchten, können Sie eine statische Kopie Ihres Kalenders für einen bestimmten Datumsbereich per E-Mail senden.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Outlook on the web, New Outlook for Windows
Aanmelden bij een Microsoft-account - Microsoft Ondersteuning
Gebruik uw Microsoft-account om u aan te melden bij Microsoft-services zoals Windows, Microsoft 365, OneDrive, Skype, Outlook en Xbox Live.
Applies To: Microsoft 365 for home, Outlook.com, Microsoft 365 for Mac, Microsoft 365 for Windows, Microsoft account dashboard, Microsoft Edge, Microsoft Teams, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Getting started with Microsoft Family Safety - Microsoft Support
A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.
Applies To: Microsoft Family Safety
Change an email signature - Microsoft Support
Whether it’s a new job title (congratulations!) or a phone number change, make sure you keep your email message signature up-to-date. If you're using new Outlook, for more information about email signatures, or if you haven’t created one yet, see Add a signature to messages.. Select File > Options > Mail > Signatures.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Show desktop icons in Windows - Microsoft Support
Note: If you are in tablet mode, you may not be able to see your desktop icons properly.You can find the program by searching for the program name in File Explorer. To turn off tablet mode, select action center on the taskbar (next to date and time), and then select Tablet mode to turn it on or off.
Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Use AutoSum to sum numbers - Microsoft Support
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.
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 for iPhone, Excel for Android tablets, Excel for Android phones
Getting ready for the Windows 11 upgrade - Microsoft Support
If you're running Windows 8.1 or earlier, or if your PC doesn't meet the minimum system requirements to run Windows 11, consider moving to a new Windows 11 device. Find a PC that meets your needs. Set up your Microsoft account to transfer files and favorites. One account connects your device across Microsoft apps and services like Microsoft 365, OneDrive, Edge, and Microsoft Store.