Data, Excel & Analytics
Excel / Google Sheets Formula Builder
Write an Excel formula to achieve the following logic: (User input: Describe desired dynamic result based on criteria).
/ Library20 results
The Library
Data, Excel & Analytics
Explain Complex Excel Formulas
Explain step-by-step how this formula works and what output it produces: (User input: Excel/Google Sheets formula)
Data, Excel & Analytics
Write Excel VBA / Google Apps Scripts
Write a (User input: VBA Macro / Google Apps Script) to automate the task of (User input: Task description).
Data, Excel & Analytics
Data Cleaning & Preparation Instructions
Outline the logical steps and operations needed to clean messy data containing (User input: Data issues, e.g., duplicates, missing dates, mixed formats).
Data, Excel & Analytics
Write Power BI DAX Formulas
Write a DAX measure for Power BI to calculate (User input: Business Metric, e.g., Year-over-Year Growth / Rolling 30-Day Average).
Data, Excel & Analytics
Formulate Data Visualization Recommendations
Recommend the absolute best chart/visualization type to display (User input: Data types and context) and explain why.
Data, Excel & Analytics
Draft Data Analysis Summaries
Summarize key trends, anomalies, and insights from this raw dataset summary: (User input).
Data, Excel & Analytics
Write Python Pandas Data Processing Code
Write Python Pandas code to import a CSV, filter by (User input: Condition), clean missing values, and group by (User input: Column).
Data, Excel & Analytics
Design Data Warehouse Schema Concepts
Suggest a star schema or snowflake database structure (Fact and Dimension tables) for modeling (User input: Business Activity).
Data, Excel & Analytics
Formulate A/B Test Hypotheses
Write a statistically valid A/B test hypothesis for testing (User input: Proposed Change) on (User input: Metric).
Data, Excel & Analytics
Calculate Business Financial Metrics
Explain the formula and calculate (User input: Metric, e.g., Customer Acquisition Cost / LTV / Churn Rate) using these inputs: (User input).
Data, Excel & Analytics
Draft Executive Dashboard Requirements
Define the primary KPIs, filter options, and visual components needed for an executive dashboard monitoring (User input: Department/Business Unit).
Data, Excel & Analytics
Identify Statistical Analysis Methods
Suggest the correct statistical test (e.g., T-test, ANOVA, Regression) to analyze the relationship between (User input: Variable A) and (User input: Variable B).
Data, Excel & Analytics
Write R Script for Data Visualization
Write R code using ggplot2 to create a chart showing (User input: Plot details) with customized labels.
Data, Excel & Analytics
Detect Data Anomalies Strategy
Outline a logical process to detect fraudulent transactions or unusual anomalies in (User input: Transaction/Event Type) data.
Data, Excel & Analytics
Automate CSV Parsing Scripts
Write a script in (User input: Language) that reads a CSV file, parses (User input: Specific Field), and exports results to JSON.
Data, Excel & Analytics
Convert Unstructured Text to Structured CSV
Extract data from this unformatted text string and output it as a clean CSV table: (User input)
Data, Excel & Analytics
Write Cohort Analysis Framework
Explain how to build a monthly cohort retention table for analyzing user retention in a (User input: Business Type).
Data, Excel & Analytics
Draft Data Privacy & Compliance Audits
List 5 essential data handling checks to ensure user data processing complies with (User input: Regulation, e.g., GDPR / HIPAA).
Data, Excel & Analytics
Formulate Predictive Modeling Steps
Outline the machine learning workflow to build a predictive model for forecasting (User input: Target Variable, e.g., Customer Churn).