Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
A PivotTable is an interactive table that summarizes, organizes, and compares large amounts of data in a worksheet. You can rotate the rows and columns in a PivotTable to obtain different views of the same data. You can use a PivotTable to analyze data in an Excel workbook or data from an external database
Use the IF logical function to test your data and calculate a value or display a word or phrase based on whether the logical test is true or false. You can use the IF function along with the AND and OR functions.