Erp, Advanced Excel, Vlookup, Ms Excel, Data Cleaning, Countifs, XLOOKUP, Data Consolidation, Pivot Tables, MRP, Charts and Graphs, ifs, Conditional Formatting, Pivot Charts, IF, Date functions, IFERROR, filtering, Basic understanding of Power Query, OR, INDEX MATCH, Advanced Filtering, Sorting, Countif, SUMIF, Excel Tables, Basic Excel Dashboard preparation, SUMIFS, AND, Removing duplicates, Data Validation