Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Use conditional formulas in Excel to analyze financial data - Excel - Office.com
In Microsoft Office Excel 2003, you can use the IF function to create conditional formulas that analyze data and return a value based on the results of the analysis. For example
Use the COUNTIFS function in Excel 2007 to analyze data - Excel - Office.com
Learn about the COUNTIF function syntax and view examples of criteria Excel accepts for COUNTIF.
Filter Data in DAX Formulas - Excel - Office.com
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
Data Analysis Expressions (DAX) in PowerPivot - Excel - Office.com
Data Analysis Expressions (DAX) sounds a little intimidating at first, but don’t let the name fool you. DAX basics are really quite easy to understand. First things first - DAX is
How to do 40 different what-if analyses quickly - Excel - Office.com
By Bill Jelen Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , which includes more