Skip to main content

How to Use XcelGenie

XcelGenie is your personal AI assistant for Excel, making advanced data manipulation, analysis, and reporting effortless. Follow these steps to get started and harness the full power of XcelGenie.

1. Using Natural Language Commands​

XcelGenie works by understanding natural language commands. You can simply type your command in the input box, and XcelGenie will instantly interpret it and perform the corresponding operation. For example:

Example Commands:​

  • "Generate a summary report for sales by region": XcelGenie will analyze the dataset and generate a summary of sales by region.
  • "Create a pivot table for revenue over time": XcelGenie will automatically create a pivot table that summarizes revenue over time.
  • "Clean up data by removing duplicates and fixing formatting": XcelGenie will clean your data, removing duplicate rows and fixing any inconsistencies in the formatting.

2. Working with Data​

Automate Data Cleaning​

XcelGenie can automatically clean and transform your data based on your specifications:

  • Remove duplicates
  • Format numbers, dates, and text
  • Fix common data entry errors

To clean your data, simply type a command like:

  • "Remove all duplicate rows"
  • "Format all dates in YYYY-MM-DD format"

Generate Reports​

XcelGenie can create detailed reports with charts, tables, and summaries.

3. Workflows​

XcelGenie enables you to create custom workflows that automate complex data operations within Excel. These workflows are defined by a series of commands or scripts that you can execute directly within your workspace. By leveraging XcelGenie's AI capabilities, you can build personalized workflows to tackle a variety of tasks, from basic data operations to advanced analytics.

Creating a Custom Workflow​

To create a custom workflow, you simply need to define a sequence of commands or scripts that will automate a specific set of operations on your data. These commands can range from basic data operations, such as sorting or filtering data, to more complex processes like data transformations or advanced analytics.

Here’s a general structure for creating workflows:

  1. Define Your Objective: Start by identifying the goal of your workflow. What data manipulation or analysis do you want to automate?

  2. Break It Down into Steps: Consider the tasks that need to be performed in sequence. For example, if you're cleaning a dataset, you may want to start by filtering data, followed by removing duplicates, and then standardizing formats.

  3. Write Your Commands: Each task in your workflow is executed by writing a specific command. Commands can be executed directly or linked together in a script. Example commands include:

    • "Show me the first 10 rows of data"
    • "Filter data where Department is 'Marketing'"
    • "Calculate the total sales by region"

  4. Execute the Workflow: Once you’ve written your commands, you can execute them one by one or as a script. XcelGenie will process the commands sequentially and provide real-time results.

Example Workflow 1: Basic Data Cleaning​

If your goal is to clean data in an Excel sheet, you might create a workflow that:

  1. Displays the first 10 rows of data.
  2. Removes any rows with missing values.
  3. Standardizes date formats.

You can create this workflow by writing the following commands:

  • "Show me the first 10 rows of data"
  • "Remove rows with missing values"
  • "Fix the inconsistent date formats in the hire date column"

Once executed, XcelGenie will perform these steps automatically on your dataset, resulting in a cleaned version of your data.

Example Workflow 2: Data Transformation and Summarization​

Suppose you want to analyze employee performance by department. You can create a custom workflow to:

  1. Filter data for employees in the "Sales" department.
  2. Calculate the average performance score by department.
  3. Sort the data by performance score in descending order.

Your commands might look like this:

  • "Filter data where Department is 'Sales'"
  • "Calculate the average performance score by department"
  • "Sort the data by Performance Score in descending order"

Once you execute these commands, XcelGenie will generate a summary and sort the employees by their performance score.

Example Workflow 3: Advanced Data Analytics​

If you're analyzing sales data and want to predict future sales, you can create a more advanced workflow using regression models. For example, you can:

  1. Perform linear regression to predict sales based on quantity.
  2. Calculate growth rates for sales month-over-month.
  3. Identify trends in the sales data.

The commands for this workflow could be:

  • "Perform linear regression to predict sales based on quantity"
  • "Calculate growth rates for sales month-over-month"
  • "Identify trends in the sales data"

Executing this workflow would provide you with predictions and valuable insights about your sales performance.

Creating and Using a Custom Workflow​

To create a custom workflow, you'll define a Pandas Python script that automates a series of tasks. You can store these scripts on our website and run them whenever you need to. Here’s how to create and use a custom workflow:

  1. Write Your Script: Use Pandas to define the sequence of operations you want to automate. This can include data cleaning, transformation, summarization, visualization, and more.

    Example of a simple Pandas script:

    import pandas as pd

    # Load the Excel file
    df = pd.read_excel("your_data.xlsx")

    # Filter data for employees in 'Sales' department
    sales_data = df[df['Department'] == 'Sales']

    # Calculate the average salary for the Sales department
    avg_salary = sales_data['Salary'].mean()

    # Sort by Salary in descending order
    sorted_sales_data = sales_data.sort_values(by='Salary', ascending=False)

    # Save the processed data to a new Excel file
    sorted_sales_data.to_excel("processed_sales_data.xlsx", index=False)

4. Advanced Features​

Automate Calculations​

XcelGenie can perform complex calculations with a single command. You don’t need to manually enter formulas:

  • "Calculate the average sales for each product category"
  • "Sum total revenue for Q1 and Q2"

5. Sample Test Files​

To help you get started with testing and experimenting with XcelGenie, here are some sample test files:

You can download these files and use them to practice various commands and operations in XcelGenie.

6. Tips and Best Practices​

  • Be clear and specific with your commands: XcelGenie performs best when commands are straightforward. For example, instead of saying “sort data,” specify which column you want to sort.
  • Use XcelGenie for repetitive tasks: Automate routine operations like data cleaning, report generation, and formatting to save time.
  • Explore advanced features: XcelGenie has powerful AI-based features like predictive analytics and advanced data visualization that can give you deeper insights.

Start using XcelGenie today and take your Excel skills to the next level!