Search: "Excel analysis"

#scenario model #financial modeling #excel planning

excel Advanced

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

#sql #churn analysis #customer retention

data Advanced

ChatGPT prompt for building a SQL query to analyze customer churn patterns

Act as a senior data analyst specializing in customer retention. I need SQL que...

excel Intermediate

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#budget analysis #variance #financial template

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#conditional formatting #dashboard #icon sets

Excel Conditional Formatting Advanced Rules Dashboard

Help me set up advanced conditional formatting rules in Excel for a [sales / HR ...

#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...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

#financial-model #three-statement #excel

Excel Financial Model Three-Statement Integration

Build a three-statement financial model in Excel for [company type, e.g., a SaaS...

data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...

#pandas #python #groupby

#financial-model #seed-round #fundraising

finance advanced

Startup Fundraising Financial Model for Seed Round

Build a financial model for a seed-stage fundraise for [startup type]. Cover: 1)...

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#excel #array-formulas #sequence

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...

#business #requirements #brd

business intermediate

Business Requirements Document Template for Software Projects

You are a business analyst and product manager. I need to write a Business Requi...

customer-service intermediate

Customer Satisfaction Survey Design and Analysis Guide

You are a customer experience researcher. I need to design a customer satisfacti...

#customer-service #survey #nps

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#power query #data cleaning #ETL

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a...

#pivot table #grouping #calculated fields

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#scenario manager #goal seek #sensitivity analysis

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...