583 skills · sorted by relevance
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.
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.
Clean numeric columns in Excel, filter records above a chosen threshold, and count matching rows. The skill also covers checking row totals across sheets and marking qualifying cells with formatting for export.
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 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.
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.
Route document tasks to specialized skills for PDFs, Word files, spreadsheets, slides, or posters. Clarify the required format, sequence multiple outputs, preserve supplied templates, and report file locations with practical checks for reviewing the results.
Process PDF documents by extracting text, tables, and images, merging or splitting files, rotating pages, creating documents, and filling forms. It also covers password protection and OCR, which recognizes text in scanned pages to make them searchable.
Turn company documents, public filings, and other sources into structured Excel workbooks for investment review. Organize financial statements and operating metrics, document sources and adjustments, and check that calculations and statements reconcile.
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.
Prepare raw credit data for pre-loan modeling by checking data quality and screening variables. Review missing values, predictive usefulness, stability, noise, and correlation, then export an Excel report with organization-level statistics and cleaning results.
Extract text from PDFs, Office documents, images, spreadsheets, and text files through one tool. Results share a common JSON structure, supporting document summaries, contract checks, and spreadsheet previews, with optical character recognition for scanned content.
Examine suspicious Word, Excel, and PowerPoint documents by extracting macros and untangling code designed to hide its purpose. Identify download addresses, execution triggers, and attack steps, then document findings and indicators for detecting related threats.
Create and edit Excel workbooks for data analysis, reports, and financial models. Build formulas that update with inputs, organize sheets, add charts and interactive pivot tables, and recalculate the workbook to check for formula errors.
Create and edit spreadsheet files, clean messy tables, and convert tabular formats. Add formulas, formatting, and charts while following existing template styles, then recalculate formulas and check for errors before delivering the spreadsheet.
Process Excel workbooks and generate PDF reports by running Python scripts directly. Covers multiple sheets, data transformations, formatting, and error handling, with scripts saved as files for complex tasks.
Audit an Excel workbook before editing, then verify the saved file with Python and openpyxl. Each requested requirement receives an explicit status, so completion depends on checks of the actual file.
Process Excel files with Python after checking that input files and source URLs are accessible. The workflow covers data transformations, formulas, and formatting, with alternative sources and error logs when access fails.
Validate spreadsheet sources before running Python scripts to transform data, update multiple sheets, or apply formatting. Check required data first, try backup sources when needed, and report errors clearly if processing cannot proceed.
Process Excel workbooks by saving Python scripts to files and running them through the shell. Covers multiple sheets, data transformations, formulas, formatting, and error reporting for complex spreadsheet tasks.
Process Excel workbooks and generate PDF or Word documents by running Python scripts directly through run_shell. The skill covers multi-sheet edits, formatting, data transformations, document layout, and error handling for complex tasks that can exceed agent step limits.
Extract data from Excel sheets with misplaced headers, merged header cells, or introductory rows. Uses text patterns to locate headers, clean column names, and remove empty rows so the data can be processed with pandas.
Update copies of public-company Excel models using financial disclosures and mapped input cells. Deliver an updated workbook or review workbook, with source references, change logs, unresolved items, and implications for estimates and valuation where the model supports them.
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.