Claude Skills by andreworia

Construct a clean trading comps universe with disciplined peer selection, calendarization, EBITDA adjustments, and outlier treatment. Use when building the comps page of a valuation deck, framing a minority valuation reference, or pressure-testing a public-market reference range. Built around peer comparability, metric normalization, and the difference between a peer and a peer-shaped distractor.

Build a defensible valuation range across DCF, trading comps, precedent transactions, LBO, and premiums paid. Use when pricing a sell-side mandate, framing a buy-side bid, preparing a fairness-style readout, or pressure-testing an IC valuation page. Built around methodology triangulation, the football field, and the bridge from enterprise value to equity value per share.

Reads industry structure with Porter's Five Forces and profiles rivals on capability and cost, giving a clear view of who you compete with and how attractive the industry really is.

Decomposes cost changes into volume, rate, and mix effects to identify the true root cause of cost escalation or decline.

Builds an answer-first plan by stating disprovable hypotheses and, for each, the "what would prove me wrong" test and the exact analysis that settles it, so the team tests instead of boiling the ocean.

Turns raw findings into ranked insights by laddering each finding up the so-what chain from observation to implication to the action it demands.

Decomposes one big question into a MECE issue tree or hypothesis tree of testable sub-questions, with branches ranked by impact so the team analyzes what matters first.

Prepares for a hostile room by pre-morteming the pushback, surfacing the hardest questions your recommendation will face, and drafting a tight, evidence-backed answer to each.

Turns a vague symptom or an over-broad brief into a one-page SCQA problem statement and a single decision-shaped key question the work must answer.

Maps a core process end to end with Lean value-stream analysis and redesigns it to remove waste and fix broken handoffs.

Structures an argument using the Pyramid Principle and SCQA so the recommendation lands in the first 60 seconds, with every supporting line grouped MECE beneath one governing thought.

Builds a linked strategy choice cascade (winning aspiration, where to play, how to win, capabilities, management systems) so a direction is coherent and internally reinforcing, not a list of ideas.

Builds a zero-based budget for a cost center by requiring every line item to be justified from first principles rather than rolled forward from the prior year.

Creates a structured assumption register for any Excel model with columns for name, category, base value, source, Bull/Bear values, sensitivity rank, and owner, plus a formula for computing sensitivity rank from Data Table outputs.

Turns pasted or exported data with mixed formats, blank rows, or duplicates into a clean, consistently formatted range ready for analysis. Use it right after pasting raw data into a worksheet.

Provides a systematic audit checklist for Excel model formula logic, hardcoded values, circular references, and error handling, with step-by-step instructions for using Excel's native auditing tools.

Enforces the three-tab separation principle for any Excel model, producing a full design for a dedicated Inputs tab, one or more Calculations tabs, and a clean Outputs tab with a conventions checklist.

Defines the master tab structure, naming conventions, color codes, number formats, and print area setup for any new strategy or finance Excel model, serving as the structural template before any content is added.

Designs the executive summary tab of an Excel model with KPI tiles, a narrative block, a sensitivity summary, and an assumption log, formatted for print or screenshot use in a board pack.

Specifies and builds a pivot table from a flat data range, choosing rows, columns, values, and filters. Use it when you have raw tabular data and need a summary view without building it cell by cell.

Builds a driver-based revenue forecast .xlsx with live formulas across separate drivers, build, and output tabs plus checks, rolling a customer or units schedule (beginning, adds, churn, ending) into revenue with Base/Bull/Bear scenario toggles. Use when someone needs a bottom-up revenue model, an ARR build, or a driver-based forecast for planning or a board deck. Do not trigger for editing an existing workbook through the Claude for Excel add-in.

Builds a Base/Bull/Bear scenario switching layer for a model in a .xlsx with a live selector, CHOOSE or INDEX assumption links, a side-by-side output comparison, and a recalc check, then delivers the workbook. Use when someone wants an auditable scenario toggle instead of Excel's hidden Scenario Manager. Do not trigger for editing an existing workbook through the Claude for Excel add-in.

