스킬 찾기

Create, edit, and analyze spreadsheets with formulas, formatting, and visualizations. Preserve existing workbook conventions, keep calculations responsive to input changes, and use formula recalculation and error checks to verify the resulting files.

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

• Create a spreadsheet with formulas and formatting
• Update an existing workbook while preserving formulas
• Analyze and visualize Excel or CSV data

Bring articles, YouTube videos, documents, and other sources into NotebookLM to create audio, slides, reports, and study materials. It also supports deeper analysis through a series of questions, with optional export to 飞书 documents.

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

• Turn an article into audio for commuting
• Create slides from articles, videos, and PDFs
• Generate quizzes and flashcards for review

Check whether tools for mathematical modeling, numerical analysis, charts, and paper compilation are installed. Get a report separating required and optional dependencies, platform-specific installation commands, and a follow-up check after approved installation.

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

• Preparing a computer for mathematical modeling
• Checking missing paper compilation and charting tools
• Installing required dependencies after reviewing the commands

Organize Nexent test assets into a traceable chain from requirements and bugs to cases, scripts, and results. Review existing coverage, maintain execution settings, and generate a registry and Excel views for formal testing.

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

• Designing test cases for new requirements
• Reviewing regression coverage after a bug fix
• Adding missing tests after development

Develop and fix Nexent features by connecting written specifications, acceptance criteria, implementation, and verification evidence. Plan unit tests and appropriate staged checks, maintain their links to requirements, and fill confirmed test gaps after development.

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

• Planning and implementing features from acceptance criteria
• Fixing bugs using existing specifications and tests
• Refactoring while preserving required behavior

Turn research results into figures and tables for papers using pubfig and pubtab. Choose an appropriate presentation, convert Excel tables to LaTeX, export assets, and check readability, labels, and consistency before submission.

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

• Choosing a chart that communicates research findings
• Converting an Excel table to LaTeX for a paper
• Preparing a summary figure with a companion table

Filter rows from Excel or previously converted Parquet files, a format designed for efficient data storage. Summarize matching records by group with counts, percentages, and totals, then export the summary to Excel.

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

• Count records containing a specified risk level by work category
• Calculate group shares among matching records
• Summarize large datasets already converted to Parquet

Analyze large Excel workbooks by totaling values by category and identifying the highest result. The workflow can convert data to Parquet, a column-based storage format, and export a styled Excel report with highlighted results.

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

• Assessing row counts across workbook sheets
• Converting large datasets to Parquet
• Finding the category with the highest total

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

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

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

Inspect multi-sheet Excel files, use Parquet, a column-based file format, for larger datasets, and clean text before analysis. Produce category summaries, identify maximum values, and export formatted reports or scatter plots with fitted straight trend lines.

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

• Assess data volume in multi-sheet Excel files
• Clean unwanted characters from text columns
• Summarize categories and highlight the maximum

Scan multiple Excel sheets for rows with missing or invalid entries in a target column. Combine matching records with their source sheet names, then export an Excel file with every extracted data row filled red for review.

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

• Find missing entries across multiple Excel sheets
• Create a review list with source sheet names
• Export matching rows with red highlighting

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

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

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

Process multi-sheet Excel data by finding columns through keywords and counting specified values. Clean text fields to retain Chinese characters, then export the processed data as an Excel file with its size and download link.

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

• Finding a target column by a keyword in its name
• Counting specified values across Excel sheets
• Extracting Chinese characters from mixed text

Clean data across multiple Excel sheets, compare totals between sheets, and summarize categories and proportions. Create charts and export a formatted workbook with unusual values highlighted for review.

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

• Comparing totals across Excel sheets
• Cleaning inconsistent text and blank cells
• Charting category counts and proportions

Combine selected columns from multiple Excel sheets, fill blank category cells with the preceding value, and rank records by a chosen metric. Export the top results to an Excel report with headings, borders, and formatted numbers.

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

• Combine metrics stored on separate Excel sheets
• Fill category gaps caused by merged cells
• Extract the top records by a selected metric

Find key figures in tabular data using column names or row keywords, calculate category averages and percentages, and export the results as a structured Excel report and a pie chart.

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

• Find figures using keywords in rows
• Calculate averages for a selected category
• Calculate one figure as a percentage of another

Filter Excel rows using conditions across several numeric columns. Count rows across sheets, convert selected fields to numbers, remove duplicate rows and records with missing identifiers, then export the filtered results to a new workbook.

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

• Extract rows where several numeric columns are zero
• Clean numeric fields before filtering
• Remove duplicate rows and missing identifiers

Turn Excel or CSV data into an Excel report with category totals, percentage shares, and a doughnut chart. The workflow identifies likely category and numeric columns, cleans missing values, and highlights the largest share.

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

• Compare spending shares by category
• Summarize quantities or scores by category
• Create an Excel report with a doughnut chart

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

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