Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Pick a cell at the bottom of a column of numbers, hit Alt+= (the alt key plus the equal sign), and Excel will grab all the cells above and put them into a =SUM () formula.

Gross margin represents the amount of total sales revenue that a company retains after incurring the direct costs associated with producing the goods sold by the company.

Bollinger Bands aid investors by indicating market volatility using standard deviations around a 20-day moving average, helping identify overbought and oversold signals.