Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula.

Next, I want to create an employee report in the blue table. When I enter an ... I'll use the COUNTIF function with a wildcard to tell Excel to count how many cells in row 1 contain the word ...