PI Function in Excel: PI Number & Approximations

The number Pi (π) is the ratio of the circumference of a circle to its diameter. Pi has a wide range of applications such as geometry, trigonometry, engineering, art. In this article, you’ll learn how to use PI function in Excel and PI approximations with examples. Excel PI Function and Usage Excel PI function returns … Read more

Excel MINVERSE Function: Inverse Matrix

In this article, you will learn how to calculate inverse of a matrix and the usage of MINVERSE function in Excel. The inverse of a matrix refers to a matrix that when multiplied by original matrix gives the identity matrix. Calculating the inverse of a matrix is a fundamental concept in linear algebra, often used … Read more

Excel MMULT Function: Matrix Multiplication

In this article, you will learn matrix multiplication operation in Excel and how to use MMULT function. Matrix multiplication refers to the product of two matrices. This is a different operation from scalar multiplication. For multiplying matrices, the number of columns in the first matrix must be equal to the number of rows in the … Read more

Solving Quadratic Equations in Excel: Real & Complex Roots

In this article, you’ll learn how to solve quadratic equations and practice in Excel. A quadratic equation is a type of polynomial equation of the second degree. The general form of a quadratic equation is ax2 + bx + c = 0. In this equation, “a”, “b”, and “c” are coefficients. “x” represents the variable … Read more

RADIANS – DEGREES Conversion in Excel

Radian is a measure based on radius of a circle that is used in mathematics especially in trigonometry. A degree, usually shown as °, is like a measuring unit for angles. It signifies a complete circle, which is 360 degrees in total. When you want to do some trigonometric calculations in Excel, you may need … Read more