PivotTables are one of the most powerful analysis tools available in Microsoft Excel. They let a user easily take a large table of data and summarize that data using any combination of fields in...
The IF Functions are some of the most powerful functions in Excel. A basic IF or IFS function can allow complex decision tree-style analysis and functions like SUMIFS and COUNTIFS allow you to c...
Conditional Formatting is an excellent analysis tool that allows a user to change the formatting of their results when certain criteria are met. For example, the top 10% or values within a speci...