I am very comfortable with pivot tables and can use VLOOKUP, COUNTIF (s), SUMIF (s), CHOOSE, and many other things that are less complex than that. I also have lots of programming experience so things like IF and AND and second nature. I have excellent skills in Index / Matching and good knowledge of power query, macro, or VBA.