스킬 찾기

Analyze Excel data by classifying items, calculating counts and percentages, and comparing categories across groups. Identify values above related limits, then produce a pie chart and an Excel statistics file with download links.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Summarizing category counts and percentages
• Comparing categories across regions or other groups
• Finding values that exceed related limits

Analyze Excel workbooks across multiple sheets, locate matching fields, clean values, and compare groups. Produce counts, cross-tabulations that compare categories, charts, and an Excel report with a download link.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Count matching fields across multiple sheets
• Clean numeric values and merged-cell groups
• Compare counts and shares by category

Clean a target Excel column, convert its values to numbers, and compare the calculated total with a summary sheet. Export the totals, match status, and difference in Excel and CSV files.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Standardize numerical formats before calculating a column total
• Check detail totals against a summary sheet
• Export reconciliation results to Excel and CSV

Filter Excel data using candidate column names, RGB color values, text prefixes, and regular expressions, which match text patterns. Calculate totals and averages, then export results to Excel with highlighted rows and a download link.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Filtering rows by RGB values or identifier prefixes
• Converting text to numbers and calculating totals or averages
• Extracting matching commands with their identifiers and descriptions

Calculate averages for selected groups in Excel and sum items extracted from specified row ranges after removing duplicates. Save filtered records, summary statistics, and item totals as Excel files with local download links.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Calculate average scores for a selected class
• Sum equipment power values without duplicate items
• Export filtered records and summary statistics

Clean Excel data, summarize groups, and examine relationships between numeric columns. Produce charts such as scatter plots with trend lines, calculate measures of fit and statistical significance, and export cleaned data and statistical summaries.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean missing group labels and numeric text
• Compare group averages and variation
• Analyze numeric relationships with scatter plots and trend lines

Count rows across Excel sheets to assess data size, then analyze an existing Parquet file, a format for storing tabular data. Calculate category counts and percentages, and save the results as an Excel summary and a pie chart.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Counting rows across every sheet in an Excel workbook
• Calculating category counts and percentages from Parquet data
• Creating a pie chart of category proportions

Extract selected ranges from Excel workbooks with multiple sheets, check missing values, and clean numeric data. Fit a straight trend line, save charts and CSV results, and convert larger tables to Parquet for subsequent analysis.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Checking missing values and category counts in a selected sheet
• Extracting numeric pairs from selected rows and columns
• Creating a scatter plot with a straight trend line

Analyze Excel data using custom categories, count distributions, and compare groups with charts. Score text using its length, technical terms, numbers, and selected complex concepts, then visualize difficulty levels and the relationship between text length and scores.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Summarize Excel records using custom categories
• Compare category distributions across groups
• Score and grade text using adjustable rules

Analyze one Excel worksheet by cleaning column names, extracting numbers, and handling gaps from merged cells. Create category counts, percentages, cross-tabulations comparing groups, high-resolution charts, and CSV exports, with Parquet storage for the data.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean worksheets containing merged cells
• Summarize category counts and percentages
• Compare groups with cross-tabulations

Clean categorical Excel data and compare counts and percentage shares across groups. Create cross-tabulation tables, heatmaps that show differences through color, and category rankings, then export the analysis to a workbook with multiple sheets.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Compare award distributions across organizations
• Visualize category shares with a heatmap
• Identify leading groups within each category

Analyze Excel files with 10,000 or more rows using reading methods suited to their size. Convert data to Parquet, a column-based storage format, reduce memory use, and prepare summaries, charts, or filtered exports.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Summarizing regional sales from 100,000 rows
• Exporting high-value transactions from a million-row log
• Speeding up repeated analysis with Parquet

Analyze trends and group performance in Excel data, clean percentage values, and calculate projections using growth rates assigned by performance tier. Produce comparison charts and a summary of current totals, projected totals, and growth.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Track changes in business metrics over time
• Compare performance across departments or categories
• Estimate growth using rates assigned by performance tier

Extract and analyze text, tables, numbers, and charts from Word, PDF, and PowerPoint documents. Process complete files or document collections, aggregate findings, and verify counts, calculations, and units before presenting answers.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Extract tables and numbers from reports
• Compare and summarize multiple documents
• Read scanned PDFs and image-only slides

Analyze Excel datasets totaling at least 10,000 rows using an existing Parquet file, a column-based data format. Extract a chosen metric, identify the category with the highest value, and export an Excel summary with that row highlighted.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Counting rows across multiple Excel sheets
• Extracting a chosen metric from a large dataset
• Finding the category with the highest value

Analyze a selected entity’s time series in Excel, calculate its average, and export a formatted report showing differences from that average. Rows below the average are highlighted in green for easy comparison.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Highlight periods with values below the average
• Report a selected entity’s time series
• Check the total row count across Excel sheets

Extract coefficients associated with a chosen label across Excel sheets and check them against a standard value. Create a comparison workbook showing each value, its source sheet, and red highlighting for rows that fail the check.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check coefficients across multiple Excel sheets
• Find values that differ from a specified standard
• Compare sheets with different column layouts

Organize Excel analysis from reading multiple sheets through cleaning, filtering, aggregation, and export. Choose processing methods based on row counts, and use supporting skills to produce tables, charts, and Excel or CSV reports.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean missing values and inconsistent text in Excel
• Filter and aggregate data across multiple sheets
• Analyze large spreadsheets using row-based processing strategies

Compare counts and shares for two categories in Excel data. The skill cleans the selected columns, calculates differences and percentages, and produces a summary spreadsheet plus bar and pie charts.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing counts for two categories
• Visualizing category shares
• Cleaning merged-cell data before counting

Check Excel measurements against limits written in the sheet, highlight rows exceeding those limits and cells containing division errors, and export a summary showing structure names, measured values, limits, and differences.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Find measurements exceeding limits in Excel
• Highlight cells containing division errors
• Export a summary of values exceeding limits

Combine selected data from multiple Excel sheets, clean numeric values, and extract the highest entries for a chosen metric. Create a ranked Excel report with highlighted columns, borders, column widths, and number formats for easier comparison.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Extract the top entries for a chosen metric
• Combine selected columns from multiple sheets
• Create a ranked Excel report with highlighted values

Extract text and data from images of charts, tables, interfaces, and diagrams using a vision model, an AI that reads images. Turn the results into structured tables, recreate charts, or export data to Excel and CSV.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Convert a table screenshot into Excel or CSV
• Extract values from a chart and recreate it
• Describe the layout and components of a UI screenshot

Extract key metrics from spreadsheet data, check whether recorded values match calculations after unit conversion, and rank selected metrics from highest to lowest. Export the ranking or validation results to an Excel file for download.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check calculations involving different units
• Rank business metrics from highest to lowest
• Export validation results to Excel

Clean category data in Excel, group entries, and calculate counts, totals, and shares. Create a summary spreadsheet with a total row and highlighted maximum values, alongside a bar chart for comparing groups.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Cleaning category labels before analysis
• Combining labels into defined groups
• Calculating group counts, totals, and shares