Domain 2 · Task Statement 2.3

Professional Document Creation

TL;DR

Master Cowork's ability to produce fully functional Excel workbooks, formatted Word documents, structured PowerPoint decks, and PDF reports — all delivered directly to your file system with working formulas, conditional formatting, and charts.

What You Need to Know

Most people try document creation in Chat once, get a flat CSV with no formulas, and assume that's the ceiling. It isn't even close.

Cowork creates real, fully functional business documents. Not text descriptions of what a document could contain. Not markdown approximations. Actual .xlsx workbooks with working VLOOKUP formulas that recalculate when you change a cell. Actual .docx reports with heading hierarchies, styled tables, and page breaks. Actual .pptx slide decks with title slides, data tables, and logical flow. Actual .pdf reports formatted for professional distribution.

The part that changes your workflow: those files land directly in your working folder. No download button. No "click here to save." You point Cowork at a directory, describe what you need, and the finished document appears on your file system like a colleague walked over and dropped it on your desk. Cloud sync picks it up. Your email client can attach it. The document is just there, ready.

Excel: Working Formulas, Not Static Values

The exam tests whether you understand the difference between Chat's output and Cowork's output. Chat generates files through its Analysis Tool — a download link in the conversation. Cowork writes files directly via its sandboxed VM, giving it full control over the binary format.

In practice: Cowork writes real Excel formulas. VLOOKUP, SUMIFS, INDEX-MATCH, IF, COUNTIFS. These aren't static values styled to resemble formulas. Open the file, change a source cell, and every dependent formula recalculates immediately. That distinction matters for any business deliverable — a finance team needs a spreadsheet that updates when new data arrives, not a screenshot of last month's numbers.

Cowork also builds multi-tab workbooks with cross-tab references. A "Revenue Summary" tab can pull from a "Raw Data" tab using SUMIFS, while a "Dashboard" tab generates charts from the summary. Conditional formatting highlights cells based on rules you specify — red for values below threshold, amber for approaching, green for on track. The data structures are pivot-table-ready, so you can apply pivot tables the moment you open the file.

[!]

Exam Trap: Static Values vs Real Formulas

A common distractor claims that Cowork-generated Excel files contain static values that merely resemble formulas. This is false. Cowork writes real, working formulas that recalculate when source data changes. If you see an option suggesting Excel output is "display-only" or "non-functional," reject it.

Word Documents: Structured, Not Just Written

When Cowork produces a .docx, it doesn't dump unstyled paragraphs into a file. It creates documents with proper heading hierarchies (Heading 1, Heading 2, Heading 3), so the navigation pane in Word works immediately. Bulleted lists, numbered lists, styled tables, page breaks between sections — all present.

A single prompt can produce a quarterly business review with a title page, executive summary, detailed findings with embedded data tables, recommendations section, and appendix. Consistent formatting throughout. The document lands directly in your working folder — open it in Word, Google Docs, or upload it to SharePoint. No intermediate steps.

PowerPoint: Structure First, Branding Later

Cowork creates .pptx files with logical slide structures: title slide, agenda, content slides with bullet points, data slides with tables or charts, and summary slides. Content accuracy, data integrity, and logical flow are strong.

What Cowork does not do is apply your corporate branding. No custom themes, no branded colour palettes, no logo placements, no font overrides. The slides arrive in default styling. This is a deliberate trade-off — Cowork gets the content right (structure, data, narrative arc) and leaves visual identity to you.

The expert workflow: treat Cowork's output as a content-complete first draft. Open it in PowerPoint, apply your corporate template via the Design tab, and you've got a presentation that took 3 minutes of prompting instead of 3 hours of manual work. The exam tests whether you understand this boundary.

[!]

Corporate Branding Requires Manual Application

If a question states that Cowork automatically applies your company's brand guidelines or templates to PowerPoint output, that is incorrect. Cowork produces structurally sound slides with default styling. Brand templates must be applied manually afterwards. The value is in the speed and accuracy of content generation, not visual polish.

PDF Reports: Read-Only, Professionally Formatted

When the deliverable needs to be read-only — client-facing summaries, compliance reports, board papers — Cowork produces formatted PDFs. Styled headings, tables, consistent layouts suitable for professional distribution. PDFs are the right choice when recipients need to see the document exactly as you intended, with no risk of accidental edits.

Direct File System Delivery: The Workflow Advantage

Easy to overlook, but this changes how document creation fits into your broader workflow. In Chat, generated files appear as download links inside the conversation window. You click the link, choose a save location, name the file, confirm. Every time. For one file, that's trivial. For a workflow that produces five documents from the same data set — an Excel tracker, a Word summary, a PowerPoint deck, a PDF for the client, and a CSV export — that's five separate download-and-file operations.

Cowork writes every file directly to your working folder the moment it's created. No download step. No manual filing. If your working folder syncs to OneDrive, SharePoint, Google Drive, or Dropbox, the files propagate automatically. A colleague needs the output? It's already where they expect to find it.

The exam frequently presents scenarios comparing Chat file delivery (download links) with Cowork file delivery (direct to folder). The correct answer: Cowork eliminates the manual download step and slots directly into existing file management workflows.

[!]

Exam Trap: File Format Capabilities

A distractor may claim Cowork can only produce text files and CSVs. This is false. Cowork creates binary formats including .xlsx, .docx, .pptx, and .pdf with full formatting, working features, and proper file structure. It doesn't require any special "Analysis Tool" toggle — that's a Chat-specific concept. Cowork uses its sandboxed VM directly.

The Specification Gap: Your Prompt Is the Blueprint

All the capabilities above are real. None of them activate automatically. The gap between a flat data dump and a professional deliverable isn't a Cowork limitation — it's a prompting gap.

