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.

While Excel ... bar charts—also known as data bars—within cells to compare values. These are a simpler and more compact ...