skills.rest
euwebertdefreitas
euwebertdefreitasCOMMUNITY
Explore all skills by this author →
Website𝕏@euwebertfreitasGitHub

Spreadsheet Expert Pro

Assist with spreadsheet manipulation, data analysis, and automation across Excel, Google Sheets, and LibreOffice Calc.

Updated Aug 27, 2026
Search Tags:#python#data analysis#macros#pandas#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/euwebertdefreitas/Parametrus-AI-Skills --skill spreadsheet-expert-pro
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Spreadsheet Expert Pro
Source: https://github.com/euwebertdefreitas/Parametrus-AI-Skills/tree/main/.agent/skills/spreadsheet_expert_pro
Command: npx skills add https://github.com/euwebertdefreitas/Parametrus-AI-Skills --skill spreadsheet-expert-pro

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill tackles the complexities of spreadsheet software, enabling users to efficiently manage, analyze, and automate tasks involving data in formats like Excel and CSV.

Core Features & Use Cases

  • Advanced Formulas: Leverage powerful lookup, logic, and cleaning functions.
  • Automation: Create macros with VBA or scripts with Python (Pandas) to streamline repetitive tasks.
  • Data Visualization: Utilize pivot tables and charts for insightful data representation.
  • Use Case: Combine multiple CSV files into a single, organized Excel workbook using a Python script.

Quick Start

Use the Spreadsheet Expert Pro skill to write an XLOOKUP formula to find the price of product 'XYZ' in your sales data.

Frequently Asked Questions about Spreadsheet Expert Pro

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write an XLOOKUP formula to find specific data in Excel?▼

To write an XLOOKUP formula in Excel, specify lookup value, lookup array, and return array. This skill provides expert assistance for advanced spreadsheet formulas to find specific data across .xlsx and .csv formats.

Can I use Python pandas to combine multiple CSV files into one Excel workbook?▼

Yes, you can use Python pandas to combine multiple CSV files into an organized Excel workbook. This skill generates automation scripts using pandas and openpyxl to streamline repetitive data processing tasks.

Does this spreadsheet automation support Google Sheets and LibreOffice Calc?▼

Yes, spreadsheet automation supports Google Sheets and LibreOffice Calc alongside Excel. This skill handles advanced formulas, VBA macros, and Google Apps Script for cross-platform data manipulation and processing.

What is the best way to automate repetitive spreadsheet tasks without losing original data?▼

The best way to automate repetitive spreadsheet tasks is using Python scripts or macros. This skill emphasizes non-destructive data handling and named ranges to preserve original datasets during processing and visualization.

How do I create pivot tables and charts for data visualization in Excel?▼

To create pivot tables and charts for data visualization in Excel, select your data range and insert the visualization tool. This skill assists with structuring data and generating insightful visual representations from .xlsx files.

What file formats are supported for data analysis and manipulation?▼

Supported file formats for data analysis and manipulation include .xlsx, .csv, and .tsv. This skill processes these formats using pandas and openpyxl to manage data efficiently across various spreadsheet platforms.

Related Skills

Explore More Finance & Accounting Skills→
spandiosspandios

spreadsheet

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate
IsKenKenYaIsKenKenYa

Excel Analysis

Analyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.

Community
Intermediate
gopforevergopforever

excel-generator

Automate Excel spreadsheet creation and formatting with openpyxl and xlsxwriter.

Community
Intermediate
sellersessionssellersessions

dashboard-auto-generation-client

Generate standalone HTML dashboards from CSV, Excel, JSON, or TSV files.

Community
Advanced