Why QWERTY? The Real Story of the Keyboard Layout
Why the letters on your keyboard are in such a strange order: typewriter jams, telegraph operators, a famous patent and why nobody switched even…
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 →Power Query Intermediate Lesson 6: Custom Functions – Clean Every File the Same Way
Power Query Intermediate Lesson 6: Custom Functions – Clean Every File the Same Way
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 →Power Query Intermediate Lesson 5: Custom Columns in M – Clean Text, Digits and try … otherwise
Power Query Intermediate Lesson 5: Custom Columns in M – Clean Text, Digits and try … otherwise
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 →Power Query Intermediate Lesson 4: Group By With All Rows – Latest Record per Customer
Power Query Intermediate Lesson 4: Group By With All Rows – Latest Record per Customer
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 →Power Query Intermediate Lesson 3: Fuzzy Merge for Misspelt Names
Power Query Intermediate Lesson 3: Fuzzy Merge for Misspelt Names
Match "Sharma Trader", "Mehta and Sons" and "sharma traders" to the right master record with fuzzy merge, and tune the similarity threshold.
Read article →Bank Reconciliation in Excel with XLOOKUP and FILTER
Bank Reconciliation in Excel with XLOOKUP and FILTER
Match your books with the bank statement: build a matching key, find entries missing on either side with XLOOKUP, handle duplicates with COUNTIFS and…
Read article →Power Query Intermediate Lesson 2: Merge Kinds – Unpaid Invoices and Orphan Payments
Power Query Intermediate Lesson 2: Merge Kinds – Unpaid Invoices and Orphan Payments
Use Left Anti and Right Anti merges to find invoices with no payment and payments with no invoice, and know when to use each…
Read article →