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 →Practical tutorials since 2016, by Atul Vij
Learn Excel, automation & code — the practical way
Step-by-step tutorials with downloadable practice files, free browser tools and a daily dose of wacky facts.
1,065articles
1,087practice files
10free tools
644wacky facts
🤯 Wacky fact
A day on Venus is longer than its year.
Venus takes about 243 Earth days to rotate once but only about 225 Earth days to orbit the Sun, and it spins backwards compared with most planets.
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
15 of 15 lessons published
Start lesson 1 →Latest articles
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 →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 →ISOMITTED Function in Excel: Was an Optional Argument Left Out?
ISOMITTED Function in Excel: Was an Optional Argument Left Out?
ISOMITTED is used inside LAMBDA to give optional parameters default values.
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 →Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Learn how FIX…ENDFIX focuses an Essbase calculation on a slice of the cube, with examples for aggregation, allocation, clearing data and copying scenarios —…
Read article →Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →Power Query Intermediate Lesson 8: Project – ERP Register to HSN-wise GST Summary
Power Query Intermediate Lesson 8: Project – ERP Register to HSN-wise GST Summary
Final project: keep only the latest revision of each invoice, compute GST and build an HSN-wise summary for GSTR-1 style reporting, refreshable every month.
Read article →Power Query Intermediate Lesson 7: Two Header Rows – Unpivot a Region-over-Month Report
Power Query Intermediate Lesson 7: Two Header Rows – Unpivot a Region-over-Month Report
Turn a report with merged Region headers over Month headers into a clean table: transpose, fill down, combine header rows, unpivot and split.
Read article →Oracle EPM Cloud Explained: Planning, FCCS, Narrative Reporting and More
Oracle EPM Cloud Explained: Planning, FCCS, Narrative Reporting and More
A plain-English map of Oracle EPM Cloud: what Planning, Financial Consolidation and Close, Account Reconciliation, Narrative Reporting and EDM each do — and how…
Read article →