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 →TOROW Function in Excel: Flatten Into One Row
TOROW Function in Excel: Flatten Into One Row
TOROW flattens a block into a single row, optionally skipping blanks and errors.
Read article →Look Up the Price Valid on a Date in Excel (Rate Changes, Price Lists, Tax Rates)
Look Up the Price Valid on a Date in Excel (Rate Changes, Price Lists, Tax Rates)
Pick the rate that was valid on a transaction date from a price history — XLOOKUP with match mode -1, LOOKUP, MAXIFS + INDEX…
Read article →Power Query Lesson 10: Project — A Monthly Refresh Pipeline
Power Query Lesson 10: Project — A Monthly Refresh Pipeline
Build a complete refreshable pipeline: combine monthly files from a folder, clean and type them, merge product details, add FY columns, load to the…
Read article →Is This Shopping Website Safe? 7 Checks Before You Pay
Is This Shopping Website Safe? 7 Checks Before You Pay
Seven quick checks before paying on an unfamiliar shopping site: the real domain, too-good prices, contact details, reviews, return policy, payment options and site…
Read article →Power Query Lesson 9: Dates, Financial Year and a Calendar Table
Power Query Lesson 9: Dates, Financial Year and a Calendar Table
Work with dates in Power Query: extract year, month name and week, add Indian financial year and FY quarter columns, calculate days between dates,…
Read article →Power Query Lesson 8: Custom and Conditional Columns (a Little M)
Power Query Lesson 8: Custom and Conditional Columns (a Little M)
Add calculated columns in Power Query: Conditional Column for size bands, Custom Column formulas for GST and totals, Column From Examples, if-then-else in M,…
Read article →Power Query Lesson 7: Group By
Power Query Lesson 7: Group By
Summarise data inside Power Query with Group By: basic and advanced grouping, several aggregations (sum, count, count distinct), grouping by two columns, and when…
Read article →Project: Build a Policy Q&A Assistant for Your Team
Project: Build a Policy Q&A Assistant for Your Team
Put the course together: a small web app that answers questions from your policy documents with sources, refuses when unsure, logs usage and stays…
Read article →Guardrails, Cost Limits and Logging for AI Agents
Guardrails, Cost Limits and Logging for AI Agents
Make an agent safe to share: turn limits, a cost ceiling, read-only tools, approval for risky actions, prompt-injection awareness and a log you can…
Read article →Power Query Lesson 6: Append and Combine a Folder of Files
Power Query Lesson 6: Append and Combine a Folder of Files
Stack tables with Append Queries, then combine every file in a folder with From Folder: sample file transform, file name as a column, filtering…
Read article →Power Query Lesson 5: Merge Queries — Lookups Without VLOOKUP
Power Query Lesson 5: Merge Queries — Lookups Without VLOOKUP
Bring product names and categories into an orders table with Merge Queries: matching columns, join kinds (left outer, inner, anti), expanding columns, and finding…
Read article →