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 →Atul Vij
IMLOG2 Function in Excel: Base-2 Log of a Complex Number
IMLOG2 Function in Excel: Base-2 Log of a Complex Number
IMLOG2 returns log2(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →Automatic Serial Numbers in Excel That Survive Filtering, Deleting and Blanks
Automatic Serial Numbers in Excel That Survive Filtering, Deleting and Blanks
Number rows 1, 2, 3 automatically: ROW and SEQUENCE for clean lists, COUNTA to skip blank rows, SUBTOTAL/AGGREGATE so numbering stays 1-2-3 after filtering,…
Read article →IMPOWER Function in Excel: Complex Number to a Power
IMPOWER Function in Excel: Complex Number to a Power
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMPOWER raises a complex number to a power.Syntax=IMPOWER(inumber, number)ArgumentWhat it.
Read article →IMTAN Function in Excel: Tangent of a Complex Number
IMTAN Function in Excel: Tangent of a Complex Number
IMTAN returns tan(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Learn Oracle Smart View ad hoc analysis step by step — connect, zoom, pivot, keep only, POV and suppression options — explained for Excel…
Read article →IMSUM Function in Excel: Add Complex Numbers
IMSUM Function in Excel: Add Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMSUM adds complex numbers: (3+4i)+(1-i) = 4+3i. Impedances in series add.Syntax=IMSUM(inumber1.
Read article →Lost Your Android Phone? Find, Lock or Erase It Remotely
Lost Your Android Phone? Find, Lock or Erase It Remotely
Use Google's Find Hub (earlier called Find My Device) to ring, locate, lock or erase a lost Android phone, what to set up today…
Read article →Essbase Cube vs SQL Database: When Each One Wins
Essbase Cube vs SQL Database: When Each One Wins
Why finance teams use multidimensional cubes like Essbase alongside relational SQL databases: pre-aggregation, hierarchies, sparse/dense data and the questions each answers best.
Read article →ISOMITTED Function in Excel: Was an Optional Argument Left Out?
ISOMITTED Function in Excel: Was an Optional Argument Left Out?
LogicalLevel: ExpertAvailable in: Excel 365 / 2021+ISOMITTED is used inside LAMBDA to give optional parameters default.
Read article →Smart View Lesson 5: Smart View Functions (HsGetValue)
Smart View Lesson 5: Smart View Functions (HsGetValue)
Build free-form reports with Smart View functions: HsGetValue syntax, referencing cells for members, the Function Builder, refreshing functions, and when to use functions vs…
Read article →T Function in Excel: Keep Text, Blank Out Numbers
T Function in Excel: Keep Text, Blank Out Numbers
T returns text unchanged and anything else as an empty string. Rarely needed alone, but tidy for mixed columns.
Read article →