Company
The Ultimate Add-in to Supercharge your Excel Productivity
Resources
Quick Links
Company
EasySheet Pro
EasyWizard™
"Advanced procedural framework for process optimization"
EasySheet Pro implements EasyWizard™, a proprietary contextual assistance architecture that transforms complex operations into standardized procedural sequences. The system guides users through optimized workflows, automatically breaking down complex processes into structured and sequential phases. This methodology eliminates the need for specialized technical skills, significantly reducing the margin of error and increasing operational efficiency.
Here are some of the features available:
EasySheet Pro - 2025
EasySheet Pro - 2025
Formula Assistant
Writing formulas in Excel requires memorizing functions, dealing with syntax errors, and debugging mistakes. EasySheet Pro’s Formula Assistant eliminates the hassle, providing a step-by-step wizard that helps you build complex formulas effortlessly.
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
Supports partial term searches
Complex formulas have a dedicated guided process
The formula database includes examples and detailed descriptions
Formulas are inserted in the correct format for Excel
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
Generates unique names for pivot tables
Automatically organizes row fields and data fields
Auto-adjusts column sizes
Numeric fields are set as data fields; non-numeric fields are set as row fields
Pivot table names are guaranteed to be unique within the workbook
For external files, the original file is not modified, and the pivot table maintains its link to the source data
Data Structuring
The Data Structuring feature allows you to Merge multiple columns into one or Split a single column into multiple columns.
Available Operations
Merge Cells
Select at least two columns to merge
Specify a delimiter (e.g., space, comma)
- Options
Create a new sheet with the result
Modify the existing sheet
The resulting column is added after the last selected column
Split Cells
Select a single column to split
Specify the delimiter character
- Options
Create a new sheet with the result
Modify the existing sheet
New columns are created based on the number of splits needed
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.
It is accessed from the EasySheet Pro ribbon.
Notes
Ensure the date column is correctly formatted as a date.
Values not recognized as dates may cause errors or incomplete results.
If the dataset contains empty cells or missing values, the function will automatically ignore them.
Allows data analysis over any time interval.
Minimizes the risk of manual errors during data processing.
Undo/Redo is not available.
Advantages
The aggregated result is returned in a new table, where each row represents a time interval, and columns display aggregated values
Reduces data complexity
Provides clearer insights
Improves decision-making support
Data aggregation consolidates detailed information into more meaningful and summarized perspectives
