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 →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 →Why Do We Yawn — and Why Is It Contagious?
Why Do We Yawn — and Why Is It Contagious?
The old "yawning brings in oxygen" idea doesn't hold up. What scientists think yawning is for — brain cooling, alertness — and why seeing…
Read article →Why Does Ice Float? (And Why Life Depends on It)
Why Does Ice Float? (And Why Life Depends on It)
Most solids sink in their own liquid, but ice floats because frozen water molecules lock into an open crystal that is about 9% less…
Read article →Why Do Cats Purr?
Why Do Cats Purr?
Cats purr by rapidly twitching muscles in their voice box — not only when happy but also when stressed or hurt. What science knows…
Read article →Excel Sparklines: Tiny Trend Charts Inside Cells
Excel Sparklines: Tiny Trend Charts Inside Cells
Add line, column and win/loss sparklines next to each row of a report, highlight highs and lows, fix the axis so rows compare fairly,…
Read article →How Data Gets From Your ERP Into Oracle EPM Planning
How Data Gets From Your ERP Into Oracle EPM Planning
Source system, locations, import formats, mappings and data rules: a plain-English walk through Oracle EPM Cloud data integration and where loads usually go wrong.
Read article →COMPLEX Function in Excel: Build a Complex Number
COMPLEX Function in Excel: Build a Complex Number
Construct a complex number in text format (a+bi or a+bj) from separate real and imaginary numeric coefficients.
Read article →Smart View Lesson 2: Connecting and Your First Ad Hoc Grid
Smart View Lesson 2: Connecting and Your First Ad Hoc Grid
Connect Smart View to Essbase or EPM Cloud with a private or shared connection, open an ad hoc grid, refresh, and set the most…
Read article →IMPRODUCT Function in Excel: Multiply Complex Numbers
IMPRODUCT Function in Excel: Multiply Complex Numbers
Calculate the product of up to 255 complex numbers in rectangular form (x+yi or x+yj) in Excel.
Read article →Document a Process Before You Automate It: A One-Page Template
Document a Process Before You Automate It: A One-Page Template
A one-page template to write down any office process — trigger, inputs, steps, rules, exceptions, outputs and checks — so automation projects start from…
Read article →IMAGINARY Function in Excel: Imaginary Part
IMAGINARY Function in Excel: Imaginary Part
Extract the imaginary coefficient b from a complex number formatted as text (a+bi or a+bj) as a numeric value.
Read article →