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.

Learn how to use MINVERSE and MMULT functions in Excel. MINIVERSE returns the matrix inverse of an array,. MMULT function returns matrix product of two arrays.