Ways to count values in a worksheet - Microsoft Support
Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a downloadable workbook with interactive examples, and …
Switch between various sets of values by using scenarios
After you have all the scenarios you need, you can create a scenario summary report that incorporates information from all the scenarios. Scenarios are managed with the Scenario Manager wizard from the What-If Analysis group on the Data tab.
Change the summary function or custom calculation for a field …
This summary function only works when you use the Data Model in Excel. Note: For some types of source data, such as OLAP data and for calculated fields and fields with calculated items, you can't change the summary function.
Check and share your form results - Microsoft Support
Microsoft Forms includes rich, real-time analytics that provide response summary information and individual results for surveys and other types of forms. You can export the results to Microsoft Excel for more in-depth analysis, as well as delete or print a summary of responses.
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of columns, or an outline of both rows and columns.
Create and share a Dashboard with Excel and Microsoft Groups
In this case, we created a top-level summary of sales by product category, and sorted by the Sales field in descending order. See Sort data in a PivotTable or PivotChart for more details.
Insert subtotals in a list of data in a worksheet - Microsoft Support
In the Use function box, click the summary function that you want to use to calculate the subtotals. For example, using the example above, you would select Sum.
GROUPBY function - Microsoft Support
The GROUPBY function in Excel allows you to create a summary of your data via a formula.
Create a Data Model in Excel - Microsoft Support
A Data Model is visualized as a collection of tables in a Field List, and most of the time, you’ll never even know it's there. Before you can start working with the Data Model, you need to get some data.
Introduction to What-If Analysis - Microsoft Support
After you have created or gathered all the scenarios that you need, you can create a Scenario Summary Report that incorporates information from those scenarios. A scenario report displays all the scenario information in one table on a new worksheet.
Tutorial: Import Data into Excel, and Create a Data Model
Relationships let you analyze collections of data in Excel, and create interesting and immersive visualizations from the data you import. Let’s start by creating a blank worksheet, then import data from an Excel workbook.