Builds one- and two-variable sensitivity (Data Table) analysis on a model output in a .xlsx with live formulas and a recalc check, then delivers the workbook. Use when someone wants to see how an output (NPV, IRR, EPS, margin) moves as one or two inputs change. Do not trigger for editing an existing workbook through the Claude for Excel add-in.

Ranks variable sensitivities to a key output and builds a tornado chart by swinging each input over a defined range, computing output impact, and producing a horizontal bar chart data structure.

Builds a unit-economics and cohort .xlsx with live formulas across separate assumptions, cohort, and output tabs plus checks, computing CAC, LTV, LTV/CAC, and CAC payback from a monthly cohort retention grid. Use when someone needs unit economics, an LTV/CAC analysis, a payback model, or a cohort retention build. Do not trigger for editing an existing workbook through the Claude for Excel add-in.

Rewrite topic-label slide titles into headline action titles that state the so-what. Use when titles name the subject instead of delivering the message.

Structure the through-line of a board pack using SCQA and the Pyramid Principle so the deck argues one clear story instead of reporting disconnected pages.

Turns a raw chart into a message-driven exhibit by adding the action title, the one highlight, the labels that matter, and removing everything that does not serve the point.

Picks the right chart type for your data and your message using a decision tree, so the chart proves the point instead of just showing numbers.

Applies color to a chart so it encodes meaning and directs attention, using preattentive contrast, sequential and categorical palettes, and accessibility checks.

Strips non-data ink from charts and slides using the data-ink ratio principle, so the remaining marks all carry meaning and the slide reads cleaner.

Build the decision page that converts the recommendation into a specific, votable ask, with options considered, the recommended option, and what approval commits the board to.

Build the one-page executive summary that opens a board pack, stating the governing thought, the three to five proof points, and the ask so a director who reads only this page is fully informed.

Designs a clean framework slide (2x2, value chain, process flow, pyramid, matrix) that communicates a structured idea without clutter or false precision.

Produces a ghost deck (skeleton) of empty slides with action titles and exhibit placeholders, so the storyline is agreed before any time is spent on design.

Runs a deck through a partner-grade review checklist covering story, titles, exhibits, layout, and consistency, returning a prioritized fix list before review.

Builds waterfall (bridge) charts that explain how a starting value became an ending value through a sequence of additions and subtractions.

Audits a finished deck against the brand and template and returns a flagged list of every off-brand and off-template element.

Restricts a deck to the approved brand palette with one accent rule so slides stop drifting into off-brand or rainbow colors.

Constructs a corporate .potx from nothing — slide master, layout set, theme colour and font schemes, placeholders — so decks built on it inherit the brand automatically. Not for fixing a deck against a template that already exists.

Cuts a bloated .pptx down by finding what is actually heavy — cropped pixels, uncompressed images, embedded media, orphan masters — and removing it without visible quality loss. Not for speeding up a slow-running animation.

Turns a block of Excel or pasted data into a clean, native, editable PowerPoint chart rather than a pasted image or screenshot.

Embeds the brand fonts in a .pptx and sets a fallback stack so the deck does not reflow on a machine that lacks them. Not for choosing the typefaces or the type scale.

Restores a consistent grid, even margins, and a respected safe zone so elements stop drifting past the template's edges.

Unifies mismatched icons into one consistent system in the brand style, matching weight, fill, corner, and color.

Applies a single image treatment, aspect ratio, and duotone or filter rule so photos stop clashing in crop, color, and style.

Restores the correct logo lockup with brand clear space and minimum sizing wherever the wrong logo, color, or crop appears.

Maps every slide onto the correct master layout with the right placeholders so the deck is structurally on-template before any styling.

Moves floating text and objects into the layout's real title, body, and content placeholders so the deck inherits template styling automatically.

Converts slide size and aspect ratio and exports a deck to PDF, image, or video with the settings that survive the trip. Not for designing the slides themselves.