One of the most important functions of Excel is its capability to perform formulas that assist users to add, multiply, divide, and subtracting numbers.

Use a combination of the special pasting options along with a product function to multiply a column by a specific percentage.

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.