In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.

This video is part of a training course called Advanced IF functions.. Syntax. COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments:

Important: Subtotals are not supported in Excel tables.The Subtotal command will appear grayed out if you are working with an Excel table. To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal. Note that this will remove all table functionality from the data except table formatting.

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.

On the Outlook status bar, if you see Disconnected, Working Offline, or Trying to connect…, then Outlook can't reach the email server to send your mail.. To fix this problem, on the ribbon, select the Send/Receive tab, then, in the Preferences group, select Work Offline to toggle between offline mode and online mode.You may need to open the message and send it again or choose Send/Receive.

In Microsoft Teams (free), you can use keyboard shortcuts to send a wide range of emojs. You can either find the emojis in the reaction picker or type the shortcuts below into a message to make the emoji appear when you send your message.

To create a new copy of the document in Word 2016 mode, select Save As, and then choose the location and the folder where you want to save the new copy.Type a new name for the document in the File name box, and then select Word Document in the Save as type list. Make sure the box next to Maintain compatibility with previous versions of Word is cleared.

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.

This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.