IB Pitch Deck Template Populator
Populate investment banking pitch deck templates with financial data, ensuring number consistency, proper formatting, and institutional presentation standards.
Populating a pitch deck template with live deal data means hours of copy-paste between Excel and PowerPoint, manually checking that the same revenue figure matches across 15 slides -- and one inconsistency can undermine your credibility in the room.
Who it's for: investment banking analysts, associates, vice presidents, managing directors
Example
"Populate this pitch deck template with data from our source Excel file" → Completed pitch deck with all placeholder sections filled, numbers cross-checked across slides, tables formatted as proper objects, and professional presentation standards applied
CLAUDE.md Template
New here? 3-minute setup guide → | Already set up? Copy the template below.
npx ccplaybooks add ib-pitch-deck# Populating Investment Banking Pitch Deck Templates
Populates investment banking pitch deck templates with data from source files. Use when: user provides a PowerPoint template to fill in, user has source data (Excel/CSV) to populate into slides, user mentions populating or filling a pitch deck template, or user needs to transfer data into existing slide layouts. Not for creating presentations from scratch.
## Reference Files
**Read all reference files at task start before beginning any work.** These contain critical patterns and anti-patterns that will affect your approach. Do not wait until you encounter issues.
| File | Purpose |
|------|---------|
| `formatting-standards.md` | Text, bullets, tables, charts, alignment |
| `slide-templates.md` | Content mapping guidance for common slide types |Get new playbooks like this one
One email a week with new Claude Code workflows. Free, like everything here.
No spam. Unsubscribe anytime.
What This Does
This playbook populates investment banking pitch deck templates with financial data from source files (Excel, CSV, PDF). It follows a 5-phase workflow -- data extraction, content mapping, template population, validation, and final verification -- to ensure number consistency, proper formatting, and institutional presentation standards across every slide.
Note: This is for populating existing templates with data, not for creating presentations from scratch.
Quick Start
Step 1: Create a Project Folder
Create a folder for your deal workspace and place the downloaded template inside as CLAUDE.md.
mkdir -p ~/Documents/PitchDeck-ProjectNova
Step 2: Download the Template
Click Download above, then move the file into your project folder as CLAUDE.md.
mv ~/Downloads/ib-pitch-deck.md ~/Documents/PitchDeck-ProjectNova/CLAUDE.md
Step 3: Add Your Files
Place these in the same folder:
- PowerPoint template (.pptx) to be populated
- Source data files (Excel, CSV, PDF)
- Any reference files mentioned in the template (formatting standards, slide templates, etc.)
Step 4: Start Working
cd ~/Documents/PitchDeck-ProjectNova
claude
Try prompts like:
"Populate this pitch deck template with data from the source Excel file"
"Fill in the market overview slides using the industry report PDF"
"Update all financial tables to reflect the latest Q4 numbers"
"Validate that revenue figures are consistent across all slides"
5-Phase Workflow
| Phase | Purpose |
|---|---|
| 1. Data Extraction | Extract and validate data from source materials |
| 2. Content Mapping | Map source data to template placeholder sections |
| 3. Template Population | Fill slides with data, apply formatting |
| 4. Validation Loop | Convert to images, check, fix, repeat (up to 3 cycles) |
| 5. Final Verification | Run quality checklist before delivery |
Critical Anti-Patterns to Avoid
- Do not populate data INTO colored placeholder boxes -- the placeholder tells you what content goes there; replace it with properly formatted content
- Do not create text-based tables using pipes or tabs -- always use actual PowerPoint table objects
- Do not inherit placeholder contrast -- production slides typically use dark text on light backgrounds
Formatting Standards
| Element | Typical Size | Style |
|---|---|---|
| Slide title | 40-48pt | Bold |
| Section header | 14-16pt | Regular |
| Body text | 11-14pt | Regular |
| Table header | 10-12pt | Bold |
| Table body | 9-11pt | Regular |
| Footnotes | 8-9pt | Italic |
Tips and Best Practices
- Always back up the original template before making any modifications
- Cross-slide consistency is critical -- the same metric must show the same number on every slide where it appears
- Tables must be actual table objects, never pipe-separated or tab-separated text
- Validate visually by converting slides to images after population
- The final file should be reviewed in Microsoft PowerPoint before distribution, as LibreOffice rendering may differ
- Include source citations in slide footnotes for all data points
Example Prompts
"Populate the situation overview slide with the company description and key metrics"
"Fill in the comparable companies table from the comps Excel sheet"
"Update the football field valuation slide with the latest ranges"
"Check all slides for number consistency and flag any mismatches"
"Format the financial summary table to match the template styling"