Search: "Excel analysis"

#excel #test-data #random

excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#finance #variance #forecast

finance Intermediate

Explain a Variance Between Forecast and Actuals

Act as an FP&A analyst. We forecasted {{metric, e.g., Q1 revenue}} at {{forecast...

#swot #product launch #strategy

business Intermediate

SWOT Analysis for New Product Launch

Conduct a detailed SWOT analysis for the launch of [PRODUCT] in the [MARKET] seg...

#sql #cohort analysis #retention

SQL Query to Find User Cohort Retention by Month

Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...

#financial model #startup #three statement

finance Advanced

Three-Statement Financial Model Outline for Startup

Outline a three-statement financial model for a [BUSINESS TYPE] startup over 36 ...

Write a SQL Query for Cohort Retention Analysis

Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...

#data #sql #cohort

#excel #cohort #retention

excel Advanced

Build a Cohort Retention Heatmap in Excel

I have customer signup and activity data in Excel. Help me build a monthly cohor...

excel Advanced

Forecast Sales with Excel FORECAST.ETS

I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...

#excel #forecast #ets

#data validation #dropdown lists #dependent dropdowns

excel Intermediate

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#data quality #anomaly detection #data monitoring

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#debugging #api #rest api

coding Advanced

ChatGPT prompt for debugging a REST API that returns 500 errors intermittently

Act as a senior backend engineer specializing in API reliability and debugging. ...

excel Advanced

Excel Macro to Automate Monthly Report

Write a VBA macro for Excel that automates my monthly reporting process. The mac...

#excel #vba #macro

#finance #investing #portfolio

finance Intermediate

Investment Portfolio Review and Rebalancing Guide

Conduct a portfolio review and create a rebalancing plan for the following inves...

#pricing strategy #go-to-market #competitive analysis

business advanced

Pricing Strategy Framework New Product Market Entry

Help me develop a pricing strategy for a new [product / service] entering the [m...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#compensation #benchmarking #hr

hr advanced

Compensation Benchmarking Analysis Template for HR Teams

Create a compensation benchmarking analysis framework for [role or department] a...

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#business #pitch #startup

business intermediate

Startup Pitch Competition Preparation Scoring Framework Guide

Prepare a startup for a pitch competition with a comprehensive preparation frame...

customer-service intermediate

NPS Survey Designer with Analysis Framework

Help me design an NPS survey program and analysis framework. Business details: ...

#customer-service #nps #survey

#business #swot #strategy

business Advanced

ChatGPT Prompt: SWOT Analysis Workshop Facilitation Plan With Prompts

You are a strategic planning facilitator. Design a 90-minute SWOT workshop for a...

#excel formulas #dynamic arrays #dashboard

excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#excel #pivot table #sales analysis

excel Intermediate

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

#data #ab testing #statistics

A/B Test Power Analysis and Sample Size Calculator Walkthrough

Act as a statistics tutor for product analysts. Walk me through a complete power...