Excel
Calculate Descriptive Statistics
Provide the code ([Language/Tool, e.g., Python/Pandas, R, SQL]) or Excel function(s) to calculate the following descriptive statistics for the variabl...
Suggest Data Cleaning Techniques
Suggest data cleaning techniques or generate code ([Specify Language/Tool, e.g., Python/Pandas, R, SQL]) for handling the following issue in my datase...
Suggest Data Visualization Types
Recommend the most effective type(s) of data visualization (e.g., bar chart, line chart, scatter plot, histogram, box plot, heatmap) to show the follo...
Optimize Spreadsheet Performance
My Excel workbook is performing very slowly, especially when [Describe action, e.g., 'recalculating formulas', 'filtering data', 'opening the file']....
Generate Specific Excel Formula
Write an Excel formula to [Describe the desired calculation or lookup, e.g., 'find the total sales (Column C) for the 'North' region (Column A) where...
Explain Existing Excel Formula
Explain the following Excel formula in plain language, step-by-step. Describe what each function and argument does and the overall purpose of the form...
Outline Data Cleaning Steps
Suggest a sequence of steps using Excel features and/or formulas to clean the following data issues in my spreadsheet: - Issue 1: [e.g., Remove leadin...
Create Pivot Table Layouts
Suggest an effective Pivot Table layout in Excel to answer the question: '[State your analytical question, e.g., What are the total sales per Category...
Suggest Appropriate Chart Types
Recommend the most appropriate Excel chart type(s) to visualize the following data and insight: Data Description: [e.g., Monthly website traffic over...
Generate VBA Macro Code
Write an Excel VBA macro code to perform the following repetitive task: [Clearly describe the step-by-step task, e.g., '1. Select cell A1 on Sheet 'In...
Debug VBA Macro Code
Help me debug the following Excel VBA code. Intended Functionality: [Describe what the macro is supposed to do]. Problem/Error Message: [Describe th...
Set Up Data Validation Rules
Explain how to set up an Excel data validation rule for the range [Specify cell range, e.g., C2:C100] to ensure that users can only [Describe the rest...
Combine Multiple Functions (Nested Formulas)
Help me create a complex nested Excel formula to achieve the following logic: [Describe the desired outcome based on multiple conditions, e.g., 'If th...
Create Conditional Formatting Rules
Explain how to set up an Excel conditional formatting rule for the range [Specify cell range, e.g., D2:D100] that does the following: [Describe the ru...
Generate Sample Data Sets
Generate a table of realistic sample data with [Number] rows for testing or demonstration purposes. Include the following columns: [List column header...
Find the Right Function for a Task
What is the best Excel function (or combination of functions) to accomplish this task: [Clearly describe the task, e.g., 'Calculate the average of val...
Analyze Data Trends in Excel
Suggest methods or steps using Excel to analyze trends or patterns in my dataset. My data includes [Describe columns and data types, e.g., 'monthly sa...
Brainstorm Excel Dashboard Layout Ideas
Brainstorm layout ideas for an Excel dashboard monitoring '[Dashboard Purpose, e.g., 'Project Status', 'Sales KPIs', 'Personal Budget']'. Key metrics...