Excel Skill : [short cut key | Data Consolidation - combine volumes of data, provided they are organised in a similar manner | Data selection - Filters, Pivot Tables | Quality control - data validation or validity function | Visual representations - visual graphics and charts | Power Query - connect to data outside of Excel and clean and manipulate the data | Conditional formatting-highlighting or background colour—that meet specific, defined criteria | Flash Fill | Advanced Functions &… Show more Excel Skill : [short cut key | Data Consolidation - combine volumes of data, provided they are organised in a similar manner | Data selection - Filters, Pivot Tables | Quality control - data validation or validity function | Visual representations - visual graphics and charts | Power Query - connect to data outside of Excel and clean and manipulate the data | Conditional formatting-highlighting or background colour—that meet specific, defined criteria | Flash Fill | Advanced Functions & Formulas - Xlookup, Vlookup + Mach, Index + Match, If + And, If + Or, Iferror, Small & Large, Countifs, Sumifs, Concatenate and Textjoin, Text before &Text after, Left, Mid, Right, Len & Trim, Find & Replace/Substitute,Unique, Transpose, Sequence, workday/Networkdays, Offset, Choose, XNPV, XIRR, PMT, IPMT Show less