Kenji Explains

Kenji Explains

Creator
0 followers

Finance/Excel/Power BI tutorials, IB/analytics skills for aspiring analysts.

Master Claude in Excel in Just 10 Minutes
VideoMay 13, 2026

Master Claude in Excel in Just 10 Minutes

The video demonstrates Claude for Excel’s expanded capabilities beyond chat, showing installation, model selection (Opus 4.7 vs Sonnet 4.6), and paid-access requirements. It highlights connectors (Gmail, Google Drive) to import files directly into Excel, custom formatting via saved instructions (example:...

By Kenji Explains
Claude vs Copilot vs ChatGPT vs Tracelight in Excel (Surprising Results)
VideoApr 26, 2026

Claude vs Copilot vs ChatGPT vs Tracelight in Excel (Surprising Results)

The video pits Claude, Tracelight, ChatGPT and Microsoft Copilot against each other in Excel, testing five real‑world tasks from PDF balance‑sheet extraction to error detection in complex financial models. Across the board the tools diverge on speed, accuracy and presentation. Tracelight...

By Kenji Explains
I Tried 100+ AI Tools. These Are the Best for Finance
VideoMar 15, 2026

I Tried 100+ AI Tools. These Are the Best for Finance

The video walks viewers through a curated suite of AI applications that cover every stage of a financial analyst’s workflow, from initial company research to the final pitch‑deck. It highlights tools such as FinTool for investment thesis drafting, AlphaSense for...

By Kenji Explains
Build INSANE Financial Models With This AI Tool
VideoMar 8, 2026

Build INSANE Financial Models With This AI Tool

Trace Light is an AI‑powered Excel add‑in designed for consulting, banking and private‑equity professionals, promising to turn raw spreadsheets into polished financial models in seconds. The video walks through five escalating use‑cases—from basic formatting to a full discounted cash‑flow valuation—showcasing...

By Kenji Explains
Make a Cohort Analysis in Excel
VideoFeb 22, 2026

Make a Cohort Analysis in Excel

The video walks viewers through constructing a dynamic cohort analysis template in Excel, enabling businesses to track customer behavior, revenue generation, and acquisition profitability across monthly cohorts. It begins by defining assumptions—initial customers, month‑over‑month growth, average revenue per user, acquisition cost,...

By Kenji Explains
Create Clickable Tabs Inside an Excel Sheet
VideoFeb 15, 2026

Create Clickable Tabs Inside an Excel Sheet

The video demonstrates how to build fully clickable, color‑changing tabs inside a single Excel worksheet, turning a static table into an interactive budget dashboard. The process starts by converting raw data into an Excel table (Ctrl T), naming a cell “selected_month”, and...

By Kenji Explains