Matrix Addition & Subtraction in Excel

In this article, you will learn some matrix operations like matrix addition, matrix subtraction using Excel. Excel Addition of Matrices To sum matrices, firstly enter the matrices A and B any cell range in Excel sheet. In the example below we type Matrix A to B4:D6 and Matrix B to F4:H6. After that select the … Read more

Complex Numbers in Excel: Functions & Operations

In this article, you’ll learn basic functions and operations for complex numbers in Excel. Complex numbers are a fundamental concept in mathematics, and they have many important applications in various fields such as Electrical Engineering, Control Theory, Signal Processing, Quantum Mechanics. A complex number is a number that can be expressed in the form “x … 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

Convert days, hours, minutes, seconds in Excel

It is possible to apply various conversions between time units in Excel. For instance, converting days to hours, hours to minutes, minutes to seconds and so on. These can be reversed as well. All these conversions can be done by basic mathematical operations, or using a built-in function, called CONVERT function. We know that 1 hour … Read more