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
Accessibility features in Microsoft Edge - Microsoft Support
Turn on caret browsing indefinitely by going to Settings and more > Settings > Accessibility and turn on Navigate pages with a text cursor. With caret browsing on, you can move the caret within a web page using the Up, Down, Left, and Right directional arrow keys and Home, Page Up, and Page Down buttons on your keyboard.. To select text, images, or other elements on the page, hold down Shift ...
Create and save a PowerPoint template - Microsoft Support
On the View tab, in the Master Views group, choose Slide Master.. The slide master is the largest slide image at the top of the slide thumbnail list, to the left of your slides. Associated slide layouts are positioned beneath the slide master.
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Get started with Python in Excel - Microsoft Support
Python in Excel uses the custom Python function xl() to interface between Excel and Python. The xl() function accepts Excel objects like ranges, tables, queries, and names.. You can also directly type references into a Python cell with the xl() function. For example, to reference cell A1 use xl("A1") and for the range B1:C4 use xl("B1:C4").For a table with headers named MyTable, use xl ...
Applies To: Excel for Microsoft 365
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 or set the default font in Outlook - Microsoft Support
Replying or forwarding messages - You can have a different font on messages you're forwarding or replying to. This setting is mostly for the two check boxes that let you mark your comments with your name (or other text) or with a different color of text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
COUNT function - Microsoft Support
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20).In this example, if five of the cells in the range contain ...
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
Give your PC a Fresh Start - Microsoft Support
To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings
Herunterladen und Installieren der neuesten Druckertreiber - Microsoft ...
Die meisten Drucker erfordern, dass Sie den neuesten Druckertreiber installieren, damit der Drucker gut funktioniert. Wenn Sie kürzlich ein Upgrade von einer früheren Windows-Version durchgeführt haben, funktioniert Ihr Druckertreiber möglicherweise mit der vorherigen Version, aber eventuell nicht gut oder überhaupt nicht mit Windows 10.
Use Microsoft Authenticator with Microsoft 365
Choose the mobile app. Open a browser on your computer and go to portal.office.com.Sign in to your Office 365 for business account.
Applies To: Office for business, Microsoft 365 admin