Видео

Optional tip if this was helpful: paypal.me/LouisDeconinck I ranked and explained the top 10 most popular Excel functions from best to worst in a tierlist.

Optional tip if this was helpful: paypal.me/LouisDeconinck Learn 3 easy techniques on how to remove / delete rows in Excel with specific text without sorting: filter, find & select and advanced filter.

Optional tip if this was helpful: paypal.me/LouisDeconinck Learn how to find missing numbers in Excel using functions such as UNIQUE, SEQUENCE and VSTACK in a dynamic and automatic way.

Optional tip if this was helpful: paypal.me/LouisDeconinck Learn how to remove the first and last number of characters from text strings using Excel functions such as LEFT, RIGHT and LEN.

Optional tip if this was helpful: paypal.me/LouisDeconinck Learn how to copy-paste multiple cells into one single cell in Excel with this special trick using the clipboard.

Optional tip if this was helpful: paypal.me/LouisDeconinck Using conditional formatting we can highlight the currently active clicked cell and row in Excel.

Optional tip if this was helpful: paypal.me/LouisDeconinck The MDETERM function in Microsoft Excel calculates the determinant of a square matrix.

Optional tip if this was helpful: paypal.me/LouisDeconinck

Optional tip if this was helpful: paypal.me/LouisDeconinck The TEXTAFTER function extracts a piece of text after a given delimiter.

Optional tip if this was helpful: paypal.me/LouisDeconinck

Optional tip if this was helpful: paypal.me/LouisDeconinck

Optional tip if this was helpful: paypal.me/LouisDeconinck

Optional tip if this was helpful: paypal.me/LouisDeconinck

Optional tip if this was helpful: paypal.me/LouisDeconinck

Subtract Complex Numbers - Excel IMSUB Function

Absolute Value & Modulus of a Complex Number - Excel IMABS Function

Square Root of a Complex Number - Excel IMSQRT Function

Divide Complex Numbers - Excel IMDIV Function

Secant of a Complex Number - Excel IMSEC Function

Raise a Complex Number to a Power - Excel IMPOWER Function

Hyperbolic Cosine of a Complex Number - Excel IMCOSH Function

Complex Conjugate - Excel IMCONJUGATE Function

Sine of a Complex Number - Excel IMSIN Function

Multiply Complex Numbers - Excel IMPRODUCT Function

Cosecant of a Complex Number - Excel IMCSC Function

Tangent of a Complex Number - Excel IMTAN Function

Hyperbolic Cosecant of a Complex Number - Excel IMCSCH Function

Hyperbolic Secant of a Complex Number - Excel IMSECH Function

Argument (θ) of a Complex Number - Excel IMARGUMENT Function