Basics of VBA / Macros Chapter – 2 (Creating Macro)
With VBA you can automate tasks in Excel by writing so called macros. We willΒ learn how to create a simple macro which will beβ¦
Read article βExcel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards β from basics to clever tricks.
Split Text by Comma, Dash or Any Delimiter in Excel (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Split Text by Comma, Dash or Any Delimiter in Excel (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Break βMumbai-MH-400001β or comma lists into columns and rows with TEXTSPLIT, TEXTBEFORE and TEXTAFTER in Excel 365, and the TRIM/MID/SUBSTITUTE trick for older versions.
Read article βBasics and Abbreviations of VBA / Macros Chapter – 1
Basics and Abbreviations of VBA / Macros Chapter – 1
VBA full form is Visual Basic for Applications. It is the programming language of Excel and other Office programs. Points to be learned forβ¦
Read article βVBA Plus / Macros Chapter β 1 (Swap Values – 1)
VBA Plus / Macros Chapter β 1 (Swap Values – 1)
This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs
Read article βDependent Dropdown Lists in Excel (Two Methods That Actually Work)
Dependent Dropdown Lists in Excel (Two Methods That Actually Work)
Create a second dropdown that changes with the first β Category then Product, Country then City β using INDIRECT with named ranges or aβ¦
Read article βOne Slicer for Several Pivot Tables (Plus Timelines for Dates)
One Slicer for Several Pivot Tables (Plus Timelines for Dates)
Connect a single slicer to multiple pivot tables and charts with Report Connections, add a timeline for months and quarters, and fix the "notβ¦
Read article βIMCSCH Function in Excel: Hyperbolic Cosecant of a Complex Number
IMCSCH Function in Excel: Hyperbolic Cosecant of a Complex Number
Calculate the hyperbolic cosecant of a complex number in rectangular format for catenary simulations and electromagnetic field distributions.
Read article βIMCOT Function in Excel: Cotangent of a Complex Number
IMCOT Function in Excel: Cotangent of a Complex Number
Calculate the cotangent of a complex number in x+yi or x+yj format for advanced wave mechanics, fluid dynamics, and transmission line equations.
Read article βIMDIV Function in Excel: Divide Complex Numbers
IMDIV Function in Excel: Divide Complex Numbers
Calculate the quotient of two complex numbers in rectangular form (x+yi or x+yj), widely used in AC circuit impedance and phasor calculations.
Read article βIMREAL Function in Excel: Real Part
IMREAL Function in Excel: Real Part
Extract the real coefficient a from a complex number formatted as text (a+bi or a+bj) as a numeric value.
Read article βIMARGUMENT Function in Excel: Angle of a Complex Number
IMARGUMENT Function in Excel: Angle of a Complex Number
Compute the argument (phase angle ΞΈ in radians) of a complex number in the complex plane for polar coordinate conversions.
Read article βIMCONJUGATE Function in Excel: Complex Conjugate
IMCONJUGATE Function in Excel: Complex Conjugate
Obtain the complex conjugate of a complex number by inverting the sign of its imaginary component (x+yi becomes x-yi).
Read article β