"Create a spreadsheet" tells Cowork almost nothing. It doesn't know whether you want formulas, what kind, how many tabs, whether to include charts, what thresholds matter, or how to format the output. So it defaults to the simplest interpretation: data in cells. Done.

Compare that with: "Create Regional-Sales-Q1.xlsx with three tabs: Raw Data with SUBTOTAL per region, Dashboard with a stacked bar chart comparing revenue vs target, Alerts listing regions below 90% of target in amber and below 75% in red." That prompt produces a tool your leadership team can use in their next meeting.

The difference isn't Claude's capability. It's your specificity. Think of the prompt as a brief you'd hand to an analyst — the more precise the specification, the more professional the output. The exam tests this relentlessly through scenarios comparing vague prompts with detailed ones.

Common Mistakes

Common Mistake

Asking for 'a spreadsheet' without specifying formulas, tab structure, chart types, or formatting rules — then concluding Cowork can't produce professional Excel files.

Instead: Treat your prompt like a project brief: specify the file name, each tab and its purpose, which formulas to use (SUMIFS, VLOOKUP, IF), what conditional formatting rules to apply, and what charts to include. Output quality mirrors specification quality.

Common Mistake

Expecting Cowork to produce designer-quality PowerPoint presentations with corporate branding, custom fonts, and polished animations.

Instead: Use Cowork for content-complete first drafts — accurate data, logical structure, clear slide narrative. Then open the file in PowerPoint and apply your corporate template. You skip 90% of the manual work while keeping full control over brand identity.

Common Mistake

Creating documents in Chat mode (where they appear as download links) when the same task in Cowork would deliver files directly to your working folder.

Instead: Switch to Cowork for any document creation task. Files arrive in your working folder instantly — no download step — and integrate immediately with cloud sync, email clients, and the rest of your workflow.

Creating an expense tracking workbook

Before

Create a spreadsheet from this data.

After

Create an Excel file called Regional-Sales-Q1.xlsx with three tabs: (1) 'Raw Data' with all records and a SUBTOTAL formula per region, (2) 'Dashboard' with a stacked bar chart comparing revenue vs target by region, and (3) 'Alerts' listing every region where revenue is below 90% of target, highlighted in amber, or below 75% in red.

Building a presentation from quarterly results

Before

Make me a PowerPoint about our Q1 results.

After

Using the data in Q1-results.xlsx, create a 10-slide PowerPoint called Q1-Review.pptx. Structure: title slide, agenda, 3 slides covering revenue/growth/retention metrics with data tables, 2 slides on key wins with bullet points, 2 slides on challenges and recommendations, and a closing slide with next steps.

Hands-On Activity

Hands-On Activity

Create a Professional Excel Workbook

15 min

Build a multi-tab Excel workbook with working formulas, conditional formatting, and charts — then produce a Word executive summary from the same data. You'll see for yourself that Cowork creates functional business documents, not static data dumps.

What you will learn

  • Produce a multi-tab Excel workbook with working formulas using a single Cowork prompt
  • Verify that formulas recalculate when source data changes
  • Confirm that conditional formatting applies correctly based on threshold rules
  • Generate a formatted Word document from the same source data
  1. 01

    Create a folder called 'Document-Creation-Lab'. Place a sample CSV file inside it with at least 20 rows of data — columns for Date, Category, Vendor, and Amount. You can use real expense data, generate sample data, or download any publicly available expense dataset.

    Why: You need realistic source data for Cowork to transform. The exercise works best with enough rows to produce meaningful totals and show formula behaviour.

    Expected: A working folder with one CSV file containing structured data with at least four columns and 20+ rows.

  2. 02

    Open Cowork, select the 'Document-Creation-Lab' folder, and enter this prompt: 'Using the CSV file in this folder, create an Excel file called Professional-Report.xlsx with: (1) a Data tab containing all records with a SUM formula at the bottom of the Amount column, (2) a Pivot tab showing totals by Category using SUMIFS, (3) conditional formatting on the Data tab highlighting any amount over $200 in red, and (4) a Chart tab with a bar chart comparing category totals.'

    Why: This single prompt tests four capabilities at once: formula writing, cross-tab aggregation, conditional formatting, and chart generation. Watch how Cowork's execution plan breaks it into discrete steps.

    Expected: An execution plan showing steps to read the CSV, create the workbook, build each tab, write formulas, apply formatting, and generate the chart.

  3. 03

    Allow the plan to execute, then open Professional-Report.xlsx in Excel or Google Sheets. Go to the Data tab, change any value in the Amount column, and verify that the SUM formula at the bottom recalculates. Then check the Pivot tab to confirm the SUMIFS also update.

    Why: This proves Cowork writes real working formulas, not static values. If the totals update when you change source data, the formulas are functional. This distinction is tested heavily on the exam.

    Expected: Changing a value in the Data tab causes the SUM to update immediately. The SUMIFS on the Pivot tab recalculate to reflect the change. Conditional formatting correctly highlights amounts over $200 in red.

  4. 04

    Return to Cowork and prompt: 'Using the same data, create a one-page Word document called Executive-Summary.docx with a title, a 3-paragraph summary of spending trends, and a table showing the top 5 vendors by total spend.'

    Why: This shows Cowork switching output formats while working from the same source data. The Word document should have proper heading styles, structured paragraphs, and a formatted data table.

    Expected: A formatted .docx file in your working folder with a styled title, three coherent paragraphs analysing spending patterns, and a table listing the top 5 vendors with their total spend amounts.

Practice Question

Practice Question

A finance team lead needs a monthly expense tracker that automatically calculates category totals, flags any expense over $500 with red highlighting, includes a pie chart showing spending by category, and has separate tabs for each cost centre. Which approach produces the best result?

Sources