Practical tutorials since 2016, by Atul Vij
Step-by-step tutorials with downloadable practice files, free browser tools and a daily dose of wacky facts.
🤯 Wacky fact
Only scientists and support staff live there temporarily; India runs the Maitri and Bharati research stations.
Free course
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 →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 →ISOMITTED is used inside LAMBDA to give optional parameters default values.
Read article →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 →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 →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 →Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →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 →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 →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 →Write a custom M function that skips junk header lines, promotes headers and sets types, then apply it to every file in a folder…
Read article →Write custom columns in M: proper-case names, 10-digit Indian mobile numbers, PIN codes and amounts from text like "Rs. 2,250", with try ... otherwise…
Read article →Keep the latest credit limit per customer with Group By, All Rows and Table.Max, count changes, and restore column types after expanding records.
Read article →
