Results for “formulas”

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

The English summary is being prepared. Showing the original description.

Create, edit, and analyze spreadsheet data in XLSX, CSV, or TSV formats, including workbook formulas and charts. The workflow emphasizes clear table headers, formulas that can be reviewed, and verification of key cells and totals after reopening.

• Create a table with clear headers
• Edit and analyze XLSX, CSV, or TSV data
• Review workbook formulas and charts

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

• Checking formulas in a selected range
• Investigating a balance sheet that does not balance
• Reviewing a financial model before client delivery

Create, edit, repair, and convert spreadsheet files, including Excel and CSV. This skill covers cleaning messy tables, adding formulas and charts, preserving existing formatting, and recalculating formulas to check for spreadsheet errors.

• Cleaning messy CSV data into a spreadsheet
• Adding formulas and charts to an existing workbook
• Creating a financial model with editable assumptions

Compare nine methods for setting priorities, including RICE and ICE, which score ideas using factors such as impact and confidence. Use formulas, selection guidance, and linked templates to choose an approach for customer problems, initiatives, or requirements.

• Choosing a method for setting priorities
• Comparing RICE and ICE
• Ranking customer problems by importance and satisfaction

Create and edit 飞书 spreadsheets, summarize data, build charts, and verify formulas. Adjust formatting, import or export Excel and CSV files, and review version history for routine reporting and financial modeling.

• Summarize sales data with charts and pivot tables
• Adapt Excel formulas for 飞书 spreadsheets
• Standardize formatting across worksheets

Build and validate Obsidian Bases files that display notes as tables, cards, or lists. Define filters, calculated values, displayed properties, and summaries to create reading lists, task trackers, and other database-like views of existing notes.

• Creating a reading list from existing notes
• Building task views filtered by status
• Checking formulas and displayed properties

Quickly look up SaaS financial metrics, including recurring revenue and customer acquisition costs. Get definitions, formulas, benchmarks, and warning signs, plus reminders of which metrics matter when reviewing features, pricing, acquisition channels, or business health.

• Looking up NRR formulas and benchmarks
• Preparing a SaaS metrics sheet for a business review
• Checking metrics before expanding an acquisition channel

Analyze and update connected Google Sheets using precise tabs and cell ranges. Find spreadsheets, search rows, clean tables, repair formulas and charts, or create a new spreadsheet from data or an existing template.

• Clean and restructure an existing table
• Repair formulas and charts
• Create a spreadsheet from a template

Use this skill whenever the user asks for an Excel spreadsheet, a .xlsx file, or a workbook with formulas/pivots/multiple sheets — creating one from scratch or editing an existing one. Covers the rule that computed values must be written as real Excel formulas (never hardcoded numbers), and a static formula-safety check. Formulas are NOT recalculated in this environment — see 'Not supported'.

The English summary is being prepared. Showing the original description.

Audits business spreadsheet models (.xlsx, .xlsm, or Google Sheets exported to .xlsx) for structural integrity errors and explains each fix -- budgets, forecasts, pricing models, commission calculators, FP&A packs, ops trackers, not only banking models. A bundled openpyxl script finds hardcoded numbers inside formulas, typed values pasted over formulas, inconsistent formulas across a row or column,

The English summary is being prepared. Showing the original description.

Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.

The English summary is being prepared. Showing the original description.

Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.

The English summary is being prepared. Showing the original description.

Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.

The English summary is being prepared. Showing the original description.

Create, inspect, and edit Excel workbooks using Python helper scripts. Build formatted reports with multiple sheets, formulas, and charts, update existing tables, adjust references during structural changes, and convert data between Excel and CSV.

• Creating formatted Excel reports with charts
• Inspecting workbook data and formulas
• Adding rows or changing a table's structure

Create HTML presentations for marketing, pitches, and data-driven explanations. Use Chart.js graphs, reusable design settings, responsive layouts, and writing formulas to shape slide content and choose layouts suited to the presentation's purpose.

• Creating marketing presentation slides
• Building a pitch deck
• Explaining data with Chart.js graphs

Create, edit, and inspect spreadsheets for reusable budgets, models, and trackers. Check formulas and dependent totals, preserve unrelated data, and deliver an editable workbook or a link to the updated native spreadsheet.

• Build a monthly headcount budget
• Investigate an incorrect quarterly total
• Fix formulas and highlight changed cells

Create and edit Obsidian Bases files to organize notes into tables, cards, and lists. Filter notes by tags or properties, calculate values such as days until a deadline, and configure grouping and summaries.

• Build a task table with deadlines and status
• Organize books and articles into reading cards
• Create an index of daily notes

Complete Excel templates for leveraged buyouts, acquisitions financed partly with debt. Add linked formulas for funding, operations, debt repayment, and investment returns, then check calculations and formatting while reviewing each major section with the user.

• Completing an existing Excel buyout model template
• Checking funding totals and debt repayment priorities
• Calculating investment returns for committee materials

Review DAX formulas, the expressions used for calculations in Power BI, and propose clearer, more maintainable alternatives. Identify repeated calculations, costly filtering, and error-handling issues, then explain changes and recommend ways to test them.

• Reviewing slow calculations in Power BI reports
• Making complex DAX formulas easier to read
• Improving division and blank-value handling

Plan Chinese math tutorial videos with clear solution steps, spoken explanations, readable formulas, and matching subtitles. The skill guides lesson structure and pacing, while Creator’s native tools build the visuals, narration, and finished video.

• Planning a Chinese equation tutorial
• Explaining geometry one step at a time
• Matching math narration with formulas and subtitles

Create, inspect, and update Excel workbooks, including CSV imports, formulas, charts, and pivot tables that summarize data. Build budgets, dashboards, or trackers with readable formatting, input validation, and checks for formula errors.

• Converting CSV or TSV data into formatted Excel workbooks
• Building budgets and forecasts with adjustable assumptions
• Creating dashboards with charts and pivot tables

Create or improve a company-specific data analysis skill by gathering analysts’ knowledge and examining database structures. Document business terms, metric formulas, table relationships, and common query patterns in reusable reference files.

• Create a data analysis skill for a company
• Document metric formulas and standard exclusions
• Add knowledge about a new business domain

Review game data and formulas for combat, economy, progression, or loot. Compare values with documented targets, identify dominant strategies and broken resource loops, and produce prioritized adjustment recommendations while clearly marking areas that lack enough data.

• Comparing weapon damage and combat effectiveness
• Finding resource loops and pricing problems
• Reviewing experience and power progression