Using IF with AND, OR, and NOT functions in Excel
Technical Details. Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like this: AND – =IF (AND (Something is True, Something else is True), Value if True, Value if False)
Using structured references with Excel tables - Microsoft Support
Structured reference: (DeptSales [ [#Totals], [Sales Amount]] and DeptSales [ [#Data], [Commission Amount]] are structured references, represented by a string that begins with the table name and ends with the column specifier. To create or edit structured references manually, use these syntax rules:
Create a PivotTable to analyze worksheet data - Microsoft Support
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel. If you have the right license requirements, you can ask Copilot to help you create a PivotTable.
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Filter Data in DAX Formulas - Microsoft Support
You can create filters within formulas, to restrict the values from the source data that are used in calculations. You do this by specifying a table as an input to the formula, and then defining a filter expression. The filter expression you provide is used to query the data and return only a subset of the source data.
Use Slicers to filter data - Microsoft Support
Use a slicer to filter data. Select Insert > Slicer. Select the fields you'd like to filter. Select OK and adjust your slicer preferences, such as Columns, under Options. Note: To select more than one item, hold Ctrl, and then select the items that you want to show.
Create and manage Sheet Views in Excel - Microsoft Support
Use Sheet Views in Excel to create custom views that won't interrupt others. For instance, you can sort a table by a certain criteria, and others will still see the full table. Or sort a table in a particular way, but everyone else will see it the way it was originally.
Drill into PivotTable data - Microsoft Support
Drill down in a PivotTable with an OLAP or Data Model data hierarchy to view details on lower levels and drill up to view summary data on upper levels by using the new Quick Explore feature.
T.INV.2T function - Microsoft Support
T.INV.2T returns that value t, such that P (|X| > t) = probability where X is a random variable that follows the t-distribution and P (|X| > t) = P (X < -t or X > t). A one-tailed t-value can be returned by replacing probability with 2*probability.
Use multiple tables to create a PivotTable - Microsoft Support
Create a PivotTable with multiple tables. Here are the three basic steps to get multiple tables into the PivotTable Field List: Import from a relational database, like Microsoft SQL Server, Oracle, or Access. You can import multiple tables at the same time: Connect to an Oracle database.
Video: Apply a table style - Microsoft Support
Try it! Give your tables a designer’s touch with table styles. Choose from a selection of color schemes, apply alternate row colors, add a heading row, or format a total row.