https://docs.easysheetpro.com/public/ 2026-04-27T16:48:39+00:00 https://docs.easysheetpro.com/public/ https://docs.easysheetpro.com/public/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-04-02T15:05:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:advancesorting&rev=1743606335&do=diff Advanced Sorting This function provides a powerful tool for organizing data, combining Excel’s standard sorting options with unique features. In addition to traditional full-sheet sorting, this function allows sorting of individual columns without affecting other data in the sheet. It is accessed from the EasySheet Pro ribbon and opens a side panel displaying available operations. text/html 2025-03-31T14:33:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:aggregatedata&rev=1743431591&do=diff Aggregate Data This function allows you to group datasets based on a user-defined time unit, such as days, months, or years. It is particularly useful for trend analysis or summarizing data over specific time intervals. EasyHeadr™ Engine automatically recognizes date columns and proposes columns with numeric values ​​for aggregation It is accessed from the EasySheet Pro ribbon. text/html 2025-03-31T14:41:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:automaticupdate&rev=1743432097&do=diff Automatic Update The Automation feature in EasySheet Pro is a powerful tool that enables users to create, manage, and execute automation workflows for copying and transferring data between Excel sheets. Notes Automations are saved locally Path: AppData\Local\EasySheetPro\EasySheetAuto text/html 2025-03-31T14:34:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:createpivot&rev=1743431671&do=diff Create Pivot This feature provides a guided process for creating pivot tables. It is accessed directly from the EasySheet Pro ribbon. Notes Automatic validation and correction of column names Handles duplicate names in headers Automatically detects numeric columns text/html 2025-04-02T15:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:dataanalysis&rev=1743606596&do=diff Data analysis Data analysis is a fundamental process for understanding information contained in large amounts of structured data. Through advanced tools, it is possible to identify patterns, detect anomalies, and evaluate data quality efficiently. text/html 2025-03-31T14:40:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:databaseconnection&rev=1743432016&do=diff Database Connection This feature allows users to seamlessly manage data from various file formats and databases, ensuring smooth integration and efficient data handling. It is accessed from the EasySheet Pro ribbon and opens a side panel for import and export operations. text/html 2025-04-02T15:05:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:datacleaning&rev=1743606318&do=diff Data Cleaning The Data Cleaning functionality provides a range of tools to manipulate and clean data within selected cells. It is accessed from the EasySheet Pro ribbon and opens a side panel displaying all available operations. Notes Every operation can be undone using the UNDO button in the EasySheet Pro ribbon. text/html 2025-04-02T15:05:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:datacomparison&rev=1743606348&do=diff Data Comparison This feature allows you to compare two columns of data using different criteria, making it easy to identify differences or matches. It is accessed from the EasySheet Pro ribbon and opens a side panel for column selection. Notes The worksheet must have headers in the first row text/html 2025-04-02T15:10:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:datacorrelation&rev=1743606636&do=diff Data correlation Data correlation analysis is an essential tool in data analysis, used to measure the relationship between two or more numerical variables. This process helps identify hidden patterns in the data and supports decision-making based on statistical evidence. text/html 2025-04-02T15:08:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:datageneration&rev=1743606494&do=diff Data Generation The Data Generation feature allows users to quickly create dummy data in one or more spreadsheet columns. This function is especially useful for developers and analysts who need to populate test data for formulas, formatting, or functionality testing without manually entering large amounts of information. text/html 2025-03-31T14:40:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:datasearch&rev=1743432045&do=diff Data Search Managing large numbers of Excel files can make it difficult to quickly locate specific information. The Data Search function provides an advanced system for searching data across multiple Excel files, improving work efficiency. Notes Sheet size limitation: text/html 2025-04-02T15:06:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:datastructuring&rev=1743606364&do=diff Data Structuring The Data Structuring feature allows you to Merge multiple columns into one or Split a single column into multiple columns. It is accessed from the EasySheet Pro ribbon and opens a side panel for column selection. Available Operations text/html 2025-03-31T14:30:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:duplicatemanager&rev=1743431438&do=diff Duplicate Manager This feature offers various options to identify and manage duplicate data in worksheets. Notes The duplicates sheet is created with a timestamp in its name. Case sensitivity affects all operations. Leading and trailing spaces are ignored during comparisons. text/html 2025-03-31T14:39:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:filemerger&rev=1743431957&do=diff File Merger This feature allows you to combine data from multiple Excel files into a single sheet. It is accessed from the EasySheet Pro ribbon and opens a dedicated window for managing the process. Notes Original files are not modified Column headers are preserved text/html 2025-03-31T14:33:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:filterdata&rev=1743431612&do=diff Filter Data This function allows you to isolate and analyze specific subsets of data within an Excel sheet. It is accessed from the EasySheet Pro ribbon. Notes Ensure the dataset does not contain errors, duplicates, or missing values, as these anomalies may affect filter effectiveness text/html 2025-04-02T15:06:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:formulassistant&rev=1743606397&do=diff Formula Assistant This feature helps users find and create Excel formulas, whether simple or complex, through a search interface and guided process. It is accessed from the EasySheet Pro ribbon and opens a dedicated form. Notes Search is case-insensitive text/html 2025-03-31T14:56:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:googlesheet&rev=1743433007&do=diff Google Sheets Integration This feature allows interaction with Google Sheets directly from Excel. It is accessed via two buttons in the ribbon. Prerequisites A Google account with access to Google Sheets Active internet connection App authorization (requested on first use) text/html 2025-04-16T12:56:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:kpi&rev=1744808207&do=diff Automatic and Manual KPI Tools This module allows you to easily and quickly calculate key financial indicators (KPIs) directly within your Excel spreadsheets. What it is and what it's for The KPI module lets you quickly calculate essential financial indicators such as ROI, ROE, ROS, EBITDA, and many others, using two distinct modes: text/html 2025-03-31T14:55:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:microsoftoffice&rev=1743432950&do=diff Microsoft Office Integration PowerPoint Export Table: Creates a new slide with the selected table, preserving formatting and styles. Supports tables of any size. Export Chart: Transfers the selected chart while maintaining data editability, colors, and formatting. text/html 2025-04-02T15:06:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:numerictools&rev=1743606376&do=diff Numeric Tools This feature provides tools for numeric formatting and date manipulation. It is accessed from the EasySheet Pro ribbon and opens a side panel with multiple options. Notes Select the appropriate range before applying functions Verify date formats when using date-related functions text/html 2025-03-31T14:34:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:pivotchart&rev=1743431694&do=diff Create Pivot Chart This feature allows users to generate advanced charts from existing pivot tables. It is accessible from the EasySheet Pro ribbon and includes a form for chart selection and configuration. Notes The panel only displays existing pivot tables text/html 2025-03-31T15:11:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:predictiveanalysis&rev=1743433863&do=diff Predictive Analysis This feature is an advanced tool designed to perform predictive analysis on financial data within Excel. Using statistical techniques such as linear regression, polynomial regression, and exponential smoothing, it helps forecast future trends based on historical data. text/html 2025-03-31T14:52:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:quickcleaning&rev=1743432729&do=diff Zoom IN – Zoom OUT Allows zooming in or out on a selected worksheet range to improve data visibility. Zoom IN: enlarges the content of the selected range. Zoom OUT: reduces the display of the selected range for a broader view. Data Cleaning This section contains useful tools to improve data quality and readability: text/html 2025-03-31T14:48:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:quickselection&rev=1743432491&do=diff Selection Tools designed to facilitate the selection of cells with specific characteristics: Selection by Text and/or Numbers: automatically identifies and selects cells containing text, numbers, or both. Select Empty/Non-Empty Cells: allows selecting only empty or non-empty cells in a specific range. text/html 2025-03-31T14:49:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:quicksheet&rev=1743432568&do=diff Sheet Tools A collection of practical features for daily worksheet management: Merge Sheets: Merge multiple sheet with various option like combine,vertical or horizontal orientation. Compare Sheets: compares two worksheets to identify differences or similarities. text/html 2025-03-31T15:25:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:riskanalysis&rev=1743434704&do=diff Risk Analysis Risk Analysis is an advanced tool in EasySheet Pro that allows performing a series of risk assessments and simulations to evaluate and manage uncertainty in business and financial data. Notes Ensure that the selected data is suitable for the type of analysis. text/html 2025-03-31T14:41:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:sheetsnapshot&rev=1743432069&do=diff Sheet Snapshot The Sheet Snapshot feature in EasySheet Pro is one of the add-in's most powerful tools, designed for version management and change tracking in Excel spreadsheets. This functionality allows users to create “snapshots” of a worksheet at specific moments, capturing the current state of data, formulas, and formatting. It is accessed from the EasySheet Pro ribbon and opens a side panel displaying the list of saved snapshots for the current sheet, along with three buttons: Add, Remove… text/html 2025-04-16T12:58:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:sidebar&rev=1744808316&do=diff EasySheet Pro Documentation Introduction * Welcome to EasySheet Pro! * Add-in Structure RIBBON - EasySheet Pro Data Management * Data Cleaning * Duplicate Manager * Advanced Sorting * Summarize Data * Data Comparison * Data Structuring * Numeric Tools * VLOOKUP * Aggregate Data * Filter Data * Formula Assistant * Create Pivot * Create Pivot Chart Tools * File Merger * Data Generation * Database Connection * Data Search * Sheet Snapshot * Automat… text/html 2025-03-28T08:57:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:start&rev=1743152224&do=diff Welcome to EasySheet Pro! EasySheet Pro is a powerful add-in for Microsoft Excel that enhances your spreadsheet with numerous advanced features for data management, analysis, and processing. With EasySheet Pro, transforming complex tasks into simple and fast operations has never been easier. This innovative tool is designed to simplify and optimize your daily work, helping you save valuable time and improve productivity. text/html 2025-03-31T15:18:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:statisticalanalysis&rev=1743434329&do=diff Statistical Analysis Statistical Analysis is a powerful tool designed to perform a wide range of statistical analyses directly in Excel. This function allows you to conduct statistical tests, distribute frequencies, create contingency tables, and much more, making data analysis fast and efficient. text/html 2025-03-28T10:02:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:structure&rev=1743156150&do=diff Add-in Structure EasySheet Pro is organized into four main ribbons, each dedicated to specific functions: EasySheet Pro The EasySheet Pro ribbon is the core of the add-in, bringing together most of the essential tools for data management and analysis. text/html 2025-04-02T09:17:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:summarizedata&rev=1743585454&do=diff Summarize Data Summarize Data is a powerful tool that automatically analyzes and summarizes the contents of your Excel sheet. It helps you understand your data without needing formulas, filters, or manual grouping. Thanks to the EasyHeadr™ engine text/html 2025-04-02T09:22:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:textanalysis&rev=1743585766&do=diff Text Analysis Text Analysis allows performing advanced text analysis directly within Excel. It includes Text Analytics, Sentiment Analysis, and Keyword Analysis, providing a detailed summary of textual features and semantic trends. Notes If the selected data range is invalid, the user will receive an error message. text/html 2025-03-31T14:32:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.easysheetpro.com/public/doku.php?id=en:vlookup&rev=1743431563&do=diff VLOOKUP This feature provides an enhanced version of VLOOKUP with EasyHeadr™ Engine (automatic key column detection and intelligent data searching across different sheets). It is accessed from the EasySheet Pro ribbon. Notes Key column identification is fully automatic