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 →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.
0articles
0practice files
0free tools
0wacky facts
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
8 of 15 lessons published
Start lesson 1 →Latest articles
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 →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 →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 →MaxL Basics: Automate Essbase Data Loads and Calculations
MaxL Basics: Automate Essbase Data Loads and Calculations
Use MaxL scripts to automate Essbase: log in, clear and load data with a rules file, run a calculation and log errors — with…
Read article →OpenClaw Alternatives Compared: OpenHuman, ZeroClaw, PicoClaw, NanoClaw, IronClaw and More
OpenClaw Alternatives Compared: OpenHuman, ZeroClaw, PicoClaw, NanoClaw, IronClaw and More
The OpenClaw ecosystem explained: lightweight rewrites in Rust, Go, Zig and C, security-focused agents with sandboxing, OpenHuman’s Rust agent harness, and cloud options like…
Read article →VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
A complete VBA project: fill an invoice template from a data sheet, export each invoice to PDF with a proper file name, and email…
Read article →Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
What Oracle Essbase is, how cubes, dimensions and members work, the difference between BSO and ASO, and a first look at calc scripts —…
Read article →VBA: Loop Through Every File in a Folder (and Combine Them)
VBA: Loop Through Every File in a Folder (and Combine Them)
Use the Dir function to process every Excel file in a folder with VBA — open, copy data into a master sheet, close —…
Read article →Power Automate: Send Automatic Payment Reminders From an Excel Table
Power Automate: Send Automatic Payment Reminders From an Excel Table
Build a scheduled cloud flow that reads an Excel table in OneDrive, finds invoices due in 3 days or overdue, and emails each customer…
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 →