Ecosol_ashraf

MS EXCEL: Lookup& Reference ( Named ranges, Vlookup, hlookup, xlookup, row, column, offset, index, match, choose, fuzzy matching)

MS EXCEL: Statistical Functions ( Max/ min, small/ large, average, rank, percentrank, randbetween, countif, sumif)

MS EXCEL: Logical operators (IF, AND/OR,NOT, <>, IFERROR, IS statement)

MS EXCEL: Alt key tips, data validation

MS EXCEL: Ctrl, Function & MAC shortcuts