Group or ungroup data in a PivotTable - Microsoft Support
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months.
Use Goal Seek to find the result you want by adjusting an input …
Windows macOS. If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to borrow some money.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
What is Protected View? - Microsoft Support
Protected View is a read-only mode where most editing functions are disabled. There are several reasons why a file opens in Protected View: The file was opened from an Internet location - When you see the message in Protected View that says "Be careful - …
Filter for unique values or remove duplicate values
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
Calculation operators and precedence in Excel - Microsoft Support
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. In this article, you'll learn the default order in which operators act upon the elements in a calculation.
Quick start: Sort data in an Excel worksheet - Microsoft Support
On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest). Click to perform a descending sort (from Z to A, or largest number to smallest). Sort by specifying criteria.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
FORECAST and FORECAST.LINEAR functions - Microsoft Support
This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions.
Round a number to the decimal places I want - Microsoft Support
Round a number to the number of digits you want by using the ROUND function. This function has only two arguments (arguments are pieces of data the formula needs to run). The first argument is the number you want to round, which can be a cell reference or a number. The second argument is the number of digits you want to round the number to.