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 →OK: How a 19th-Century Joke Became the World’s Most Used Word
OK: How a 19th-Century Joke Became the World’s Most Used Word
"OK" started as a joke abbreviation for "oll korrect" in 1830s Boston newspapers and was saved from fading away by a presidential campaign. The…
Read article →What to Automate First: Picking Office Tasks That Are Worth It
What to Automate First: Picking Office Tasks That Are Worth It
A simple way to decide which repetitive task to automate first: frequency, time, error cost and stability — with a scoring sheet and examples…
Read article →N Function in Excel: Turn a Value Into a Number
N Function in Excel: Turn a Value Into a Number
N returns numbers unchanged, TRUE as 1 and text as 0. Its oddest use is hiding a note inside a formula.
Read article →EPM Automate: Script Your Oracle EPM Cloud Month-End Tasks
EPM Automate: Script Your Oracle EPM Cloud Month-End Tasks
Use Oracle's EPM Automate command-line tool to log in, upload files, run data rules and business rules, refresh the cube and export data —…
Read article →Smart View Lesson 6: Building a Refreshable Report Template
Smart View Lesson 6: Building a Refreshable Report Template
Combine everything into a monthly report: parameter cells for period and entity, ad hoc or function grids, preserved formatting, multiple sheets refresh, and VBA…
Read article →DVAR Function in Excel: Sample Variance of Matching Records
DVAR Function in Excel: Sample Variance of Matching Records
DVAR returns the sample variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS returns |z|, the length of the vector: SQRT(a²+b²). For impedance it's the magnitude in ohms. Complex numbers are text like 3+4i; build them…
Read article →Smart View Functions: Build Cell-Based Reports with HsGetValue
Smart View Functions: Build Cell-Based Reports with HsGetValue
Use Oracle Smart View functions such as HsGetValue to pull single numbers from Essbase or EPM into any Excel layout — syntax, POV defaults,…
Read article →Combine Data From Multiple Sheets Into One in Excel (VSTACK, FILTER)
Combine Data From Multiple Sheets Into One in Excel (VSTACK, FILTER)
Stack monthly or branch sheets into one live list with VSTACK and 3D references, drop blank rows with FILTER, tag each row with its…
Read article →