Load the Analysis ToolPak in Excel - Microsoft Support
Perform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
Use the Analysis ToolPak to perform complex data analysis
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.
Count the number of rows or columns in Excel - Microsoft Support
Count the number of rows, columns, or cells in Excel by using the status bar at the bottom of the Excel screen. You can also customize the status bar.
Tutorial: Import Data into Excel, and Create a Data Model
In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share.
What to do if a data set is too large for the Excel grid
If you’ve opened a file with a large data set in Excel, such as a delimited text (.txt) or comma separated (.csv) file, you might see the warning message, "This data set is too large for the Excel grid. If you save this workbook, you'll lose data that wasn't loaded."
Basic tasks in Excel - Microsoft Support
Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Using Access or Excel to manage your data - Microsoft Support
You can use Access to automate frequently performed actions, and Access reports let you summarize data in printed or electronic form. Access provides more structure for your data; for example, you can control what types of data can be entered, what values can be entered, and you can specify how data in one table is related to data in other tables.
SUMIFS function - Microsoft Support
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string (""). Syntax. Examples. FILTER used to return multiple criteria.
Consolidate data in multiple worksheets - Microsoft Support
To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks.