MS Excel: What is a PivotTable

MS Excel: Create a PivotTable manually

MS Excel: How to create a more elaborated PivotTable

MS Excel: Lookup family functions

MS Excel: Functions SUMIF and SUMIFs

MS Excel: How to use the data validation tool

MS Excel: How to calculate basic statistics with Excel

MS Excel: How to create ship report using nested functions

MS Excel: How to use Conditional Formatting

MS Excel: How to set table format

MS Excel: Create a chart with secondary axis

MS Excel: How to identify and remove duplicates

MS Excel: How to create calculated fields and items

MS Excel: How to summarize PivotTable with calculated items

MS Excel: How to format PivotTable and re-use with new files

MS Excel: How to create a re-usable template

MS Excel: How to create customized function with Lambda

MS Excel: How to combine Match and Index to create a powerful lookup formula

MS Excel: Create a dynamic report with Sum, Average, Match and Index