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 →Atul Vij
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 →REGEXREPLACE Function in Excel: Find and Replace With Patterns
REGEXREPLACE Function in Excel: Find and Replace With Patterns
REGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask numbers.
Read article →IMSQRT Function in Excel: Square Root of a Complex Number
IMSQRT Function in Excel: Square Root of a Complex Number
IMSQRT returns the principal square root. Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSUB Function in Excel: Subtract Complex Numbers
IMSUB Function in Excel: Subtract Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMSUB subtracts one complex number from another.Syntax=IMSUB(inumber1, inumber2)ArgumentWhat it.
Read article →IMSEC Function in Excel: Secant of a Complex Number
IMSEC Function in Excel: Secant of a Complex Number
IMSEC returns 1/cos(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →