DCOUNT function - Microsoft Support
This article describes the formula syntax and usage of the DCOUNT function in Microsoft Excel. Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.
Create a flow chart with SmartArt - Microsoft Support
This article explains how to create a flow chart that contains pictures. You can use the methods described in this article to create or change almost any SmartArt graphic. Try different layouts to achieve the results you want. What do you want to do? On …
Create a timeline - Microsoft Support
Learn how to create a timeline in Microsoft Office apps. Create a graphical representation of a sequence of events with the SmartArt graphic timeline.
Keyboard shortcuts in Microsoft 365
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Analyze Data in Excel - Microsoft Support
Simply select a cell in a data range > select 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. If you're interested in more specific information, you can enter a question in the query box at the top of the pane, and press Enter.
Create a SmartArt graphic from scratch - Microsoft Support
SmartArt graphics can be created in Excel, Outlook, PowerPoint, and Word, and they can be used throughout Office. For an overview of SmartArt graphics, including considerations for choosing the best graphic and layout type to display your data or convey a …
Remove or allow a circular reference in Excel - Microsoft Support
You've entered a formula, but it’s not working. Instead, you’ve got this message about a “circular reference.” Millions of people have the same problem and it happens because your formula is trying to calculate itself. Here's what it looks like: The formula =D1+D2+D3 breaks because it lives in cell D3, and it’s trying to calculate itself.
Create a 3-D reference to the same cell range on multiple …
You can use a 3-D reference to add up budget allocations between three departments, Sales, HR, and Marketing, each on a different worksheet, by using the following 3-D reference: =SUM (Sales:Marketing!B3) You can even add another worksheet, and then move it into the range that your formula refers to.
Overview of Excel tables - Microsoft Support
To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list). Note: Excel tables should not be confused with the data tables that are part of a suite of what-if analysis commands.
INDEX function - Microsoft Support
There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form. Returns the value of an element in a table or an array, selected by the row and column number indexes.
Create a Map chart in Excel - Microsoft Support
You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Note: This feature is available if you have a Microsoft 365 subscription.